Cant restore to 2008

Discussion in 'Databases' started by neural9, Jun 22, 2009.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. neural9

    neural9

    I've got a 2005 MSSSQL database BAK file which was originally created on a local server, then 'restored' to the DiscountASP server. I've since bak'd up and restored many, many times with 2005.

    I then ordered a 2008 account, and followed mjp's instructions and I'm getting an error from Tech Support that says "More than 1 data or log file in bak file".

    I'm not doing anything different than 2005.

    Is there a process I need to follow differently with 2008? I really need to restore!

    Thanks,

    Rob
     
    neural9, Jun 22, 2009
    #1
  2. JorgeR

    JorgeR DiscountASP.NET Staff

    The error that you are seeing is because 'the bak files contains more than one data /log file. The restore tool can only restore database that contains a single datafile.' The restore will not be able to restore back files that have ndf files or several log files. Also, if you don't have such files, recreate the back and make sure that it was not appended on top of another backup step. Make sure it is the only bak file. If you continue to see issues, create a support ticket using the control panel portal advise on the bak file & location that is failing on restore
     
    JorgeR, Jun 22, 2009
    #2
  3. neural9

    neural9

    Hi Junior,

    I've been able to create a workaround.

    The main issue is that SQL2008 creates a separate NDF file for the full text index I'm using as standard. This is getting included in the backup I take on my local server. I can verify this by loking at my MSSQLSERVER\DATA directory and seeing the NDF file in there with the same name as my full text index.

    I can remove that NDF file by using the TSQL:-

    ALTER DATABASE dbname REMOVE FILE fulltext.ndf

    This will now allow you to back up and restore with the discountasp tool. I have no idea how this hits your database and maintenance plans or how it affects the performance of my full text query, but it seems like a hack.

    Note that you may have to shrink the database and/or file as well.

    Rob
     
    neural9, Jun 23, 2009
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page