Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Snapshot Database

Author  Topic 

ksr39
Posting Yak Master

193 Posts

Posted - 2012-08-02 : 01:07:49
Hi Experts,

I have a small doubt on Snapshot db's, please clarify or correct me. As snapshot databases are a static view db's can we do any DML (i.e. I, U, D) operations on that snapshot database? If so how the snapshot database to be stored or altered.
Please let me know about this…
Thank you all in advance.

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2012-08-02 : 01:54:06

http://blog.sqlauthority.com/2010/04/05/sql-server-2008-introduction-to-snapshot-database-restore-from-snapshot/

--------------------------
http://connectsql.blogspot.com/
Go to Top of Page

ksr39
Posting Yak Master

193 Posts

Posted - 2012-08-02 : 03:53:05
Thank you very much Lionofdezert for your link it helped me.
Go to Top of Page
   

- Advertisement -