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

Do not use the "Backup Database across one or more file" no no

Select the databases you require trans log for:

check the radio button for "Create a Backup File for every...

http://technet.microsoft.com/en-us/library/cc730992(WS.10).aspx

sorry, I meant was the policy regarding the disk space threshold. it is 20% for our environment and with this particular box is jagged up so nicely, that the disk...

Without a Witness --------

In this case, nothing happens to the Principal server and it keep on running.

But if the Principal server goes down the mirroring is suspended and requires manual...

Yes Large files are not a issue. but sometimes the policies across departments, lead us into a tight position.

Thanks

window event viewer / SQL Error Log /SQL Trace and that is as far as we can look into.

Was this database associated with any jobs.

I suppose this database was...

I had this script around.

sp_msforeachdb @command1 = 'USE [?];

DECLARE @top int

DECLARE @include_system_tables bit

SET @top= 5

SET @include_system_tables = 0

BEGIN

IF @top > 0

SET ROWCOUNT @top

--INSERT INTO master.dbo.GetbiggestTables (DatabaseName,Table_name,Row_Count,TableSpace_MB,TableCreateDate)

SELECT cast(db_name()...

Try Copying the File to another Location and then open the File. Or Do not copy the current File, else copy everything to diff location and try to open the...

Do you have a baseline, you can compare against.

Do you have a list of your Database changes.

check the Default trace for answers, if it is not too late... they are...

Grant Fritchey (4/30/2010)

---

I agree with Brandie.

I will add this though, if your index was truly covering, and the one used by the execution plan, you shouldn't get a key lookup....

It Happens usually with orphaned logins.

Try this:

use databasename

sp_change_users_login 'report'

and check to see if the result of this statement is the login in question.

you can correct it as follows:

sp_change_users_login...

you can even do something like this:

SELECT 'GRANT SELECT ON '+quotename(table_name)+' to '+'Maninder' FROM Information_Schema.Tables

WHERE Table_Type='BASE TABLE'

If you are using to connect locally to the database server then shared memory comes into play.

If you are trying to connect to a remote SQl server installation using your...

Is the Remote SQL Server version 2000? If it is , this is what usually happens (exceptions).

When i connect to SQL 2000 SP3 Boxes, they are Blank(white), but when...