SQL Server DBA Tutorial 34- How to Create Database Snapshot in SQL Server
HTML-код
- Опубликовано: 16 сен 2024
- In this video you will learn how to create sql server database snapshot using T-SQL Script, it also demonstrates how to view the snapshots using SQL Server Management Studio, how to restore the database from the snapshot, how to revert database using database snapshot. You will also learn some real time scenarios when it is best to use snapshot options.
Blog post link for Script used in this video:
sqlage.blogspot...
Visit our website to check out SQL Server DBA Tutorial Step by Step
www.techbrother...
Man i just found out about your channel... Incredible...Your works is just fantastic...thx for sharing that with us.
Glad to hear that you liked our work. Thanks for watching!
Yours videos are incredibly useful... Thanks for sharing your knowledge...
Can you plz clear my doubt.... You said, if we need to perform some temporary calculations on the database then take a snapshot and connect to that instead of the original database. How is it different from just copying the database?
Thanks a lot. It was helpful.
Glad it helped!
thank you for your great videos, one Q: what if we want to restore only one table from snapshot? is that possible? or it will restore the whole database?
Great Video sir. Please i have a little worry. Tried creating a snapshot with two files and had issues. Any solution please?
but snapshot is readonly,, how can you make changes to it?
This was very helpful, thank you!
You are welcome Andy!
thanks a lot for sharing! your channel is soooo great! One question to this topic please: if I want to restore just one table / part of the snapshot and not the whole database, do we need to edit somehow script? Thanks Tomas
I have the same doubt??
I can't find the files tab. Also the query returns an syntax error 'near ON', any solutions to that?
can we take snapshot of views
Views are the stored queries. Are you talking about materialized views. The snapshot will be fore entire DB.