Both those values are registry settings that are used when SQL Server starts up; accessible at HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.InstanceName\MSSQLServer

Values to check AuditLevel (values 0, 1, 2)

- 0 - None

- 1...

During install it is a strange error, do you already have a SQL Instance installed on server? But it sounds like the Shared Memory Protocol is disabled.

Go to ...

-...

1) In a cluster some the files for SQL Server are locked on passive node; so therefore after installing SP3 I usually reboot both nodes before attempting anything else.

2) I...

Starting SP3, Microsoft (finally) fixed the security issue. Even if you are part of BUILTIN\Administrators, you will not be granted SYSADMIN on SQL Server (yeeeh!). So you should...

Another suggestion/question, the connections you don't want to kill, is there a different user list that is accessing these tables? Then you can build list of connections that are...

Yeap, no issues. Of course the second instance will be named instance :). Also you'll need to watch out for memory, cpu and disk i/o etc for running...

my 2 cents...

two questions ..

1) what is the block size on the disk where tempdb is being created?

2) is tempdb sharing the same disk as your data file?

other general comments

unless...

Don't get down bud, first time I did mirroring I was pulling my hairs out also.

It is a strange problem you are getting for two hosts not be to be...

I never used SQL Authentication for Database Mirroring; how are you configuring that? Can you please show the SQL Statement you are executing?

Have you tried to create connection using...

Start endpoints on both servers.

Go to first server, and open telnet connection to 2nd server using the endpoint port. If the connection establishes (aka the telnet window stays open);...

Execute ...

SELECT *

FROM sys.database_mirroring_endpoints;

Check to see if the state_desc is STARTED. If not then execute

ALTER ENDPOINT [EndPointName] STATE = STARTED

I haven't done Mirroring for a while, but you can...

Simple answer to that question is, it depends.

It depends on type of change you are doing, for all changes recommend full db backup for small databases; or roll...

I am going to say no to that, because I have seen database/application that only one database can be on server. Or others where have 200+ databases on server.

There...

Going to throw this out, although the error is not recorded here. When using linked servers in stored procedures or functions the RPC must be enabled on it. ...

DBA in Unit 7 (8/12/2010)

---

We are getting a Windows 2008 CLuster server (active/passive two nodes). and I am planning on install an instance of SQL 2005 and an instance of...