Viewing 15 posts - 196 through 210 (of 335 total)
OOPS, type error:
I recommend autoshrink, with a maxfilesize. This prevents you from messages like you get and you'll have the guarantee the file won't blow up your disk.
It should be:
I...
September 26, 2008 at 1:46 am
The size of your logfile has no effect on your full backup, neither has the recovery model. The full backup is a copy of your data and indexes (actually what's...
September 26, 2008 at 1:13 am
If your initial size has gone back to 1, you probably have autoshrink on. If you don't allow autogrowth (which i don't recommend), don't enable shrink (you'll only have the...
September 26, 2008 at 1:09 am
You can have multiple filegroups and multiple datafiles in a filegroup, but you must have a filegroup called primary with at least one datafile.
The first datafile has the extension of...
September 25, 2008 at 7:04 am
Are forward pointers always limited to the same physical file, or can you point to a location in another file (within the same filegroup)?
September 25, 2008 at 6:54 am
Table Name Rows Reserved (KB) Data (KB) Index Size (KB) UnUsed (KB)
Table1...
September 25, 2008 at 6:27 am
Is seems that NIManagementDB is watching your transactionlogfile and registers when this file needs to expand. If this file expands > 4 times in an hour(?), it's complaining (This is...
September 25, 2008 at 5:01 am
Your disk is becoming a bottleneck:
SQL Server has encountered 16 occurrence(s) of I/O requests taking longer than 15 seconds to complete on ...
Several processes are struggeling for I/O completion on...
September 25, 2008 at 4:54 am
Yes, that should work. Make sure you add the NORECOVERY parameter to eacht restore statement, until you're at the latest logfilebackup. Restore that backup with the RECOVERY parameter.
I stronly advise...
September 25, 2008 at 2:57 am
CU9 is already available and according to Microsoft, CU10 is currently build :hehe:
Vote for SP3! 🙂
Tip: to check if your SQL is up-to-date: http://support.microsoft.com/kb/937137
September 25, 2008 at 12:10 am
The recovery model doesn't affect the full backuptime, it only eliminates the need for logbackup in case you have a SIMPLE recovery model.
If you're running out of backup time, you...
September 25, 2008 at 12:07 am
Very interesting question!
Here are my 5 cents:
- Use a 64bit Enterprise environment
- Use a SAN with a lot of disks
- Which backup solution are you gonna use? (backuptime,...
September 24, 2008 at 11:58 pm
Make sure you download the freeware version.
SQL Express doesn't have a job scheduler. SQLSafe comes with an commandline utility and several stored procedures. So you have the choice of scheduling...
September 24, 2008 at 11:41 pm
Thanks for your input. Thus: forwarding pointers can only occur on heaps, while page splits only occur on indexes?
September 23, 2008 at 11:11 pm
Other tip: While your PDF is on your screen, go to your internet cache directory and copy the PDF file
September 23, 2008 at 1:42 am
Viewing 15 posts - 196 through 210 (of 335 total)