I need to know what is the best way and how to create a script or procedure where I can create a backup of a database on one server(production) and restore that database onto another server(test). The database currently exists on both servers but I want to keep the data on test up to date with production server. Does anyone know the best way to do this and possibly how to do this. I have heard about using SQL Server Agent but the problem is when I view both servers in SSMS only one server has SQL Server Agent listed the other server doesn't.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Help w/ script to backup db on server and restore on another servers
- Thread starter mldardy
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question