Expressmaint does not backup db

Mar 31, 2012 at 7:17 AM

I have having a problem getting database backups created.  The utility makes a connection with the db, but does not seem to either find a specific db, or does nothing with ALL_USER.  I am leveraging your example #1 for a full backup of all databases to specific backup and report directories.  The databases certainly exist.  I wonder if I’m getting caught by not having full admin rights.  Any thoughts?

Here is my system info:

Windows Server 2008 R2 OS

MS SQL Server 2005 is installed

I have a user account, but do not have full admin rights else I’d use the Agent to do this for me

I have several databases that are enabled for my user account

The report file shows the following:

----------------------------------------------------------------

Expressmaint utility v2.0.0.0 , Logged on to SQL Server [wcosdbz1] as [et3]

Created by Jasper Smith (www.sqldbatips.com)

Starting backup on 3/28/2012 5:47:29 PM

[1] Delete old Report files...

    0 file(s) deleted.

Expressmaint finished successfully at 3/28/2012 5:47:29 PM with Return Code(0)

----------------------------------------------------------------

 Or this:

----------------------------------------------------------------

 Expressmaint utility v2.0.0.0 , Logged on to SQL Server [wcosdbz1] as [et3]

Created by Jasper Smith (www.sqldbatips.com)

Starting backup on 3/28/2012 6:00:52 PM

            Database ONLINE_LABS_QA not found

Expressmaint finished unsuccessfully at 3/28/2012 6:00:52 PM with Return Code(-4)

----------------------------------------------------------------

Aug 7, 2012 at 1:57 PM

I have a little more info on this one. (I'm creating an issue in the issue tracker too.)

 

I have a server with both the 32 bit version of sql server and the 64 bit version.

Everything works perfect with the 32 bit instance.

With the 64 bit instance, I get the:

 

Starting backup on 3/28/2012 5:47:29 PM

[1] Delete old Report files...

    0 file(s) deleted.

Expressmaint finished successfully at 3/28/2012 5:47:29 PM with Return Code(0)

messages.