Viewing 15 posts - 196 through 210 (of 508 total)
there are scripts here that will issue a kill command and that will remove any connections from users on the server then you can issue dbcc statements that will flush...
March 11, 2004 at 6:03 am
In BOL search for master you will see master server and slave server setups. This has a very limited use. It will allow you to schedule one job on a...
March 8, 2004 at 10:35 am
if that doesnt work you will have to do a dbcc checkdb repair with allow data loss to fix it. You may want to DTS the data out of the...
March 8, 2004 at 10:23 am
I would also check to see if your backup dump file is on a network share, that can also cause problems if the network becomes unavailable or if the server...
March 8, 2004 at 10:17 am
You can also kill all active threads flush caches to free up memory inside the SQL Server memory space. I would avoid stopping and starting SQL for one simple reason, tempdb...
March 8, 2004 at 10:11 am
Ether break up the 100,000,000 record tables into a partitioned view or create new files and filegroups and rebuild the tables on to them to split up the I/O accross more...
March 8, 2004 at 8:54 am
It looks like you may be backing up over the network?? Usually if it fails to write to the backup it is because another process is locking the backup file...
March 8, 2004 at 8:48 am
Well, to be honest with you I don't have a clue. Personally I quit using the supplied log shipping a long time ago and only emplement custom log shipping. I...
March 5, 2004 at 12:44 pm
Full text search is seprate from the SQL instance if you install it once it is available to all instances. You can set the collation on a per database basis...
March 5, 2004 at 12:36 pm
You will have to reinitalize your log shipping apply the last full diffs and tlogs to get you current and extend your retention time. Personally, I don't use MS log...
March 5, 2004 at 12:22 pm
I would index this as a single clustered index. It will have a high degree of selectivity and perform quite well. A previous post is correct clustered index leaf contains...
March 5, 2004 at 12:18 pm
You may want to look up how to set a database in emergency mode. If you can attach the database datafiles then set the database to emergency mode and bypass...
January 22, 2004 at 5:50 am
I backup to a UNC to keep backups live on site for up to a week. We use a mix of SQL Litespeed and normal sql backups depending on the...
January 22, 2004 at 5:42 am
http://www.howstuffworks.com is a good low level on how things work including RAID and hard disks.
January 19, 2004 at 3:13 pm
I agree if you are front loaded on writes raid 0+1 is the way to go. At 14 drives configured raid 0 I would expect you could hit the limit...
January 13, 2004 at 9:11 pm
Viewing 15 posts - 196 through 210 (of 508 total)