Subscribe to this blog
Archives: March 2012
Why I don’t like maintenance plans
If you create a maintenance plan (SQL 9.0.3042) to backup databases and select All databases as below;
Then at some point in the future if one of the databases is taken offline the job created by the maintenance plan will fail.
From what I have seen the job will still…
0 comments, 316 reads
Posted in SQL Server 365 on 16 March 2012
How Resilient Is Your Recovery Plan?
In this modern age of technology DBA’s face an ever increasing demand from businesses; our databases must perform, be secure, highly available and scalable and equally as important recoverable. There is an obsession with the 5 9’s within the industry, and rightly so, but just how resilient is your recovery…
0 comments, 274 reads
Posted in SQL Server 365 on 14 March 2012
A Script A Day Finished!
Well that's it, my "A Script A Day" series is finished. I hope you found the scripts I provided useful, I've used all the scripts in real world DBA tasks. I tried to provide a variety of scripts covering a number of different areas. This series I feel will appeal more to…
0 comments, 274 reads
Posted in SQL Server 365 on 3 March 2012
A Script A Day - Day 29 - The Importance of Being Idle
Today’s script is also one I used in my migration on Wednesday. It again uses string manipulation to generate a script, this time the restore database script. Now granted this quick script wouldn't work if there are any secondary data files and is reliant on the logical file names and file locations…
0 comments, 226 reads
Posted in SQL Server 365 on 2 March 2012
A Script A Day - Day 28 - String Manipulation
Today’s script is one that I used earlier this week. On Thursday I migrated a server from SQL Server 200 to SQL Server 2008 R2. Now I love migrations, I don’t think I’m weird but I buzz off the addrenaline rush when working under pressure and I get a great…
0 comments, 225 reads
Posted in SQL Server 365 on 2 March 2012