michael vessey (5/21/2012)
there are 2 waysright click on the database and choose properties and then in one of the screens there will be a recovery mode box (i don't have sql 2000 installed so i can't screen shot it)
or the easier way is using an SQL SCRIPT
ALTER DATABASE xxx SET RECOVERY SIMPLE
in older versions of sql you could also use the sp_dboption command
be sure to read up in books on-line before you make the change - just so you understand the implications.
Mike i have had a look at the DB and right click got to see the properties and all the settings.... i will have to talk to the IT manager and the other guys and hear their inputs
Thanks and i will post back an update