Solved

sql backup asap

Posted on 2007-03-22
3
201 Views
Last Modified: 2010-04-20
I have aneed to backup sql databases I installed veritas 11 and ran the backup on teh databaees I needed. It ran for 15 hours and then verifyran and then said corrupted data. I am running them individually now. My question is I am on the sql and see a backup option in sql How do i back this up soI can restore if there is a issue, also shoudl Istop sql when the veritas is running?
0
Comment
Question by:zenworksb
  • 2
3 Comments
 
LVL 3

Expert Comment

by:fpthree
ID: 18773164
What version of SQL are you running?
0
 

Author Comment

by:zenworksb
ID: 18773179
2005
0
 
LVL 3

Accepted Solution

by:
fpthree earned 500 total points
ID: 18773278
I would use these instructions: http://www.sql-server-performance.com/ss_creating_backup_jobs.asp
And created a job within Backup Exec to backup the .bak file from the servers location.
If you're having problems with the Backup Agent running backup on a database, then this would be a good way to get a backup of the database. At the same time, if you ever have to restore your database
you can restore directly from the SQL manager and you still have copies of older databases if you need to parce data from it in the future.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

After having deployed hundreds of thousands of Terminal Services seats worldwide, I still see all the time people asking me that same old question: "If TS/RDS is that reliable why are you telling me I should reboot it that often? My DC/SQL/Exchange/…
Problem Description: Actually I found the below issue with some customers after migration from SMS 2003 to SCCM 2007 and epically if they change site code, some clients may appear in the console with old site code, plus old sites still appearing …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

792 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