April 19, 2013 at 5:27 pm
I'm helping a friend troubleshoot an issue with a SQL 2008 R2 database that is sitting behind SharePoint. Currently, SQL is loaded on a server that is using RAID 1 for the OS (13GB space free) and RAID 5 for data (O GB free).
There are 8 log files totaling approximately 100 GB (6-11 GB per file). The automated backups stopped running over a month ago b/c the log files kept growing and maxed out the space on the RAID 5 array. We tried to shrink the logfile, but that option is grayed out in SSMS (possibly b/c the log file has not committed?). The drive bays in the server and motherboard will not support additional drives. Can I plug in a USB drive and backup the log file to the USB drive?
I'm looking for options to backup, shrink, the log file so that we can get SharePoint, SQL backonline, and then adjust the backup strategy longer term to prevent this from happening again.
Appreciate your feedback!
Michael
April 19, 2013 at 5:46 pm
What is the recovery model of the databases?
Definitely not a Best Practice, but you can add a usb or sata drive and backup to that.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 19, 2013 at 6:35 pm
Your backup log is greyed out because it needs a full backup. You should be able to use a USB drive. This is not a cluster right?
April 19, 2013 at 7:35 pm
fivetenmm (4/19/2013)
The automated backups stopped running over a month ago b/c the log files kept growing and maxed out the space on the RAID 5 array.
Do you have any of those backups available (curious)? Also, are the backups set to expire by chance?
Did any of those backups succeed?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 20, 2013 at 5:01 am
Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply