Something I read on a Microsoft User Forum cued me to the correct answer: Instead of establishing the new DB first, all you have to do is just say you want to 'restore' to it, even when it doesn't exist yet. Key in the name you wish to assign to it into the 'To database' text field of the wizard, and then select the existing DB in the 'From database' drop-down list and click Okay. Evidently this so-called 'restore' does not even get its info from a backup, but gets it from the live DB.
-----Original Message----- >From: Peyton Todd <[EMAIL PROTECTED]> >Sent: Apr 21, 2008 4:30 PM >To: [email protected] >Subject: [ACFUG Discuss] How Clone a SQL Server Database? > >Are there any SQL Server Wizards in the crowd (the human kind, I mean)? I have >discovered that the site I'm building accesses a SQL Server table also >accessed by an ASP site on the same server, and I want to separate them. So I >want to make a clone of that SQL Server database for the exclusive use of my >site - one which will reside in the same SQL Server installation. > >Part of the problem is that I have a SQL Server 2005 installation but my only >manual is for SQL Server 2000. The client's site has SQL Server 2000, but I'd >like to: (a) know what to do before I arrive again at the client's physical >location, and (b) fully test my site with the cloned DB before I install it on >his server. > >So far, in trying to accomplish this with my own SQL Server 2005, I have >established the new DB but it's still empty. To populate it with data from the >existing DB, I've tried to backup and restore, but every time I get a message >objecting that the backup copy is of a DB with a different name. That happens >even if go to a different PC which has the old DB on it, and RENAME it to the >name of my new DB before making the backup. When I take that backup to the >main PC I'm working on and try to restore from that backup to the new DB, it >STILL complains that the name is different, even though it was backed up from >a DB which (now) has the new name, and even though its filename is the same as >the name of the new DB. > >My SQL Server 2000 manual describes a Copy Database Wizard, but I can't find >it in the SQL Server 2005 Management Studio Express set of dialogs (analog of >what was Enterprise Manager in SQL Server 2000). > >Any suggestions? > >Thanks, > >Peyton > > > > >------------------------------------------------------------- >Annual Sponsor FigLeaf Software - http://www.figleaf.com > >To unsubscribe from this list, manage your profile @ >http://www.acfug.org?fa=login.edituserform > >For more info, see http://www.acfug.org/mailinglists >Archive @ http://www.mail-archive.com/discussion%40acfug.org/ >List hosted by http://www.fusionlink.com >------------------------------------------------------------- > > > ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
