Web Development

General discussion


sql backup

By ldap_pro ·
hi all

what do i need to restore a sql server?

i manauly backed up under databases the system databases and the organization databases.

there is also the database itself that i should backup. can i just stop the service and copy those files (mdf and ldf files)?


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by cmiller5400 In reply to sql backup

You should backup, master, model, msdb and your user databases. Using maintenance plans for your databases, you can schedule these and dump them to a drive to backup. Each database will create a file to backup. You then can restore each database to the server once rebuilt. The exception is the master database, it requires a little more work to restore. I sugguest that you get a copy of the book MCSE Microsoft SQL Server 2000 System Administration by Microsoft. It is an excellent book and explains this in detail. Also, Microsoft's site has a plethora of information on SQL recovery etc.

Collapse -

by Tony Hopkinson In reply to sql backup

No don't do that, resore after a configuration change and you could break the entire thing.

You need to back up Master before every config change (add inner login, database etc)

MSDB every time you chnage a scheduled job

and your databases on an sensible basis.

If you are using the full product run up enterprise.

The TSQL command is BACKUP
This might give you a few ideas


you can use the scheduler to do a timed backup as well.
Again it's easier from enterprise. but there is a stored procedurre to add a job to teh agent, has lots of parameters though.

Collapse -

by ldap_pro In reply to sql backup

This question was closed by the author

Related Discussions

Related Forums