Using the Copy Database Wizard

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Andy Warren » Using the Copy Database Wizard

24 posts, Page 1 of 3

1 2 3 »»»

Using the Copy Database Wizard

Rate Topic

Display Mode

Topic Options

Author

Message

Andy Warren

Posted Saturday, July 06, 2002 12:00 AM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/awarren/usingthecopydatabasewizard.asp>http://www.sqlservercentral.com/columnists/awarren/usingthecopydatabasewizard.asp

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #5264

ALZDBA

Posted Thursday, July 18, 2002 7:20 AM

SSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 6:25 AM
Points: 6,861, Visits: 8,045

It is a nice wizard, but keep in mind it DETACHes the original db for a litle while, and hereby generates unavailability of your originating db.

Johan

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere w00t

- How to post Performance Problems
- How to post data/code to get the best help

- How to prevent a sore throat after hours of presenting ppt ?

"press F1 for solution", "press shift+F1 for urgent solution" BigGrin

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me Hehe

Post #36905

Andy Warren

Posted Thursday, July 18, 2002 8:40 AM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

Thats correct.

Andy
http://www.sqlservercentral.com/columnists/awarren/

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #36906

vkhabas

Posted Friday, July 19, 2002 10:04 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 9:28 AM
Points: 2, Visits: 44

No any information about coping master, msdb, and model databases between MS SQL Servers with different versions.
Is it possible to move this databases from v.7 to v.2000?

Post #36907

Andy Warren

Posted Friday, July 19, 2002 10:52 AM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

You cant move system databases using the wizard. You can detach/copy/move both model and msdb if you want to.

Andy
http://www.sqlservercentral.com/columnists/awarren/

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #36908

danw

Posted Friday, July 19, 2002 2:25 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 27, 2012 10:43 PM
Points: 126, Visits: 56

The code behind this wizard is very poorly written.
Try using it on a system that has 200 or more databases... it would take a Cray to make it all the way through the wizard. It uses a cursor to step through each database and calculate the size only it takes forever. I bet the cursor is setup wrong.

Post #36909

Andy Warren

Posted Friday, July 19, 2002 2:40 PM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

Have to admit I didnt test it on 200 dbs. I wouldnt use it for 200 anyway, easier to write a little code to detach and reattach, do it all at once. I'll look again to see what it's running behind the scenes.

Andy
http://www.sqlservercentral.com/columnists/awarren/

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #36910

Andy Warren

Posted Wednesday, July 24, 2002 9:51 AM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

Do you get anything in the details? Does it manage to detach to start with and fail later, or not even get that far?

Andy
http://www.sqlservercentral.com/columnists/awarren/

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #36912

rsarosh

Posted Thursday, July 25, 2002 10:45 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, June 19, 2003 12:00 AM
Points: 1, Visits: 1

Tell me what new thing you told us in this article. This whole article can be replaced by one line - right click on the database and choose Copy database.

Post #36915

RAD

Posted Thursday, July 25, 2002 11:47 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, March 25, 2013 10:14 AM
Points: 96, Visits: 56

No matter what I've tried, it doesn't work with SQL Authentication. Yes, I do have Admin righs on both machines, but if they are not on the same network, you're out of luck.

Did it work for anyone? I used it to transfer SQL 7 SP2 to 2000 SP1.

Thanks

Post #36916

« Prev Topic | Next Topic »

24 posts, Page 1 of 3

1 2 3 »»»

Permissions