Viewing 15 posts - 11,326 through 11,340 (of 39,909 total)
Ed Wagner (3/3/2014)
Steve Jones - SSC Editor (3/3/2014)
Steve Jones - SSC Editor (3/3/2014)
Going to submit to SQLBits. Gonna be a busy summer, it looks like.
I am. Might be slightly longer...
March 3, 2014 at 10:14 am
March 3, 2014 at 9:50 am
Yes, replication may be the rest for log growth. If replication was set up, and you have publications in this database, and replication was just let go, with subscribers turned...
March 3, 2014 at 9:29 am
Steve Jones - SSC Editor (3/3/2014)
Going to submit to SQLBits. Gonna be a busy summer, it looks like.
I am. Might be slightly longer in real time as I might interrupt...
March 3, 2014 at 9:25 am
You need to remove replication from this database. If you don't have replication running, the log can't clear.
March 3, 2014 at 9:24 am
Thanks, after about 3-4 weeks, I'll bump this for a reminder
March 3, 2014 at 9:14 am
Going to submit to SQLBits. Gonna be a busy summer, it looks like.
March 3, 2014 at 9:13 am
If you're trying to save money on licensing, I don't believe you an upgrade. However you can purchase 2012 Standard and "migrate" to this version.
March 3, 2014 at 9:03 am
GilaMonster (3/3/2014)
Take a read through this, identify why it's growing. Post back if you need further help once you've identified the root causehttp://www.sqlservercentral.com/articles/Transaction+Logs/72488/
Read through Gail's article. We can't see your...
March 3, 2014 at 8:57 am
You could use Powershell here. A job that calls this script and outputs to a filename based on the date.
There's a rename script here: http://ss64.com/ps/syntax-stampme.html
Here's a text file export:...
March 3, 2014 at 8:56 am
One big thing would be to move to a stable x64 platform. That was an add-on in SQL 2000, but in SQL2K8 you can easily use more memory, which should...
March 3, 2014 at 8:54 am
Datagod-309892 (3/3/2014)
March 3, 2014 at 8:50 am
Backup/restore for me as well.
I might script this as a daily process that moves the latest backup from production to test, but doesn't necessarily restore it. This would make it...
March 3, 2014 at 8:48 am
I haven't typically seen connection issues taking many resources in SQL2K5+ instances. In SQL 7, it could be an issue, but usually in the 1000s of connections.
Does the app have...
March 3, 2014 at 8:47 am
MyDoggieJessie (2/28/2014)
Try DBCC CHECKTABLE on the table that has the clustered index. No point in checking the entire DB when it's just the one table reporting the issue?
+1
March 3, 2014 at 8:43 am
Viewing 15 posts - 11,326 through 11,340 (of 39,909 total)