System Center Configuration Manager TechCenter >
System Center Configuration Manager Forums
>
Configuration Manager Backup and Recovery
>
Cannot backup SCCM site getting error "Unable to find/start SQLWriter service". Nees Advice since I am not a SQL Admin
Cannot backup SCCM site getting error "Unable to find/start SQLWriter service". Nees Advice since I am not a SQL Admin
- Lately, my SCCM 2007 site is not getting backed up anymore. The backup is supposed to run every Sunday but the last time it ran successfully was about two months ago. The backup log says, " ERROR: SQL Backup task failed. Error message - Unable to find/start SQLWriter service. Cannot backup Sql database without this service." The SCCM database is on a remote SQL server that houses other databses. I do not have access to the SQL server as our SQL servers are managed by the SQL Admins (and they are very strict with access permissions and security). If the SQL Admin refuses to enable this service, is it possible to backup the SCCM site without backing up the database? The SQL Admins do back up on the databases on a regular basis so I they are gonna tell me not to do a database backup since they are already doing it.
We have SCCM1 SP1, 1 primary site, no child or secondary sites.
All Replies
- Hi,
In theory you can perform a backup of the SQL db and the rest (ConfigMgr file and registry) in two different operations. But I will never recommend that as it will only make a restore process very difficult (due to package serial numbers and much more). I suggest that you somehow talk to the SQL group and solve the problem.
Kent Agerlund | http://scug.dk/members/Agerlund/default.aspx | The Danish community for System Center products There are no supported way to backup SQL separately from ConfigMgr. If you ever have to restore your site, it might be easier to start fresh then trying to sync everything up.
http://www.enhansoft.com/Unable to find/start SQLWriter service.
Is that service installed and not set to 'disabled' on the sql server?
[...]
SQL Admins (and they are very strict with access permissions and security).
Is the computeraccount of your siteserver local admin on the sql box?- Hi scjoy,
Do you still have this problem? if so check the following reg key
HKLM\Software\Microsoft\SMS\Components\SMS_SITE_SQL_BACKUP_<SCCM Server Name> under this "Backup Destination Path" key should not have any entries.
In your case it looks like it is having some temp file location, because your last successful backup was created temp location for snapshot on your (remote) SQL server but it was not deleted after backup, hence it is failing to start SQLWriter Service.
If this is the case with your issue delete "SMS_SITE_SQL_BACKUP_<SCCM Server Name>" registry and initiate SCCM backup, it will recreate this key and your backup will be success.
Let me know still if you face any issues with SCCM Backups.
Surendar Reddy- Proposed As Answer byReddy Surendar Tuesday, November 03, 2009 2:05 PM
