Viewing 6 posts - 2,296 through 2,301 (of 2,301 total)
You should treat MSDE the same as SQL Server as far as fix levels, security setup, etc is concerned. There are many hacks out there that allow you to...
August 4, 2003 at 3:55 am
The following link may be interesting: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B328551
It looks like you can get some blocking within TempDB if TempDB has a lot of pressure from heavy workfile and/or temporary...
July 22, 2003 at 3:25 am
Quote: "The maximum (theoretical) size of a database is 1,048,516 TB, and not a single terrabyte as earlier suggested."
Don't forget you can have up to 32768 databases per server. ...
July 9, 2003 at 4:11 am
We run with SQL Logging all logons, and NT auditing set on for most things. There have been a few situations where people have claimed the DBAs 'must have'...
July 3, 2003 at 6:36 am
I just leave MSDB in simple mode, but do a full backup of MSDB shortly after my other backups are finished.
I do transaction log backups of the 'real'...
July 26, 2002 at 8:15 am
A few things to remember...
a) Space may be needed to process the transaction log, as well as database.
SQL Server will always scan the transaction log and to back...
May 27, 2002 at 5:30 am