How do I change the backup retention period in SQL 2005?

I was unable to answer this question at my Providence, RI event this week regarding changing the backup dataretention period.  Here’s the answer I got from where else but the SQL2005 Online Books: To set the backup retention duration In Object Explorer, right-click a server and select Properties. Click the Database settings node. Under Backup/Restore,…


Renaming SA in SQL 2005

I had been asked last week if you could rename the SA account.  I replied “No you can not, it’s protected.”  Oh how wrong can I be?  Apparently very wrong.  My illustrious colleague Matt Hester pointed me to a blog that has the exact procedure you need to follow to do this and improve your…


How to: Rename a Stand-Alone Instance of SQL Server 2005

One of the questions I was asked at an event last week was about doing a side-by-side migration to a new SQL Server 2005 machine from an old SQL Server 2000 machine.    Q:  Can i rename the new machine to have the same name as the old machine once I remove the old machine…

1

SQL Server 2005 Mirroring – "I lost my witness your Honor!"

Question 1: Does the Witness only monitor the SQL servers or does it handle any transactions? Answer 1: From the link below: “The witness server assists the principal or mirror in forming a quorum. If a witness server is present, a loss of either the principal database or the mirror database leaves two servers to…

1

SQL TechNet Events in NC, AL and GA this month…

I’ve done several events this month, Raleigh, Charlotte and Birmingham, AL and will be doing Atlanta on Thursday.  If you attended and had any questions that I was unable to answer at the event, please post them here so that everyone can see the answers. One question I was asked, which I wasnt sure of,…


Do you have problems managing kiosk systems?

Having problems managing systems in internet cafes, libraries or student system?  Then take a look at this new tool that is currently available in beta!!! Microsoft created the Shared Computer Toolkit to help make shared computers more reliable and less time-consuming to maintain. Unlike personal computers, shared computers are: • Used by many different people…


John Baker’s TechNet Events this Quarter (Apr-Jun) in FL, GA, NC and SC

NEW! Get a first look at the next version of Microsoft™s SQL Server product.  From security enhancements to service availability and replication of data, this TechNet Briefing is a must see for IT Professionals managing company data.  In addition to the SQL topic, a technical overview of Service Pack 1 (SP1) for Microsoft™s Windows Server…

1

Windows Server Update Services Release Candidate Open Evaluation

Windows Server Update Services Release Candidate Open Evaluation The Windows Server Update Services (WSUS) Open Evaluation Program (OEP) lets you evaluate the Release Candidate of WSUS in a non-production environment. This version is not supported and can be used in a test environment only. The instructions, below, will help you download the software and documentation…


Deploying Windows XP SP2??? Then you need the latest Windows Application Compatibility Toolkit Version 4.0

Get the latest Windows Application Compatibility Toolkit 4.0 located at: http://www.microsoft.com/downloads/details.aspx?FamilyId=D7D08414-0136-492F-9AD9-CE8AEB7500C7&displaylang=en The first questions that many customers ask once they decide to deploy Windows XP with Service Pack 2 (SP2) are whether their existing applications are compatible and how expensive it will be to determine if they are. The Application Compatibility Toolkit (ACT) 4.0 was…