Just out of curiosity why would you want two apps hitting different copies of the same database? don't you want the people using the asp app and the CF app to see the same data? or is it some sort of migration away from ASP to CF? sorry... maybe there is some business reason... couldn't hold back from asking...
On Mon, Apr 21, 2008 at 4:30 PM, Peyton Todd <[EMAIL PROTECTED]> wrote: > 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 > ------------------------------------------------------------- > > > > -- Steven Ross web application & interface developer http://blog.stevensross.com [mobile] 404-488-4364 [fax] (404) 592-6885 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] ------------------------------------------------------------- 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 -------------------------------------------------------------
