Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 481
  • Last Modified:

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!
0
tigermatt
Asked:
tigermatt
  • 4
  • 3
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>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
 
tigermattAuthor Commented:

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
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
that is possible, of course.
you have run a backup with the BACKUP DATABASE sql statement.
0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
tigermattAuthor Commented:
Thanks
0
 
tigermattAuthor Commented:
That's probably what it is doing. Thanks!
0
 
tigermattAuthor Commented:
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
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now