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 2005 Forums
 Transact-SQL (2005)
 DATABASE BACKUP AND RESTORE SCRIPT

Author  Topic 

jagpalsingh4
Starting Member

7 Posts

Posted - 2008-03-04 : 07:54:03
Hello ,

can anybody tell me how can we make DATABASE BACKUP AND RESTORE SCRIPT through t-sql .And thn i like to make a schedular that everymonth database backup and restore query run automaticaaly according to schedular.

regards


sql dba
jagpalsingh

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-03-04 : 08:12:39
Are you really a sql dba?

Have a look in the script library or read BOL (Books Online).
Go to Top of Page
   

- Advertisement -