backup and restore - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

backup and restore

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-02-03 : 08:19:16

despina writes "How can i create a backup from a database not manually and then to restore it in a new database with the same rights."

nr
SQLTeam MVY

12543 Posts

Posted - 2005-02-03 : 09:04:49

Backup
http://www.mindsdoor.net/SQLAdmin/BackupAllDatabases.html
Restore
http://www.mindsdoor.net/SQLAdmin/s_CopyLatestBackup.html
http://www.mindsdoor.net/SQLAdmin/s_RestoreLatestBackup.html

Schedule the backup on the source server and the copy and restore on the local server.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources