Changing Recovery otpion

[HLPCH]

I would like to backup the Transaction Log of my database.
When i do a backup I see the Transaction log option is grayed out. I read that I need to change the recovery model of the Model database. How could i do this?

Thanks in advance.

 

[SQLBill]

Which database do you want to backup? The Master database can only be set for SIMPLE and you can't backup those logs.

Setting MODEL's recovery mode doesn't change anything else. MODEL is just a 'template' that is used to create other databases.

What permissions do you have on the database?

-SQLBill

Posting advice: FAQ481-4875

 

[HLPCH]

I have Sql Server installed on my local machine. And I have the administrative rights. I want to do as a test and backup of one of the databases(AMRTrial) created by me. I would like to do a complete backup fo the database and also its Transaction log .

Thanks a lot for your help!

 

[SQLBill]

Which version of SQL Server do you have installed - the Evaluation Edition or a licensed edition?

-SQLBill

Posting advice: FAQ481-4875

 

[HLPCH]

Version 8. I guess this was the licensed Edition.

 

[Catadmin]

Right click the database name, and go to properties. Go to the options tab. You'll see Recovery Mode there. Change it to either FULL or Bulk-Logged in order to get Transaction Logs that you can backup.

Remember, though, Bulk-Logged only sends certain transactions to the TransLog and ignores others. Full mode records everything. Look up Bulk-Logged in Books Online for more details on what it does and does not track.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???