What are the challenges you face when working across database platforms? Take the survey
Options

Service dependance

gaelgael Posts: 20
edited June 28, 2006 12:36PM in SQL Backup Previous Versions
Hi,
During test, i've noticied that if we restart MSSQL server service, sqlbackup don't run correctly. (VDI 1000)
so SQLBackupAgent service need to be started after SQL Server service.

may bay a modification to add for next version of sqlbackup?

nb: for information, to create dependance, regedit > HKLM > SYSTEM > Currentcontrolset > service > service_name : right click, new, multi-string value.
name : DependOnService
value : service_name

Gael

Comments

  • Options
    peteypetey Posts: 2,358 New member
    Could you please send us steps to reproduce the error you encountered?

    As a simple test, I ran the following from Query Analyer:
    sqlbackup '-sql "BACKUP DATABASE pubs TO DISK = [e:\temp\pubs.sqb] WITH INIT"'
    
    Stopped the SQL Server service and restarted it. Then ran the above command again. The backup is performed without errors.

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.