Viewing 15 posts - 12,931 through 12,945 (of 49,552 total)
Get yourself a copy of SQL Server 2008 Internals by Kalen Delaney, there's an entire chapter on how CheckDB works.
June 1, 2013 at 3:29 am
Jack Corbett (5/31/2013)
June 1, 2013 at 3:26 am
The only time when CheckDB is run on a database is when a user, application or job explicitly runs CheckDB.
May 31, 2013 at 4:17 pm
No, table-type parameters have to be read only.
Declare a table variable inside the proc, insert the contents of the parameter into that and manipulate as you like. Or create a...
May 31, 2013 at 1:48 pm
Lynn Pettis (5/31/2013)
Your log file won't shrink(when using SHRINK_FILE) until you start getting the VLFs at the front of the file to an inactive status.
End of the file.
May 31, 2013 at 1:46 pm
And there's your problem right there...
Kingfish (5/31/2013)
backup log mydatabaseto disk = '\\someserver\backups\logbackup_timestamp.bak'
with no_truncate, init
You've explicitly told SQL to not truncate the transaction log on backup, not to mark portions of...
May 31, 2013 at 1:45 pm
Could you post the exact log backup command that you're running?
May 31, 2013 at 1:33 pm
GilaMonster (5/31/2013)
If you see that the log is not being reused after a log backup and the log file keeps on growing, then please take a read through this: http://www.sqlservercentral.com/articles/Transaction+Logs/72488/
May 31, 2013 at 10:06 am
Log backups don't shrink the log file, hence you shouldn't expect to see the log file get smaller. Log backups just mark portions of the log reusable.
If you see that...
May 31, 2013 at 9:11 am
Not being nasty, but could you edit that and take out the font tags? Use the [ code ] tags (shortcut on the left)
May 31, 2013 at 9:07 am
Yes, it's not exempt from licensing as a passive standby server would be, hence it needs to be licensed. There's nothing in the licensing docs that say anything about number...
May 31, 2013 at 8:40 am
SELECT * FROM master.sys.messages WHERE text LIKE 'New queries assigned to process on%'
May 31, 2013 at 7:42 am
rajeev.training (5/31/2013)
May 31, 2013 at 7:41 am
Viewing 15 posts - 12,931 through 12,945 (of 49,552 total)