Windows Thread, Backup HELP!!! in Technical; Hi i was just checking my backups and it isnt doing the SIMS SQL database for some reason?!? Thank god ...
10th March 2008, 01:27 PM #1
Hi i was just checking my backups and it isnt doing the SIMS SQL database for some reason?!? Thank god i take a manual backup everyday!
Anyways when i go and edit the job and tick the 'SQL2005 SIMS' item in the job properties it gives me an error message. I have tried stopping the SQL service on the server it is backing up from but that wasnt it.
Any ideas? I have also tried creating a new job and it does the same thing.
IDG Tech News
10th March 2008, 01:32 PM #2
Some backup software can't backup a live SQL Db do you have an agent for this, It should be backing up the zipped backups in the backups folder though.
What backup software are you using?
Last edited by cookie_monster; 10th March 2008 at 01:34 PM.
10th March 2008, 01:36 PM #3
It has the old SIMS SQL selected but it wont let me tick SIMS 2005.
Using Symantec Backup Exec 10d.
10th March 2008, 01:36 PM #4
I think the approved of backup method for SQL server is to make a SQL backup job that runs before you main backup and dumps to .bak files or similar which can then be backed up as apposed to trying to backup the .mdf or .ldf files as you probably won't be able to get a handle on these as they are constantly in use.
10th March 2008, 01:43 PM #5
@ Jona - How can i do that?
10th March 2008, 01:43 PM #6
can you backup any other 2005 db's? there is a patch needed for some versions of backupexec.
10th March 2008, 01:44 PM #7
Without an agent i don't think 10d will get a clean backup of the Db so you would normally restore from the zipped .bak files anyway this is the supported SIMS method.
Have you recently performed a migration and ended up with multiple SQL instances?
10th March 2008, 01:44 PM #8
Havent got any other 2005 sql db's
10th March 2008, 01:47 PM #9
10th March 2008, 02:01 PM #10
We issue a 'net stop simssql2005' command before the backup then a 'net start' after the backup. Works for us.
10th March 2008, 02:06 PM #11
Did an upgrade a few months ago so there is 2 SQL db's one 2000 and one 2005
Originally Posted by cookie_monster
Doesnt work have just installed it.
Originally Posted by strawberry
This is good but i cant add it to the the backup so it would be pointless untill i can get this box ticked.
Originally Posted by salan
10th March 2008, 02:29 PM #12
Are you not using Dbattach.exe to run a backup each night then?
10th March 2008, 02:39 PM #13
not that i am aware of as our lea take the sims upgrades and then 'modify' them and send us a link to an automated file and it does it all itself - scary but it works.
10th March 2008, 02:42 PM #14
If it is you'll have a scheduled task that runs a .bat file each night and lots of .zip files in a folder called 'backup' in your SQL instance folder same folder level as the data folder.
10th March 2008, 03:14 PM #15
It was in the document that strawberry linked to, what it was is that you had to run an update on the remote server as well as the server file was found at "c:\program files\veritas\backup execv\nt\agents\rant32\raws.msp" for future information! It was listed in the middle of a paragraph and not made clearly visible they should put it in bold or underline it or something to make it stand out more!!
Thanks everyone for your help ;-)
By apeo in forum How do you do....it?
Last Post: 4th December 2007, 02:47 PM
Last Post: 20th September 2007, 11:16 PM
By robknowles in forum Hardware
Last Post: 18th April 2007, 11:55 PM
Last Post: 1st August 2006, 11:25 AM
By ChrisH in forum Scripts
Last Post: 20th October 2005, 02:01 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)