Can I backup the entire SQL drive?

5 pts.
Tags:
Backup Exec
SQL Backup
SQL Express 2005
SQL Server
Veritas Backup Exec
I have an application that uses SQL Express 2005. I will be upgrading the application and am planning for rollback should it be required. I have nightly database backups which also go to tape but I am wanting the entire hard drives of the server backed up to tape prior to the upgrade. As a rule, we do not backup SQL folders to tape but just the database backups. This database is not in use at night. Because the SQL Express is customized and integrated with the application, I would feel better to also backup the SQL directories to tape. Will this cause any poroblems? We do not have the network backup agent for SQL. We use Backup Exec (Veritas) for our network backups.

Software/Hardware used:
SQL Express 2005
ASKED: November 3, 2010  12:43 PM
UPDATED: November 15, 2010  1:24 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

I’ve removed the answer which provided you no useful information at all.

If the SQL Server service is running then you can not backup the folders with the SQL Server databases in them as the files are locked. You have two options.

1. Just before your upgrade backup all the databases using the SQL Server BACKUP DATABASE command. Then backup those backups to tape.

2. Stop the SQL Server service which will cause the database engine to release its locks on the database files and you can then back them up to tape.

Option #1 is the much better option as it doesn’t require that the database be taken offline.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following