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 |
|
alexjamesbrown
Starting Member
48 Posts |
 Posted - 2010-01-04 : 08:09:28
|
| I'm trying to restore a BAK of a database we have, onto new, better hardware. Here is a screenshot of the UI in Management Studiohttp://twitpic.com/wmtr8/fullThe existing db has an mdf, and ndf file... and two log (ldf) files...Is there any way I can restore it so that it just has ONE mdf and ONE ldf file...?The existing db is SQL 2000 - I'm restoring it to a SQL 2008 instance - I created the db in 2000 compatibility mode however....as a side note: If i click Ok, in the screen shown above, i get the following error: |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-04 : 09:13:43
|
Do you have the knowledge why there is an ndf file?Look into google with this:sql server way to merge mdf and ndf
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-01-04 : 11:01:54
|
| You have to restore the database to the state it was when it was backed up - mdf, ndf and 2 ldf files. Once it's restored then you can look at merging them.Why do you want to merge the ndf into the mdf?--Gail ShawSQL Server MVP |
|
|
|
|
|
|
SQL Backup - Restoring to different data / log fil