Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

sql backup asap

Posted on 2007-03-22
3
Medium Priority
?
207 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
[X]
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
  • 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 2000 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

Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

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 …
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…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

610 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