Tag Archives: database

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

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