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.
| Author |
Topic |
|
satish.gorijala
Posting Yak Master
182 Posts |
 Posted - 2009-12-29 : 06:51:33
|
| Hi , I have one database with name "EmpDB" under databases in sqlserver management studio 2005. I want the same database with another name "AnotherEmpDB".I tried by taking a copy of EmpDB.mdf & ldf files and renamed it. But internally it has the same name so i got an error.What's the process to achieve my requirement?developer :) |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-12-29 : 07:03:21
|
| take a full backup and restore it with a new database name.Don't try messing with the ldf and mdf files.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
satish.gorijala
Posting Yak Master
182 Posts |
Posted - 2009-12-29 : 07:11:19
|
Its perfect. Thank you.quote:
Originally posted by Transact Charlie
take a full backup and restore it with a new database name.Don't try messing with the ldf and mdf files.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
developer :) |
|
|
|
|
|
|
how to create copy of database