Can I backup the entire SQL drive?
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
Software/Hardware used:
SQL Express 2005
ASKED:
November 3, 2010 12:43 PM
UPDATED:
November 15, 2010 1:24 PM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
