Viewing 15 posts - 5,776 through 5,790 (of 9,253 total)
Other things to consider
How many logical drives are you using?
What are the physical disk configs underneath these?
April 7, 2012 at 12:03 pm
Jeff Moden (4/7/2012)
check the scheduled jobs and see what's happening around that time frame.
Great minds think alike 🙂 😉
April 7, 2012 at 11:37 am
Can you supply the table definition too?
April 7, 2012 at 11:33 am
The backup related tables you require are in the MSDB. Use the following query
Select database_name, Compatibility_level, Recovery_model,
DATABASEPROPERTYEX(database_name,'Status'), Type
from msdb.dbo.backupset
April 7, 2012 at 11:28 am
Are referring to native or 3rd party backups, there is a difference
April 7, 2012 at 7:57 am
kranthi.india123 (4/7/2012)
3.6. Update statisticsIt is recommended that, after having committed or changed the compatibility mode to 100, execute the stored procedure: sp_updatestats
You first execute DBCC UPDATEUSAGE(), this is required when...
April 7, 2012 at 6:55 am
As an extra option you could turn SORT_IN_TEMPDB on, this may offload somewhat to the TempDB rather than using the database filegroup
April 7, 2012 at 6:46 am
shahgols (4/6/2012)
Given the setup below, what would happen if the tempdb on the C:\ drive fills up? Will SQL Server crash or does it continue processing by using...
April 7, 2012 at 4:36 am
Server side traces have much less impact apart the potential for required disk space depending on what you are monitoring
April 7, 2012 at 4:33 am
george sibbald (4/4/2012)
User databases either backup\restore or detach\attach. Backup\restore usually best because the files to copy are smaller and backout is easier if problems with the migration.
The backups generally won't...
April 7, 2012 at 4:12 am
jason07 (4/5/2012)
*** Error: Access to the path '\\WEBSVR-KL1\TransacLogKL1' is denied.(mscorlib) ***
tells you all you need to know
jason07 (4/5/2012)
Permission on folder i check no problem as same with other copy job.
Permission...
April 7, 2012 at 4:04 am
Check connectionstrings.com all the info you need will be there
April 7, 2012 at 3:52 am
Elliott Whitlow (4/6/2012)
April 7, 2012 at 3:46 am
I'd start by runnuning through and verifying any agent jobs that run or have run around that time just to know what they're all doing.
April 7, 2012 at 3:43 am
Minnesota - Viking (4/5/2012)
April 7, 2012 at 3:31 am
Viewing 15 posts - 5,776 through 5,790 (of 9,253 total)