Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Back up databases.


23 May 2013   #1

x86
 
 
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 System SpecsSystem Spec
.

23 May 2013   #2

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

Quote   Quote: Originally Posted by zzpack View Post
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 System SpecsSystem Spec
Reply

 Back up databases.




Thread Tools




Our Sites

Site Links

About Us

Find 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 10:19 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33