Error 3154 says the backup set holds a backup of a database other than the existing database. Use WITH REPLACE in RESTORE, or drop the old database first.
SQL SERVER – Fix : Error : Msg 3117, Level 16, State 4 The log or differential backup cannot be restored because no files are ready to rollforward
Msg 3117 means the log or differential backup cannot be restored because no files are ready to rollforward. Restore the full backup WITH NORECOVERY first.
SQL SERVER – FIX : Error : msg 2540 – The system cannot self repair this error
Msg 2540 means the system cannot self repair this error, usually corrupt metadata or system files. My fix order: restore the backup, DBCC repair, check hardware.
SQL SERVER – T-SQL Script to Attach and Detach Database
Move a database to a new server in three steps: Detach Database with sp_detach_db, copy the data and log files, then attach it again with CREATE DATABASE.
SQL SERVER – 2005 – SSMS – Enable Autogrowth Database Property
How to enable Autogrowth for a database in SSMS: open the database Properties, go to Files and click the small button in the Autogrowth column.
SQL SERVER – Recovery Models and Selection
SQL Server offers three recovery models: full, simple and bulk-logged. Here is when to select each one, based on how much data loss you can accept.
SQL SERVER – MS TechNet : Storage Top 10 Best Practices
My pick of the Storage Top 10 Best Practices from MS TechNet: know your IO, keep designs simple, put logs on RAID 1+0, isolate logs from data and plan TEMPDB.