![]() ![]() So, you can use this to identify database snapshots. Notice that this column is mostly “null” except when if it has a value. In this result, pay attention to the “” column. For that, I’m going to do a select and use from the Master db the view named “.”: So, here’s another way to use T-SQL to identify all database snapshots. ![]() I will get all of them listed including the snapshots. If I use the following T-SQL command to list all my databases: Now, I go to SSMS and verify my new database snapshot exist by going into the ‘Object Explorer’ and looking under ‘Database Shashots’ folder. ‘C:\Program Files\Microsoft SQL Server\MSSQL11.MSQLDENALICTP3\MSSQL\DATA\AdventureWorks_Data_0001.ss’ ) So, first we need to create a new db snapshot of my AdventureWorks database using T-SQL Script:ĬREATE DATABASE AdventureWorks_dbSnapShot_0001 ON I’ve been using a lot Hyper-V Snapshot features and recently (Thanks to Chad Miller) I got the chance to create and test a few. I just couldn’t believe that I’ve been missing creating SQL database snapshots but sometimes having so much work make you blind. Just a quick blog on spotting your Database Snaphots. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |