How to automate DB backup/restore ? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to automate DB backup/restore ?

am relatively new to DBA activities. Can someone tell me how to schedule a job which will help in DB Backup & Restore?( total of 7 databases from Live server to Reporting Server – both servers running SQL Ver 7.0). Do i need to write some T-SQL script to do this job? thanks
Anand link to explain the scenario And also refer to these handful of articles about database maintenance plans : Also refer to books online for more information on these Maint.plans.
If possible deploy log shipping which is suitable to your requirement. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.