Solved

sql backup asap

Posted on 2007-03-22
3
200 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

On a regular basis I get questions about slow RDP performance, RDP connection problems, strange errors and even BSOD, remote computers freezing or restarting after initiation of a remote session. In a lot of this cases the quick solutions made b…
Welcome to my series of short tips on migrations. Whilst based on Microsoft migrations the same principles can be applied to any type of migration. My first tip is around source server preparation. No migration is an easy migration, there is a…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

785 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