Back up databases.


  1. Posts : 11
    x86
       #1

    Back up databases.


    To backup data on a file server is easy, I use grandfather-father-son schema.

    But I donīt understand how it works on a database server. (SQL) It has a C and a D drive.
    The OS is on the C drive and the database is on the D drive.

    Lets say I make a full backup of C and D drives on the sql server, and the server breaks down one day.

    I then restore the server with my backup of the C and D drives. Will the database on D drive
    run fine after my restore?
      My Computer


  2. Posts : 10,796
    Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
       #2

    zzpack said:
    To backup data on a file server is easy, I use grandfather-father-son schema.

    But I donīt understand how it works on a database server. (SQL) It has a C and a D drive.
    The OS is on the C drive and the database is on the D drive.

    Lets say I make a full backup of C and D drives on the sql server, and the server breaks down one day.

    I then restore the server with my backup of the C and D drives. Will the database on D drive
    run fine after my restore?
    You make backup using windows system image (C and D included in 1 image)? If not... what backup program do you use? System restore points are active on both disks?
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Đ Designer Media Ltd
All times are GMT -5. The time now is 04:06.
Find Us