SQL and Backups in windows server 2003 - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Closed Thread
Thread Tools Display Modes
Old 12-07-2005, 10:23 AM   #1 (permalink)
Newb Techie
Join Date: Oct 2005
Posts: 15
Default SQL and Backups in windows server 2003

I'm trying to do a full server backup using the windows backup utility. I need this server running pretty much non-stop, aso I'm trying to set up a vss so I can backup the entire server as it's running. Unfortunatly we're also running an SQL server, and the VSS doesn't want to create properly. I get an error "Sqllib error: Database <database name here>
is not simple. " (the error id is 6004)

Can't say I know anything about SQL. The techie who set it up left the company in a hurry and I haven't had time to get aquainted with everything. Can someone explain to me what's the difference between full recovery mode and simple recovery mode for SQL? And would it be a horrible thing if I set it to simple to backup and then set it back to full?

Also if anyone knows of a program that can clone a hardrive that's compatable with windows server 2003, and doesn't cost me a leg, it'd be much appreciated if you let me know about it.

Thanks in advance.

alkala is offline  
Old 12-07-2005, 07:58 PM   #2 (permalink)
Master Techie
Join Date: Feb 2004
Posts: 2,172
Send a message via AIM to Win2kpatcher

I would HIGHLY reccomend on purchasing some good backup software such as Veritas Backup Excec. Espciailly since this is a server. It would far out weigh you to purchase a good backup system now and be able to recover rather than lose everything later and rebuild from scratch.

I would purchase the SQL, and AOF options so that you can backup SQL databases with ease and have better open file success.

Symantec Ghost should be able to clone that hard drive without problem. If it is a SCSI/SATA drive though you will have to load the drivers for it.
Win2kpatcher is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Our Communities

Our communities encompass many different hobbies and interests, but each one is built on friendly, intelligent membership.

» More about our Communities

Automotive Communities

Our Automotive communities encompass many different makes and models. From U.S. domestics to European Saloons.

» More about our Automotive Communities

Marine Communities

Our Marine websites focus on Cruising and Sailing Vessels, including forums and the largest cruising Wiki project on the web today.

» More about our Marine Communities

Copyright 2002-2015 Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 01:39 AM.

Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2016, vBulletin Solutions, Inc.