Questions Linux Laravel Mysql Ubuntu Git Menu

HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin

How to create a database snapshot in SQL Server with SSMS GUI, not SQL code

Tags:

sql-server-2005

snapshot

How to create a database snapshot in SQL Server with SSMS GUI? I can't find the menu of that action.

Thanks.

like image

908

asked Sep 17 '10 08:09

Just a learner

1 Answers

Taken from the msdn article -

"The only way to create a snapshot is to use Transact-SQL."

like image

147

answered Oct 21 '22 17:10

Sachin Shanbhag

Sign in to Comment

Related questions
                            
                                SQL - Subtracting a depleting value from rows
                            
                                Grouping SQL Results based on order
                            
                                ADO cannot access SQL Server XML type column using native client (SQLNCLI)
                            
                                Why does the same Linq-to-SQL query consume much more CPU time on the database server for a different project?
                            
                                What is the best method in passing a large number of parameters in SQL Server
                            
                                Count distinct and Null value is eliminated by an aggregate
                            
                                Changing Database Names and Cross Database Queries In Stored Procedures
                            
                                SQL Server Full Text Search using CONTAINS, FORMSOF, NEAR for multiple search words
                            
                                ORDER BY with Case-Statement DESC
                            
                                Sql server COMMIT without Tran | Transaction?
                            
                                How to make conversions from varchar to datetime deterministic?
                            
                                Unable to restore SQL Server database - 'The file or filegroup <logfilename> cannot be selected for this operation.'
                            
                                Deploying Sql Server Reporting Services reports on production boxes
                            
                                How to find what caused errors reported in a SQL Server profiler trace?
                            
                                Store time of the day in SQL
                            
                                Changing column constraint null/not null = rowguid replication error
                            
                                SSIS Script Component Write to Variable
                            
                                Local Report vs Server report in ASP .Net Report viewer control
                            
                                Equivalent of Debug.Assert for SQL Server
                            
                                Why does "SELECT DISTINCT a, b FROM..." return fewer records than "SELECT DISTINCT A + '|' + B FROM..."?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With