Post reply

How Can I restore this db and make availble?

  • October 13, 2011 at 12:05 am

    #258772

    It could be a real case also...

    I have 11 drives on server and in each drive 3 ndb files so total 44 files of a single database .

    Now the server goes down and new server has only 3 drives.How Can I restore this db and make availble?

    Thanks

  • October 13, 2011 at 12:17 am

    #1393817

    RESTORE DATABASE .... WITH MOVE ....

    Specify each file and where it goes, see Books Online for full details, I know there's an example on the Restore database page that covers moving the destination files.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 13, 2011 at 11:21 am

    #1394253

    With RESTORE DATABASE WITH MOVE, you can provide new locations for your data files.

  • October 16, 2011 at 11:44 pm

    #1395134

    Thanks:-)

    Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply