Skip to Content
0
Apr 18, 2010 at 08:00 PM

Information about Transaction Log file

28 Views

Hi ,

1)We have finish the upgrade of our DEV system and the transaction log file is very big (bigger that the data file ^^....) and i don't kno what to do with this file.

We have to do a backup strategie this week and i know that in the SQL server management studio we can done maintenance plan ( backup...)

But i have see nothing in the SQL server managerment studio for deleting transaction log file...

2)In the DB02 dababase Check there is a warning because the transaction Log file are on the same device than tempdb, we have other disk on the serveur and i don't know how to manage and and change destination for this LOG file....

Thx for help

Regdards

Edited by: BABY Fabrice on Apr 18, 2010 10:13 PM