• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 505
  • Last Modified:

Veritas 9.1 and the SQL agent.

How do you backup SQL without the veritas agent?  What advantages are there to using the SQL agent?

1 Solution
I always backup SQL without the SQL agent and with the agent.
The Veritas agent throws the databases to tape.

For backing up within SQL, I have a disk storage location with five directories: Monday, Tuesday, Wednesday, Thursday, and Friday.
I have a lot of storage space--a lot.
Each of those directories has sub-directories named after the time; ie, 10:00am.

You can right-click on a database and back it up to tape, disk, or another location.
Also, you casn schedule dumps:

In SQL Enterprise Manager:
Open the SQL Enterprise Manager, right-click on Maintenance Plans, and choose New.
Next -->
Check All Databases
Next (choose nothing) --> Next
Check Check Database Integrity (the Include Indexes radio button should already be chosen) DO NOT check Attempt to repair or Perform these tests. . . .
Next -->
Check Back up the database as part of the maintenance plan AND Verify integrity of the backup on completion of backup.
For the schedule, click on change, and set it to what you want.  Ensure that Enable Schedule is checked as well.
Next -->
Verify the backup location.  
If it's disk, Check Create a subdirectory for each database (this is helpful)
If it's disk, Check Remove files older than--and complete the parameters.
Next -->
Repeat the same steps for the transaction logs as for the databases.
Next -->
Don't worry about the reports for now.
Next -->
Check Write history to the msdb.dbo.sysdbmaintplan_history table on this server, and limit rows to 1000
Next -->
Name the Maintenance Plan something descriptive: I usually name the plan something similar to Backup All DBs and Logs: created 03_23_05
Complete the final okee dokees.

Under the SQL server group, click on the + next to Management --> the + next to SQL Server Agent --> click ON jobs.
In the right-hand pane, you'll see the job you created.
If you're ready, right click it and run it now.
If nothing seems to happen, refresh the window: that part is really frustrating in SQL Enterprise Manager.
You'll even have to refresh to see that the job is complete.
Afterwards, you can right clcik on the job and view its history.
If you have issues, then you can go back and edit the plan to include a report to a specific location.


Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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