A Clarification regarding the master database; although the recovery mode can be set to FULL, transaction log backups cannot be performed and transaction log restores cannot be performed.

Here is the...

Master and Tempdb are always in simple recovery mode and you cannot change the recovery mode.

Model can be any recovery mode where new databases will be in the same mode....

The "Backup" command works at the database or database file level and there is no support for table level backups.

There are various utilities available such as the Bulk Copy Program...

Alter the view and include the "WITH VIEW_METADATA" option. You may also want to also include the "SCHEMABINDING" option, which sometimes improves performance.

From Books On-line:

Specifies that the instance of...

It depend (i hate that answer).

Let us call the...

My thinking is that the Database B process is simply kicking Database A out of memory. And once Database A gets used for a bit, it's back to where it...

View INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE may meet your needs.

Returns one row for each column in the current database that has a constraint defined on the column. This information schema view returns information...

You need to determine which program is having the context switchs by using the process explorer utility and then post the results.

http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx

'I got the below warning message for full backup job. " 3/12/2010 12:22:07 AM: Another process might be locking this file The process cannot access the file because it is...

If you have SQL Mail enabled, then the SQL Server Agent alerts can work.

Set up one alert to any error with a severity of 17 or higher.

Alerts for various performance...

You can place the backups file anywhere but to refer by drive letter, the drive must within the SQL Server resource group. You can reference using UNCs in the...

Found this:

SQL Server reports 701: "There is insufficient memory to run this query" when executing large batches

http://support.microsoft.com/kb/2001221

http://support.microsoft.com/kb/2000380

I also recall a SQL Server 2008 "memory leak" condition with linked servers but...

Saw mister.magoo's post after I had already written a reply, so this may be some duplication.

You should check that:

1) The Distributed Transaction Coordinator is running on both servers.

2) OLE DB...

MS has added some "Denial of service attacks" protection (SynAttackProtect setting), which can cause this message. See "Troubleshooting: Connection Forcibly Closed" at http://msdn.microsoft.com/en-us/library/ms187005.aspx

Also see "Avoiding TCP/IP Port Exhaustion" at...

With this message?

Error: 701, Severity: 17,...