How to create multiple instances of same DB

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

How to create multiple instances of same DB

Author

Topic

reddymade
Posting Yak Master

165 Posts

Posted - 2006-10-20 : 09:42:26

I have a following database myproject (myproject_data.mdf)

I want to create 4 other databases of myproject on the same server.

iused BACKUP command created a different .bak file

and then tried Restore Database function, to create a new database with different name.

I am getting the following errors:
*************************************************
Server: Msg 1834, Level 16, State 1, Line 1
The file 'D:\Program Files\Microsoft SQL Server\MSSQL\Data\myProject_Data.MDF' cannot be overwritten. It is being used by database 'myProject'.
Server: Msg 3156, Level 16, State 1, Line 1
File 'bmobilepulse_Data' cannot be restored to 'D:\Program Files\Microsoft SQL Server\MSSQL\Data\myProject_Data.MDF'. Use WITH MOVE to identify a valid location for the file.
Server: Msg 1834, Level 16, State 1, Line 1
The file 'D:\Program Files\Microsoft SQL Server\MSSQL\Data\myProject_Log.LDF' cannot be overwritten. It is being used by database 'myProject'.
Server: Msg 3156, Level 16, State 1, Line 1
File 'bmobilepulse_Log' cannot be restored to 'D:\Program Files\Microsoft SQL Server\MSSQL\Data\myProject_Log.LDF'. Use WITH MOVE to identify a valid location for the file.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

**************************************

Please help with any information, how to create multiple databases with different names on the same server.

Thank you very much for the info.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources