Web Development

Ask something
Discussion Locked

sql backup

0 helpful
3 replies

by ldap_pro

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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)?

thanks
aki

3 replies

by cmiller5400

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.

by tony hopkinson

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

http://www.devarticles.com/c/a/SQL-Server/Building-Your-First-SQL-Server-2000-Database/3/

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.

This discussion is closed to new replies.