Viewing 15 posts - 3,526 through 3,540 (of 4,745 total)
here's a good article on managing transaction logs
http://www.sqlservercentral.com/articles/64582/
this should work (try to do at a quite time):
just for info run dbcc sqlperf(logspace) which will tell you how much of the...
June 29, 2009 at 4:26 pm
We run Altiris here. Our 'Incidents' database is very small at only 9MB and is in simple user mode. It appears to be static but that may be installation specific.
Its...
June 29, 2009 at 4:04 pm
Patrick Womack (6/29/2009)
Thanks, Jeff.
you're welcome 😉
Not being a DBA I want to make sure there will be no adverse effects of turning Autoclose off. Can you think...
June 29, 2009 at 2:36 pm
I believe for sql express the database option auto close is enabled by default. Amongst other things this can cause the proc cache to be cleared causing slow downs in...
June 29, 2009 at 2:20 pm
then please post more info, such as table schema, size of table, execution plan.
you say delete A record, are you sure only one record meets that criteria?
June 29, 2009 at 7:34 am
first thing, is it blocked by any other processes?
June 29, 2009 at 7:17 am
you say you have heavy disk fragmentation? If this is at the drive level invest in a tool such as diskeeper to defrag the disk. If it is fragmentation within...
June 28, 2009 at 4:22 am
well, unless a disaster happens, nothing has gone wrong yet. 🙂
From the name of the file for which there is not enough space it is the transaction log? Can you...
June 27, 2009 at 3:30 pm
You will need to add the extra disk space to the DR server as well. The DR server needs at least enough space to be able to support the size...
June 27, 2009 at 2:04 pm
good point Scott I forgot about making the share a cluster resource, sorry
June 25, 2009 at 3:54 pm
In a cluster the SQL instance is a virtual instance, its name does not change when it fails over and there is only one set of database files. Therefore logshipping...
June 25, 2009 at 3:50 pm
vrabhadram (6/25/2009)
what is RTM,
RTM = Release To Market
June 25, 2009 at 7:36 am
two people said the same thing, we must be right! 🙂
June 25, 2009 at 7:19 am
firstly, why upgrade to SP1, SP3 is out, upgrade to that.
Back up all your databases first, especially system databases.
If you are able to , stop the services first and copy...
June 25, 2009 at 7:16 am
--SQL 2000
returns dbname, total size of all data files in MB, size of latest backup in MB,recovery mode and owner for all databases that have been backed up.
SELECT
A.NAME,
...
June 25, 2009 at 7:04 am
Viewing 15 posts - 3,526 through 3,540 (of 4,745 total)