Home › SQL Server › SQL Server Mirroring

SQL Server Database Mirroring - Creating and using database snapshots on the mirror server


Creating a Snapshot of the Mirror Database

-- Database Name: AdventureWorks
-- Snapshot Name: AdventureWorks_15Nov2009

-- To run on Mirror Server
CREATE DATABASE AdventureWorks_15Nov2009
ON (NAME = 'datafile', FILENAME = 'F:\AdventureWorks_15Nov2009.SNP')
   AS SNAPSHOT OF AdventureWorks

Dropping a Database Snapshot

-- Snapshot Name: AdventureWorks_15Nov2009
DROP DATABASE AdventureWorks_15Nov2009

Share |
 Cant find the page you are looking for?
 Help us to improve by adding the content that you are looking for.
 Leave a feedback
 We look forward to hear your comments and feedback.