Have Geek Brain

SQL Server

Hi guys, I took a snapshot of the database. Then, if I make changes, will those changes reflect the database or snapshot database?

When I take a snapshot of a database, does it create another database?

0


a source to share


2 answers


I think you may not understand what is happening here. The point of a snapshot is that you can undo all your changes to that snapshot.

It's like taking a picture of your wife while she was young. As she gets older, she will develop wrinkles, gray hair, etc., but the picture will not change. The main exception here is that you cannot bring your wife back to how she looked in the shot. Well not much money. She will always represent her, since she was at the very moment you took the picture.



This way you can change the database whatever you want and it won't affect this snapshot

It does not create another database, but represents the state of that database at the moment you took the snapshot.

+5


a source


When you make changes after the snapshot, those changes are reflected in the underlying database, but not in the snapshot database.



When you take a snapshot of a database, it does not create a new database. It only creates a sparse file that only stores the pages that you refresh after the snapshot. More details on how to work with database snapshots can be obtained from here

+1


a source






More articles:


All Articles