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