matt6749 (7/23/2014)
Thank you all for your valuable help.The hosting company has done this (hope it's ok):
They said they do nightly backups. They set my recovery mode to Simple and restricted the log size to 30mb. I think it's ok because the data is not mission critical and I back it up myself also with a console app I wrote. ?
Thanks,
Matt
Good. Glad to hear they got it straightened out.
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