Post reply

which backup mode is in place

  • April 16, 2009 at 9:22 am

    #203026

    i have sql 2000 - i am trying to find out which backup model i have - i have run 'select dbpropertyex("database", "recovery")', but i get an error 'dbpropertyex' is not a recognized function name. is there another way to find this out?

    thanks

  • April 16, 2009 at 10:12 am

    #979005

    It's the recovery model, and you would find this in the database properties, option tab.

    From T-SQL,

    SELECT DATABASEPROPERTYEX('msdb','Recovery')

  • April 16, 2009 at 10:24 am

    #979019

    thanks - that worked -

    how do i change the backup mode from simple to full for a specific database?

  • April 16, 2009 at 10:29 am

    #979026

    it's simply

    ALTER DATABASE Yourdbname SET RECOVERY SIMPLE

    or

    ALTER DATABASE Yourdbname SET RECOVERY FULL

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • April 17, 2009 at 4:52 am

    #979537

    don't forget to set up a transactionlog backup job when switching to FULL Recovery

    else you have a growing transactionlog

Viewing 5 posts - 1 through 4 (of 4 total)

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