Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SQL SERVER EVENT ERROR Expand / Collapse
Author
Message
Posted Monday, May 21, 2012 10:30 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, June 26, 2014 8:49 AM
Points: 2,276, Visits: 779
there are 2 ways

right 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.


MVDBA
Post #1303511
Posted Monday, May 21, 2012 10:44 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 26, 2013 12:26 AM
Points: 47, Visits: 180
michael vessey (5/21/2012)
there are 2 ways

right 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
Post #1303528
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse