Clone and instance
-
Hi,
How to clone and instance for example I have instance call ABC I want to create ABC_test
thanks and regards,
Sinardy
-
Why not BACKUP/RESTORE it using a different name?
Good Hunting!AJ Ahrens
webmaster@kritter.net -
One option that you can do is to detach the database, copy all the database files as another name, attach the original database, then attach the copied database using a different database name. Attaching the second database may give you errors because the files it initially knows is already in use. Simply select the files you copied earlier and this should do the trick.
-
AJ: do you not need to install a second named instance on same box or new instance on different box before restoring from Production (or some other instance) all the databases and such?
Also a newbie, and I will have to create a minimum of three separate instances, all cloned from production.
apologies for the low lvl of unnerstanding.
thanx.
-
1. No new instance is needed. All you need to do is give different name and away you go...
Should be no problem to create multiple of same database different names...
HOWEVER, IF you need to have the database RETAIN the same name THEN you will need to install multiple instances....
Good Hunting!AJ Ahrens
webmaster@kritter.net
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply