Post reply

Database is still in use when i will backup...any idea

  • December 2, 2005 at 3:35 am

    #111410

    Hi all

    I stop the following services on my MSSQL server with a batchfile:

    net stop "SQLSERVERAGENT"

    net stop "MSSQLSERVER"

    net stop "Microsoft Search"

    net stop "Distributed Transaction Coordinator"

    But when i make a backup with Dataprotector 5.5 the *.mdf and the log files are in use and can't be backuped.

    Any idea why ????

     

    Thanks Sven

  • December 2, 2005 at 8:53 am

    #607407

    Sven,

    is there any reason why you don't want to use SQL Server backups?

    I would recommend using SQL Server native backups or something that directly interfaces with SQL Server. Having to stop SQL Server to backup the database doesn't sound like a good idea.

    Karl
    source control for SQL Server

  • December 2, 2005 at 12:39 pm

    #607481

    If you don't care if the database is available to users, detach it. Copy the .mdf and .ldf files. Then reAttach it.

    But Grambowk's suggestion is the best. If possible, use the native SQL Server commands to backup the database to disk and then copy the backup file to tape.

    -SQLBill

  • December 2, 2005 at 4:41 pm

    #607554

    If the "Dataprotecter" is IBM's TDP, it expects the database server to be up and running.  TDP is an agent that backs up the databases internally (unlike an external file copy backup) and requires the dbserver to be up and running so it can login to perform the backup.

     

    If it's not TDP...I dunno.

    Your friendly High-Tech Janitor... 🙂

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply