After you installed the script:

1. Open SSMS

2. Select Tools | Options | Keyboard | Query Shortcuts

3. Choose any...

Operations team patches all servers on the 3rd Saturday night of every month (from mid night to Sunday 6am). So that's my maintenance window too for most of my database...

Thanks Gail. I edited my original post accordingly.

The switch to Full/Bulk-logged recovery model takes effect only after you take a full backup. Check this article for more information. Also Paul Randall wrote on his blog an article/script...

I would say DBA + Virtualization/SysAdmin/Security knowledge.

Start from here BrentOzar.com[/url]

nplace6530 (2/2/2010)

---

Hi All

I was also a little concerned about turning on cmdshell so I have made the following changes to the original script which shows backup file data but does...