Database Snapshot Creat/Drop/Restore SQL Script
'Database Snapshot Creat/Drop/Restore SQL Script for Single or multiple data files of databases. The four steps are described in the script, but here are the summaries:
-
This SQL script to create database snapshot for ALL databases having a single data file except system DBs. It generates the SQL Query as OUTPUT.
-
This SQL script to create database snapshot for ALL databases having a multiple data file except system DBs. It generates the SQL Query as OUTPUT.
-
DROP the created database snapshots (Pl. make changes in sql query acc. to your requirements.)
-
Restore data from snapshot script (Pl. make changes in sql query acc. to your requirements.)'...
http://www.sqlservercentral.com/scripts/database+Snapshot+creation/142788/
Trackbacks
Keine Trackbacks
Die Kommentarfunktion wurde vom Besitzer dieses Blogs in diesem Eintrag deaktiviert.
Kommentare
Ansicht der Kommentare: Linear | Verschachtelt