Post reply

How can i generate backups sqlserver7.0 database

  • June 3, 2008 at 12:41 am

    #380900

    I have sqlserver 7.0 called "TestDB" and i configured this database to sqlserver 2005 database with compatability mode set sqlserver 7.0. Its working fine. Now i want to create backup for this database and generate transaction log daily .So i generate scheduler for this.

    when i try to run this scheuler system doesn't create any backup & transaction log for "TestDB" and creates sqlserver2005 databases.

    Pls help me out

    sethu

  • June 3, 2008 at 2:29 am

    #823462

    Sethu,

    I think you need to change the compatability of your Testdb to 80 or 90. Because the maintenance plan will not be able to backup the Sql 2005 databases which are having a compatability of 70

    [font="Verdana"]- Deepak[/font]

  • June 3, 2008 at 2:39 am

    #823467

    [font="Verdana"]You can make use of the below command to change the database compatability,

    sp_dbcmptlevel 'Dbname', 90

    Refer this link for more info,

    http://msdn.microsoft.com/en-us/library/ms178653.aspx[/font]

    [font="Verdana"]- Deepak[/font]

  • June 3, 2008 at 2:40 am

    #823469

    Thanks Deepak,

    If i change compatability level is 80 or 90, do i change any SQL statements inside stored procedure cas i have created lots of stored procedure 7.0 compatability. Without stored procedure modifications how can i generate backups?

    sethu

  • June 3, 2008 at 2:45 am

    #823472

    I don't think that should be a problem..But without changing the compatability I don't think it is possible to use maintenance plan

    [font="Verdana"]- Deepak[/font]

  • June 3, 2008 at 2:58 am

    #823478

    Thanks,

    I don't know deepak. So without compatability change, system doesn;t generate transaction logs. Is't?

    If i need transaction log, i can change all the stored procedures based on sqlserver2005 compatability.Am i correct?

    sethu

  • June 4, 2008 at 3:35 am

    #824059

    Without changing the compatability you cannot take t-log backup for the Sql 7 databases using the maintenance plan. But you can try using T- Sql,

    Backup log dbname to disk='Path\filename.trn'

    [font="Verdana"]- Deepak[/font]

  • June 4, 2008 at 7:10 am

    #824140

    I had the same problem and was not able to change the compatibility mode. I was only able to run backups using t-sql scripts.

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

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