|
|
 Posted 8/9/2009 4:57:50 PM |
|
|
Supreme Being
 
Group: Forum Members
Last Login: 8/10/2010 1:01:37 AM
Posts: 328,
Visits: 898
|
|
| I was wondering if this might be the cause of some of the issues noticed recently. Our Server log file located at C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\BackupServer15_Log.LDF is 12 Gb and the BackupServer15_Data.MDF in the same location is 2 Gb. Can anyone comment on how we might manage these files?
Pete B
http://www.Backup-My-Files.com.au
Australia
|
|
|
|
| Posted 8/10/2009 2:48:25 AM |
|
|
Forum Guru
Group: Forum Members
Last Login: 6/17/2010 3:45:07 PM
Posts: 177,
Visits: 1,171
|
|
Hmmm...I've seen here a solution for that issue some time ago.
Actulally I don't find that specific topic again...
It was something with the log settings of MS SQL...
|
|
|
|
| Posted 8/10/2009 5:15:31 AM |
|
|
Supreme Being
Group: Forum Members
Last Login: 8/10/2010 1:01:37 AM
Posts: 328,
Visits: 898
|
|
| Found the solution :-) Go to SQL Server Management Studio or Studio Express Right click on the database, Properties, Options, set Recovery Mode to Simple, OK then Right click on the database, Tasks, Shrink, Files, File Type=Log, OK C'est tout I now have 10 Gb more space on C Drive
Pete B
http://www.Backup-My-Files.com.au
Australia
|
|
|
|