?
Solved

sql backup asap

Posted on 2007-03-22
3
Medium Priority
?
206 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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

My previous article  (http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Windows_Server_2008/A_4466-A-beginners-guide-to-installing-SCCM2007-on-Windows-2008-R2-Server.html)detailed one possible method to get SCCM 2007 installed an…
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…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
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…

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