Copy Database Wizard - Using SMO
This lesson demonstrates how to make a copy of a database while leaving the source database online. The secret? The wizard makes the copy object by object using SQL Management Objects (SMO).
|
|
|
|
Duration:
|
2
mins
2
secs
|
|
Skill Level:
|
100
|
|
Rating:
|
4.25
out of 5
|
|
Publish Date:
|
November 13, 2009
|
|
|
|
About the Author
|
|
Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.
|
|
References
|
There are no downloads or recommended reading links for this video
|
|
|
Comments
|
|
Good One
|
|
Daren Lewis on
11/25/2009
I am going to share this ... this can be used a lot.
|
|
|
How we can do this in SQLSERVER 2008
|
|
|
so if you copy an online database is there a possibility that the related tables could become out of sync; as a parent table is probably copied first and the child table second and a new transaction comes in between the table creations?
|
|
|
like how the pros and cons where explained
|
|
Zohorul Islam on
10/28/2011
very good
|
Must Be Logged In
|