Post reply

Backup Issues

  • January 19, 2006 at 3:24 am

    #170569

    Hello all,

    i am diong some development work and when i tried to back up one of my databases using a maintenance plan, i get this error as part of the notification e-mail:

    Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'SLV-BOBJ' as 'DOMAINNAME\Administrator' (trusted)

    Starting maintenance plan 'DB Maintenance Plan2' on 18/01/2006 11:05:03

    Backup can not be performed on database 'databasename'. This sub task is ignored.

    End of maintenance plan 'DB Maintenance Plan2' on 18/01/2006 11:05:03

    SQLMAINT.EXE Process Exit Code: 1 (Failed)

    Emailing report to operator 'David Aitchison'

    Any help greatly appreciated.

    David

  • January 19, 2006 at 3:50 am

    #615731

    does that database exist?

    is it sent in offline mode?

    is this a maintenance plan for all user databases, or for specifically named databases

    MVDBA

  • January 19, 2006 at 3:54 am

    #615733

    I think I have seen this before when trying to backup the transaction log on a db set for simple recovery.

    (slow day watching dts)

     

     

  • January 19, 2006 at 4:15 am

    #615739

    Michael,

    The database does exist, i've just removes it's real name from the post.

    it is not set in offline mode, should it be?

    and this is just a plan for this single database and tran. logs.

    Thanks!

    David

  • January 19, 2006 at 4:27 am

    #615743

    then i'll go with what allen says - what is the recovery mode of the database

    you can find it out by runing

    sp_helpdb or clicking on the properties option in enterprise manager

    if you're in simple then your t-log backups will fail as they are already truncated at each checkpoint

    MVDBA

  • January 19, 2006 at 6:56 am

    #615772

    Thanks michael, i have run sp_helpdb on the database in question and i got this error:

    Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53

    Cannot insert the value NULL into column 'owner', table 'tempdb.dbo.#spdbdesc___________________________________________________________________________________________________________00010000016F'; column does not allow nulls. INSERT fails.

    The statement has been terminated.

    is it just as simple as allowing NULL's on that column? or did i miss a paramater?

    I'm fairly new to SQL (as you have probably guessed) - so apologies if i miss anything.

    David

  • January 19, 2006 at 7:27 am

    #615787

    I think you need sp_helpdb '<your db name>'

  • January 19, 2006 at 7:28 am

    #615789

    but i had selected that DB from the drop down menu in QA.

     

    Edit - just ran it, got the info i need. thanks.

  • January 23, 2006 at 2:14 am

    #616334

    Hello again,

    I'm still having issues with my backups, this time i have created a job in Management that uses T-SQL, the command looks like this:

    BACKUP DATABASE [uscgdm_staging] TO  TAPE = N'\\.\Tape0' WITH  INIT ,  NOUNLOAD ,  NAME = N'uscgdm_staging backup',  NOSKIP ,  STATS = 10,  NOFORMAT

    the only thing i can think of is that the owner of the database is different to that of the owner i have specifie to run this job. Would this cause a failure?

    Thanks again!

    David

  • April 6, 2007 at 10:42 am

    #699050

    Hi Everyone,

    I m also facing the same kind of issue. But in my case.. the DATABASE done NOT appears in the EM. Can someone suggest what to look for?

    Thanks !!

    Manoj

  • April 6, 2007 at 10:43 am

    #699051

    In continuation to my previous message... I am also not able to locate the entry for the database in master..sysdatabases.

    Manoj

Viewing 11 posts - 1 through 10 (of 10 total)

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