Results 1 to 2 of 2

Thread: Restore a Database

  1. Mar 10th, 2010, 07:03 PM #1
    gb1983
    gb1983 is offline

    Thread Starter
    Lively Member
    Join Date
    Dec 2008
    Posts
    103

    Restore a Database

    Hi,

    Can someone please tell me what the 'WITH FILE = 1' part of the statement below means please. I am restoring a full and differential backup, I'm just not sure why the differential is 1? Does it just mean that there is 1 file in addition to the Full backup?

    Thanks
    Code:
    RESTORE DATABASE MyDB FROM DISK = 'C:\SQLBackups\FullBackup.bak' WITH NORECOVERY
GO
RESTORE DATABASE MyDB FROM DISK = 'C:\SQLBackups\FullBackup.bak' WITH FILE = 1, RECOVERY
GO
    Reply With Quote Reply With Quote
  2. Mar 11th, 2010, 12:24 AM #2
    jggtz
    jggtz is offline
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: Restore a Database

    Follow the next link, it could be helpful

    http://msdn.microsoft.com/en-us/library/ms186858.aspx

    JG
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width