tigermatt
asked on
SQL Server 'Backup' Directory
On an SQL Server I manage there is a rather large 'Backup' directory located in the D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL.
This directory totals 14.1GB in size, and if it truly is a Backup, can I safely archive it to another network location for storage purposes?
Is it required for the day-to-day running on the SQL Server?
Also where is the Backup routine configured? Can I see the config in Management Studio?
Thanks!
This directory totals 14.1GB in size, and if it truly is a Backup, can I safely archive it to another network location for storage purposes?
Is it required for the day-to-day running on the SQL Server?
Also where is the Backup routine configured? Can I see the config in Management Studio?
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
ASKER
That's probably what it is doing. Thanks!
ASKER
Oops - hit the button too quick. I just had a thought: does Backup Exec do these sorts of SQL Server backups by running a 'BACKUP DATABASE' SQL command?
again: possible.
it depends on the back exec's job configuration.
however, I am not sure if backup exec can run sql statements as such, resp that they do the backup's to the sql server's default backup folder...
it depends on the back exec's job configuration.
however, I am not sure if backup exec can run sql statements as such, resp that they do the backup's to the sql server's default backup folder...
ASKER
I had a look in Management Studio under 'Management > Maintenance Plans' and none are listed.
A little background: this database server runs a Management Information System application which requires regular updates, which update both the program interface and they restructure the database. The creation date of at least one of the database's backup ZIP files coincides with that of these upgrades, so could that process be running the backup manually?
-Matt