Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bhs.it
Starting Member
1 Post |
 Posted - 2012-04-12 : 13:31:28
|
| I’m not a SQL Server guru, but I’ve inherited a SQL 2008 R2 server that is hosting several small databases for things such as Backup Exec, Symantec Endpoint Protection, WSUS, BES, etc… The server did not have any maintenance plans in place. Backup Exec is being used for backups and is only backing up the databases. The transaction logs where not being backed up or truncated. This has led to several issues now which we are trying to resolve. The main issue is that several of the data and logs are at 1% free space.1. The first step I’ve taken is created a maintenance plan that checks database integrity, update statistics, backup database (full), maintenance cleanup tasks.2. The second step is that I’ve changed all the databases to recovery mode: FULL.3. The third step is I’ve created a second backup exec job using: Log – Back up Transaction Log.Do the above steps seem correct? I’m not sure what to do about low free space for the data and logs?Also, the C drive is full because of a large amount of SQLDump.mdmp files and ErrorLog files located under the C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\LogPlease advise on steps to take to resolve. |
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-04-12 : 13:48:48
|
| Looks like you are in a desperate need of some free space.Delete those log files from the C drive.Shrink the log files(SHOULD ONLY BE A ONE TIME ACTIVITY AND NEVER EVER SHRINK DATA FILES)and see if you get any free space.If that does not help then you have to increase the disk space.After Monday and Tuesday even the calendar says W T F .... |
 |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2012-04-13 : 01:27:24
|
| There are lots of reasons because of that transaction log file size get increased. Please read this article to find out the reasons as well as solution: http://www.recoverdatabase.blogspot.in/2012/04/what-to-do-if-sql-server-log-file.html |
|
|
|
granuharmot
Starting Member
31 Posts |
Posted - 2014-09-23 : 05:05:46
|
| unspammed |
|
|
|
|
|
|
Need some desperate help with SQL server