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
zzpack

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
Kaktussoft

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





Similar help and support threads
Thread Forum
Random BSOD--Several different codes back to back. New computer.
Computer seems stable and then will randomly BSOD-- Doesnt seem to be consistent with what im doing. A few of the BSOD's came after a 'error memory reference line' or something like that. Computer is new, I installed drivers with supplied disks from motherboard manufacturer (asus). At first I...
BSOD Help and Support
Norton Back Up and General Back Up - and good bye
Dear Forum, I wish to thank you for the links to assist me in different modules and help links. I have learnt a lot in the past few weeks. I know where not to go and I guess some people wish to tell me where to go. I have in the meantime noted that Norton back Up was not working - I just...
Backup and Restore
Trying to Change back my windows 7 Icons back to default
Alright Guys I installed Iconpackager the latest version. I wanted to change my icons to something else so I did that. Now when I wanted to change them back to default I selected the windows default icons but when I did that all the icons were windows vista. If anyone knows my problem please let...
Themes and Styles
Microsoft strikes back at Google on e-mail back-up plan
Microsoft strikes back at Google on e-mail back-up plan | ZDNet
News
How to get the Audio Output Device back and re install back onto Windo
Hi, I've been on Window's 7 Ultimate 7 64bit for the past three months. Everything have been working smoothly. I've been having the sound perfectly until I recently wanted to listen to a youtube clip and there is no sound. It says "No Audio Output Device Installed". I have tried various...
Sound & Audio
Dreamweaver CS4 Databases ERROR - Was once connected
I’m working with Dreamweaver CS4 and when I got to my databases / mysql connection / test my connection, I get the following error…. HTTP Error Code 500 Internal Server Error. What is going on and how can I fix this? Thanks in advance Scotty13
Software

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 07:57.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App