Post reply

Full backup of a database is executing but percent_complete is 0 only

  • August 13, 2012 at 8:22 am

    #260094

    Hi Everyone,

    I am trying to take split backup of a database of 180GB to NAS Server through query in sql server. If execute the query, it seems to be executing for long time and no files created in desination folder, even percent_complete is also showing 0 in sys.dm_exec_requests for database backup.

    If I kill that backup query session, its taking too much time to kill that process and to rollback.

    Please help me, how to take backup of that database without any issues like now.

    Any thoughts will be greatly appreciated.....:-)

    Thanks & Regards,

  • August 13, 2012 at 8:36 am

    #1525072

    Does a local backup go quicker? Is your system busy?

  • August 13, 2012 at 10:01 am

    #1525144

    We are not taking any backups to local system. All are going to shared network drive only. The server performance is normal only.

    Earlier we faced some issue like:

    write failure on backup device '\\XXX\XXX.bak'. Operating system error 1130(Not enough server storage is available to process this command.)).,

    But now we are not getting any error. It seems to be executing but progress of the backup is 0, even backup file also not created on shared network drive.

    Thanks for your advice and support.

    Regards,

  • August 13, 2012 at 10:17 am

    #1525150

    Are you sure you have enough space, or the account has quote space?

    I asked you try a local backup, to test if the problem is the remote drive or something else.

  • August 14, 2012 at 6:42 am

    #1525467

    I cant take any local backup because we don't have that much free space. I tried to take backup to another shared network drive but that one also getting failed.

    Today I tried to take backup for small database like 300MB by using powershell, its happened without any issues. In the same way I tried to take the backup of 180GB database, its showing some error like:

    PS SQLSERVER:\SQL\BGL247PRODDB\DEFAULT+varalakshmi\> invoke-sqlcmd -inputfile 'H

    :\test\XXX.sql'

    WARNING: Using provider context. Server = BGL247PRODDB.

    Invoke-Sqlcmd : Timeout expired. The timeout period elapsed prior to completio

    n of the operation or the server is not responding.

    At line:1 char:14

    + invoke-sqlcmd <<<< -inputfile 'H:\test\XXX.sql'

    + CategoryInfo : InvalidOperation: (:) [Invoke-Sqlcmd], SqlPowerS

    hellSqlExecutionException

    + FullyQualifiedErrorId : SqlError,Microsoft.SqlServer.Management.PowerShe

    ll.GetScriptCommand

    PS SQLSERVER:\SQL\BGL247PRODDB\DEFAULT+varalakshmi\>

    Please give me any suggestions in this issue....

  • August 14, 2012 at 8:09 am

    #1525535

    It sounds like an intermittent network problem or a resource contention/availability problem, so you're probably going to have to get your sys admins involved.

    If you have Standard, BI or Enterprise Edition, have you tried backing up with compression turned on so you're reducing the overhead on the network device?

  • August 14, 2012 at 9:10 am

    #1525588

    I agree with Howard that it sounds like a network issue. The first errors still could be a security issue of some sort.

    Is there a USB HDD around? A 500GB one isn't very expensive, and would allow a quick test.

Viewing 7 posts - 1 through 6 (of 6 total)

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