Tag Archives: SQL Server 2005

SQL Server 2005 Disaster Recovery

First, screaming and running around in a circle might help alleviate the built up tension. Especially if you don’t have a good and tested plan. If we’re dealing with a Simple Recovery Model database, we can restore the full backup … Continue reading

Posted in Miscellany | Tagged , , | Leave a comment

Managing SQL Server 2005 Security

The term ‘Principals’ in the following table refers to authenticated identities in SQL Server; ‘Securables’ refers to objects that SQL Server regulates access to (databases, keys, users, logins, etc.) Level Principals Notes Windows Windows Group Securables include files and registry … Continue reading

Posted in Miscellany | Tagged , , | Leave a comment

SQL Server 2005 Backups

The Types There are 7 different types of backup available in SQL Server 2005: 1) Full (which is not the same as the Full Recovery Model) 2) Transaction Log 3) Tail-log 4) Differential 5) File / Filegroup 6) Partial 7) … Continue reading

Posted in Miscellany | Tagged , , , | Leave a comment

Recovery Models in SQL Server 2005 – Part 2

I posted about recovery models back in January but I wanted to do another short post that explained them a little better now that I understand them better! There are 3 recovery models used in SQL Server 2005: 1) Simple … Continue reading

Posted in Miscellany | Tagged , , | 1 Comment

SQL Server Data Storage

The MDF All db’s have a primary data file: the .mdf file. But secondary data files are (.ndf) are also allowed. The default location for all of these is: C:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\Data where ‘n’ is a unique number identifying … Continue reading

Posted in Miscellany | Tagged , , , | Leave a comment

Recovery Models in SQL Server 2005

Knowing what recovery model your database is using has important ramifications for database administration and management, especially during recovery. And even more especially, Disaster Recovery! The following code will show the recovery model for all your databases that aren’t system … Continue reading

Posted in Miscellany | Tagged , , , | 1 Comment

SQL Server 2005 SP3

Microsoft quietly released a new service pack for SQL Server 2005 (Development release date November 24, 2008 ) on December 15. You can learn how to find it here or here but that’s not the whole story. Upgrading non-Express editions … Continue reading

Posted in Miscellany | Tagged , , , , | Leave a comment