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 Search this Thread
Search this Thread:

Advanced Search




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:17.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App