MIS Systems Thread, sims backup in Technical; A live backup is what Backup Exec is doing you won't find the files but you should be able to ...
12th May 2009, 08:26 PM #16
A live backup is what Backup Exec is doing you won't find the files but you should be able to restore the dbs to another sql server you just have to specify which during the restore. As for SQL Server backups these are much better tbh..
12th May 2009, 08:42 PM #17
Only if you have the agent! Which is like £100.
12th May 2009, 09:07 PM #18
He has got the SQL Server Agent?
I am using Symantec Backup exec 11d and have the agent for SQL Server 2000.
12th May 2009, 09:29 PM #19
I didn't think you should expect to see the live database files as flat files in the backup, even when you have the SQL agent. I believe you should see the SQL instances and databases available to backup/restore as a separate node, similar to how AD and system state are represented.
Originally Posted by arthur231283
I use dbattach as the primary backup method and the BE SQL agent as secondary. The only SQL services we used to stop/start were the SQL Anywhere services for FMS.
Originally Posted by Oops_my_bad
13th May 2009, 08:29 AM #20
- Rep Power
Schedule that and mark the backup folderfor SQL in your Agents selections so you have both
ECHO YOUR SQL DATABASE IS CURRENTLY BEING BACKED UP, THIS MAY TAKE SEVERAL MINUTES
DBATTACH /BACKUP /AUTO /SERVER=XXXXX\SIMS2005 /user=sa /password=XXXXXX /DATABASE=sims
DBATTACH /BACKUP /AUTO /SERVER=XXXXX\SIMS2005 /user=sa /password=XXXXXX /DATABASE=ccsfms
20th May 2009, 06:45 PM #21
That said, dbattach (in a batch similar to Steve_T's above) is a Capita-recommended method for your nightly backups. We have been using it for a good while and have never had problems with transaction logs growing. I suspect either: dbattach takes care of the problem -or- the SQL backup which happens before every upgrade or database patch is frequent enough to remove the problem.
Originally Posted by jinnantonnix
By pooley in forum MIS Systems
Last Post: 27th March 2009, 12:33 PM
By ninjabeaver in forum MIS Systems
Last Post: 16th January 2009, 10:40 AM
By ee01akk in forum MIS Systems
Last Post: 29th August 2008, 11:37 AM
By Ell2Cool in forum MIS Systems
Last Post: 29th October 2007, 12:21 PM
By Jawloms in forum MIS Systems
Last Post: 26th October 2007, 03:17 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread