Re: [Mssqlcompressed-users] MSBP is not starting to backup

[Clay L. <cl...@le...>]

There are scenerios within SQL Server that can block a backup.  I'd look at
the processes in SQL Server to see if there is any blocking.

On 11 October 2010 16:50, Vinko Vrsalovic <vin...@fo...> wrote:

> On a specific database, msbp running as specified below never starts.
>
> C:\MSBP>msbp.exe backup [dbname] zip64(filename=dbname.bak)
> file://C:\test.bak
> local:
>        path=C:\test.bak
> zip64: level = 7, filename=dbname.bak
> ^C
>
> After a few minutes I break the command (in fact it hang for 72 hours as
> the scheduled
> task I have running it killed the task and there were three days without
> backups).
> msbp starts the backup instantly on other databases so this is a
> database specific
> problem. I have many copies of this database schema (from a single
> master source)
> running which can be backed up, so it doesn't look like it's the schema.
>
> dbcc checkdb ended with
>
> CHECKDB found 0 allocation errors and 0 consistency errors in database
> 'dbname'.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
>
> So, before I setup a development environment to test this I wanted to
> know if you can
> think of a scenario that would hang msbp right before starting the backup.
>
> Debugging guidelines would be helpful as well.
>
> Thanks for any input
>
> --
> Vinko Vrsalovic Bolte
> vin...@fo...
> Fonetic Solutions S.L.
> +34 917433326
> +34 608976970
>
>
>
> ------------------------------------------------------------------------------
> Beautiful is writing same markup. Internet Explorer 9 supports
> standards for HTML5, CSS3, SVG 1.1,  ECMAScript5, and DOM L2 & L3.
> Spend less time writing and  rewriting code and more time creating great
> experiences on the web. Be a part of the beta today.
> http://p.sf.net/sfu/beautyoftheweb
> _______________________________________________
> Mssqlcompressed-users mailing list
> Mss...@li...
> https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users
>