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