Windows Server 2000/2003 Thread, Restoring to SQL server 2005 - insufficient space on drive C in Technical; Hello,
I'm trying to restore our Serco CMIS database to our SQL server 2005 (on Server 2003) after admin staff ...
19th October 2010, 12:28 PM #1
Restoring to SQL server 2005 - insufficient space on drive C
I'm trying to restore our Serco CMIS database to our SQL server 2005 (on Server 2003) after admin staff made some big mistake.
Using Symantec Backup Exec 11d
The SQL databases are on drive E: with 80GB free space - plenty.
The restore fails because there isn't enough space on drive C:. It looks like it's using drive C: as a staging area.
Is there any way to tell it to use another drive as a staging area? Other drives have loads of free space.
19th October 2010, 12:55 PM #2
Fixed it. In BackupExec restore job, check the "Take existing database offline" and "Overwrite existing database" boxes. That way it doesn't do the staging on drive C:.
(I know this is a Server 2003 forum, but couldn't find anywhere better to put this).
19th October 2010, 10:27 PM #3
The best advice is never use the SQL Backup unless its a last resort, always use the Serco Backup from the system, its much quicker and works much better (which your admin staff took before making any changes didn't they..... I know mine have that drummed into them nicely now ) I've seen what occurs when you use the SQL backup and it wasn't a pretty picture..... (and no before someone says so it wasn't me that did it! I always restore my SQL (such as when I clean installed the system) from the Facility Admin backups.
20th October 2010, 10:15 AM #4
Believe me... I know about the Facility backups - I just can't convince the admin staff.
They came to me yesterday morning after mucking up the timetable completely - with no Facility backup.
About an hour of hair ripping later, I'd restored the SQL database and another member of admin staff was manually re-entering the morning's attendance.
I didn't know that a SQL restore could cause problems. I've done it before in a couple of emergencies but not had any problems.
I'll have to invest more time in user education.
20th October 2010, 09:11 PM #5
Maybe you can find the thread on the features wanted and rate that on the Serco Portal for a simpler way of backing up / a batch automated way of doing it as yes its simple but getting them to do it is painful. I try and take one a week myself and the Data Manager does at least one a week so between us we have at least 2 copies a week if not more.
Originally Posted by OverWorked
Glad you got it sorted though, I'll come and poke them with a big stick if it would help you convince them to take them before making changing.
By reggiep in forum Scripts
Last Post: 26th October 2010, 05:50 PM
By philserre in forum How do you do....it?
Last Post: 10th August 2010, 10:37 PM
By techie08 in forum Windows Server 2000/2003
Last Post: 13th February 2009, 12:06 AM
By zag in forum MIS Systems
Last Post: 10th October 2007, 09:02 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread