Viewing 15 posts - 886 through 900 (of 1,319 total)
The system DBs default to simple recovery mode on install so you don't need log backups for them. A full backup once a week should suffice.
-- You can't be late until you show up.
October 8, 2008 at 2:57 pm
It may involve re-installing the service pack. Check this out.
http://www.tek-tips.com/viewthread.cfm?qid=1127815&page=1
-- You can't be late until you show up.
October 7, 2008 at 2:10 pm
Our infrastructure team is separate from the application side, in a sense. They're responsible for procuring/repairing hardware and all other network needs, getting everything ready for the applications part of...
-- You can't be late until you show up.
October 7, 2008 at 12:34 pm
just.jelena (10/6/2008)
I have similar problem, keep getting messages
The statement has been terminated.
Msg 9002, Level 17, State 4, Line 1
The transaction log for database 'dbname' is full...
After running:
BACKUP...
-- You can't be late until you show up.
October 6, 2008 at 10:11 am
The script, as Steve stated, is on this site at:
http://www.sqlservercentral.com/scripts/Index+Management/31475/
-- You can't be late until you show up.
October 6, 2008 at 7:18 am
Dugi (10/6/2008)
and just to notify you that the SQL Server 2000 has 4 service packs you should install them ...
FYI - Each service pack is cumulative, so if you...
-- You can't be late until you show up.
October 6, 2008 at 7:13 am
Hmmm....BOL and DBCC ShowCONTIG yields this:
E. Use DBCC SHOWCONTIG and DBCC INDEXDEFRAG to defragment the indexes in a database
Seems to be what Jeff is/was pointing to...
-- You can't be late until you show up.
September 30, 2008 at 7:59 am
KDASQL (9/25/2008)
-- You can't be late until you show up.
September 25, 2008 at 10:03 am
Thanks Chad. Many methods to the same result. The biggest item, and I cannot stress this enough, is to test your D/R scenario. Be absolutely certain that if you need...
-- You can't be late until you show up.
September 25, 2008 at 10:00 am
Chad Carter (9/25/2008)
-- You can't be late until you show up.
September 25, 2008 at 9:09 am
You can do a DBCC Shrinkfile but I would caution against doing this with any regularity (leads to physical disk fragmentation). MSSQL manages things appropriately - IMO. What are the...
-- You can't be late until you show up.
September 25, 2008 at 7:07 am
The real question is - what do your business needs dictate (the old "it depends" answer)? Full backups and diffs provide protection but the logs and point-in-time restores will prove...
-- You can't be late until you show up.
September 25, 2008 at 7:00 am
I always reserve myself!!! 😎 Table space is different in MS SQL than with some other DB engines. Setup the amount of space for the DB to allow for sufficent...
-- You can't be late until you show up.
September 25, 2008 at 6:49 am
Thanks Jeff and David - I did a brief look-over and these appear to do what I need, with some tweaking of course. I'll post my final solution but, again,...
-- You can't be late until you show up.
September 23, 2008 at 7:15 am
By default, msdb is not really using the log as it's set to simple recovery mode (truncates on checkpoint) so growth should be relatively small if at all. TempDb is...
-- You can't be late until you show up.
September 22, 2008 at 10:44 am
Viewing 15 posts - 886 through 900 (of 1,319 total)