no hay problema! Me alegra saber que ayudó a 😀

Hi Ravichandra,

This article[/url] also explains it nicely.

Some other process (not necessarily a job) is causing the Reindex job to be deadlocked. Please go through this article[/url] which helps you to troubleshoot deadlocks.

No Problem. Glad it worked!

The System Event Log will have details as to when the node failed over.

goldspoon9 (11/28/2010)

Executed as user: server A. Msg 18456, Level 14, State 1, Server server B, Line 1 Login failed for user 'server B\Guest'. Process Exit Code 1. ...

What was the error message?

Maintenance Plans are dependent on SSIS until SQL Server 2008 SP1 CU3. This dependency has been taken off starting SP1 CU3. More details here

GilaMonster

No it won't. Taking a full backup, making changes to the database and not taking tran log backups causes the tan log to grow. It won't grow by itself if...

GilaMonster (11/28/2010)

Recovery model not withstanding, model won't grow (data or...

@invaliddba,

Is the data file size 80 MB or Transaction Log size? If the transaction log size is growing, I suspect you would have scheduled a FULL backup for model database...

From the error message "System.ArgumentException: Font 'Tahoma' does not support style 'Regular'", I feel that the font "Tahoma" is not installed on your system. Please check if it exists or...

Yes. All the files in that directory can be safely deleted. These are the files which have information regarding the installation/hotfix applied to SQL Server.

I agree with Grant. Please make use of the "Refresh" button to refresh the objects in SSMS.

Create a file with the below command and save it as C:\backupcmd.sql

BACKUP DATABASE [databasename1] TO DISK = '\\thepathofbackupfile\backupfilname1.bak'

go

BACKUP DATABASE [databasename2] TO DISK = '\\thepathofbackupfile\backupfilname2.bak'

go

BACKUP DATABASE [databasename3] TO DISK = '\\thepathofbackupfile\backupfilename3.bak'

go

then...