Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Using the Copy Database Wizard Expand / Collapse
Author
Message
Posted Saturday, July 6, 2002 12:00 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Monday, September 15, 2014 9:16 AM
Points: 6,784, Visits: 1,895
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
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #5264
Posted Thursday, July 18, 2002 7:20 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 6:11 AM
Points: 7,010, Visits: 8,461
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


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

- 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"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #36905
Posted Thursday, July 18, 2002 8:40 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Monday, September 15, 2014 9:16 AM
Points: 6,784, Visits: 1,895
Thats correct.

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




Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #36906
Posted Friday, July 19, 2002 10:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 16, 2014 8:07 AM
Points: 2, Visits: 49
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
Posted Friday, July 19, 2002 10:52 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Monday, September 15, 2014 9:16 AM
Points: 6,784, Visits: 1,895
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
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #36908
Posted Friday, July 19, 2002 2:25 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Friday, July 19, 2002 2:40 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Monday, September 15, 2014 9:16 AM
Points: 6,784, Visits: 1,895
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
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #36910
Posted Wednesday, July 24, 2002 9:51 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Monday, September 15, 2014 9:16 AM
Points: 6,784, Visits: 1,895
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
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #36912
Posted Thursday, July 25, 2002 10:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, July 25, 2002 11:47 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, September 15, 2014 6:08 PM
Points: 96, Visits: 77
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 »

Add to briefcase 123»»»

Permissions Expand / Collapse