Make sure by inspecting the sql server logs thattrace flag 3608 is properly specified and sql server has started in single user mode(message in sql server error log). Sometimes specifying...

Ignore it and just proceed....

MJ

Hi,

Execute the following code prior to database restoration and execute its output once the database is restored:

Orphan login fixation: DECLARE @user SYSNAME

DECLARE @login SYSNAME

DECLARE @sql NVARCHAR(300)

DECLARE cur_Users CURSOR FOR

SELECT su.name,sl.loginname

FROM...

Normally you shldn't shrink database at regular intervals. This will unncessarily consume server resources like CPU, memory in case database grows later.

Shrindatabase statement will lae 10 percent free space in...

Please read about it with workaround on:

http://blogs.msdn.com/sql_protocols/archive/2006/12/02/understanding-kerberos-and-ntlm-authentication-in-sql-server-connections.aspx

HTH

MJ

You need to apply service pack separately to the other new instance. It is instance specific.

MJ

As you are not making use of replication at this moment then backup the database, then restore it using the with move option to place the files in different locations.

HTH

MJ

As per suggestion try the evaluation version of ApexSQL Diff tool.

MJ

To address the problem mentioned by DNA:

Client-side Redirect

In SQL Server 2005, if you connect to a database that is being mirrored with ADO.NET or the SQL Native Client, your application...

Have you tried dropping linked servers using sp_droplinkedserver stored procedure?

MJ

As said configuring and maintaining cluster is more complicated as compared to mirroring.

Benefits to Mirroring over Clustering

Cost (cheaper h/w, licenses)

No HCL requirements

Distance (you can have a server in another country)

Less...

Do you see any change in available memory figure once you change the min server memory figure?

MJ

Do you see any process outside SQL that is consuming memory? Also, have you tried reducing min server memory to a lower limit?

MJ

Refer this link:-

http://technet.microsoft.com/en-us/library/ms190730.aspx

The Windows policy Lock Pages in Memory option is disabled by default. This privilege must be enabled to configure Address Windowing Extensions (AWE). This policy determines which accounts...

Have you gone thru this link:-

http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx

Do let us know in case it works or not.

HTH

MJ