mercredi 4 mars 2015

Restore databases from prod to test server with data over say X days in sql server 2005


We've got a list from app owners to restore say 20 databases from a total of 100 available production server DB's onto a test server on weekly basis.


A.Moreover, they require it in a way that backup that would be occurring should contain data of last 60-90 days for all the above 20 databases.


I am not sure if point A) can be achieved.If yes, kindly give suggestions how can i go around this to automate the backups as said above,


Thanks!





Aucun commentaire:

Enregistrer un commentaire