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 |
|
sudhakar_msccs@yahoo.com
Starting Member
2 Posts |
 Posted - 2005-12-08 : 06:43:23
|
| hi alli am having database backup of sqlserver. i want to attach this backup to another sqlserver in a new location. how it is possible.when i tried it was saying .mdf not supportedcan u resolve this? |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2005-12-08 : 15:47:34
|
| Hi Sudhakar,If you have database backup then Restore it on another machine.If you have .mdf and .ldf files then copy these files in to another location and use Sp_attach_db to restore it.You can not attach the database backup file. Please check the syntax below ...EXEC sp_attach_db @dbname = N'Test', @filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\Test.mdf', @filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\Test_log.ldf'With RegardsBSR |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-09 : 01:12:54
|
| http://support.microsoft.com/default.aspx?scid=kb;en-us;224071MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
attaching a new database to sql server