Veritas 9.1 and the SQL agent.

Posted on 2005-03-23
Medium Priority
Last Modified: 2013-12-01
How do you backup SQL without the veritas agent?  What advantages are there to using the SQL agent?

Question by:LanMan6401
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
1 Comment
LVL 13

Accepted Solution

gpriceee earned 2000 total points
ID: 13618386
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


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Is your phone running out of space to hold pictures?  This article will show you quick tips on how to solve this problem.
The business world is becoming increasingly integrated with tech. It’s not just for a select few anymore — but what about if you have a small business? It may be easier than you think to integrate technology into your small business, and it’s likely…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
Suggested Courses

777 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