T

his is what I would call an Intra-table deadlock. Most people think of a deadlock as between two process accessing two tables (inter-table) in different orders, but here the two...

If you uninstall SSIS from NODE1, then what happens to the Maaintenance palns that are running on NODE1. We are using maintenance...

I

If that is the case, then installing the SSIS...

What is the schedule for log backup job, copy job & restore job?

how many mins or hrs you set for the option "alert if no backups occur within"? Ideally you...

Is this applicable to our case (having SSIS in Active node and NOT on Passive node)?

please advice??

I too have the same question. We have 2 node active/passive cluster setup for SQL Server 2005 with SP3

On NODE1 (Active), we have Integration Services installed but not on NODE2...

any ideas on this scenario? I appreciate your inputs

thanks

Shilpa,

Please post the solution once you resolve the issue. I'm eager to know the solution as I'm thinking it' due to restart of DC's

Hi Shilpa,

We also used to get this error messages. After analyzing, I came to know that when ever the Domain controller restarts, there will be loss of network communication and...

Thanks Steve,

The copy is a file system copy, not a SQL Server copy. The backup is taken, and should use minimal memory from SQL Server to get the pages from...

Thanks,

I ran the below script first:

CREATE PROC sp_import_errorlog

(

@log_name sysname,

@log_number int = 0,

@overwrite bit = 0

)

AS

/*************************************************************************************************

Purpose:To import the SQL Server error log into a table, so that it can be queried

Written...

Absolutely. CheckDB reads every allocated page in the entire database, hence you're going to have a lot of churn in the data cache as pages come in get checked and...

I have created the procedure that given in the link and executing as below

exec sp_import_errorlog

@log_name =errorlog,

@log_number = 0,

@overwrite = 0

but getting the below error:

Msg 213, Level 16, State 7, Procedure...

Could you please shed some light on this?

Do we need to create multiple data files for the COntent database which is more than 100 GB only? or

It required to create multiple data files for the COntent database...