Restoring Model Database and Tempdb in SQL Server 2000

You Need To Be Ready To Restore the Model Database - Don't Worry About Tempdb

Description:

The model database should be backed up fairly regularly. Basically, the model template serves as a template for all future databases that are created on the server. To restore the model database, see the Lost Database - Simple model.

The tempdb database doesn't and shouldn't ever be backed up. It is actually recreated every time SQL Server is started.

Looking for SQL 2005?

I am currently working on SQL Server 2005 Backup and Recovery Exercises and will have the first exercises posted by 10/31/2008. SQL Server 2005 Backup and Recovery exercises will include GUI examples, T-SQL examples, and I'll also be including Video tutorials so you can easily follow along with the backup and recovery exercises. SQL Server 2008 exercises will be posted towards the end of 2008.

Contact Me

Please contact me with any suggestions that you have for the web site. I'd also appreciate any feedback on how the exercises worked for you, and how the site helped you put together a comprehensive backup and recovery plan - or even helped to save your data after a disaster. Contact Me Here.