?
Solved

SQL Server 'Backup' Directory

Posted on 2009-05-11
7
Medium Priority
?
472 Views
Last Modified: 2012-06-27
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!
0
Comment
Question by:tigermatt
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 24355644
>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?

yes. of course, if you have to restore, you have to specify the new location, resp copy back the needed files.

>Is it required for the day-to-day running on the SQL Server?
no

>Also where is the Backup routine configured? Can I see the config in Management Studio?
in the maintenance plans, which create sql agent jobs. the schedules are to be modified in the maintenance plans.
0
 
LVL 58

Author Comment

by:tigermatt
ID: 24355717

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
0
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 24355740
that is possible, of course.
you have run a backup with the BACKUP DATABASE sql statement.
0
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 58

Author Closing Comment

by:tigermatt
ID: 31580186
Thanks
0
 
LVL 58

Author Comment

by:tigermatt
ID: 24355763
That's probably what it is doing. Thanks!
0
 
LVL 58

Author Comment

by:tigermatt
ID: 24355768
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?
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24355848
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...
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question