transaction log backup through SQL Server Management studio

[Former Member]

Dear All,

I need to configure transaction log backup through SQL server management studio.

It is already being configured for our PRO server(not by me) and now I want to configure it for DEV server.

In PRO I am taking it through(SID/right click/task/backup)

Then under backup type only full and differential option is coming for DEV.

Whereas for PRO all three(full/differential/transaction log) is coming.

Please suggest how to do it for DEV.

helpful suggestion will be duly rewarded.

Regards,

Ashutosh

[Former Member · Accepted solution]

Hi,

I think you dev recovery type is simple just change it to full

you will now be able to do the transactional log backup.

Regards,

Vamshi.

[Former Member · Accepted solution]

Yes vamshi you are absolutely correct.

Please tell me the procedure how to make it full.

Surely full points will be rewarded.

Regards,

Ashutosh

[Former Member · Accepted solution]

Hi,

Just go to the database you want

right click then properties then options

then set recovery model to full.

Hope this helps .

Regards,

Vamshi.

[Former Member · Accepted solution]

thanks..

regards,

Ashutosh