Our cluster has these dependancies, but you still need to wait for the master to recover before you can access any of the other databases, and then you have to...

...Wait

You also need to wait for the databases to recover, after a restart. Transactions may need to be recovered/completed. I've had to wait upwards of 10 minutes for...

step by step instructions:

http://msdn.microsoft.com/en-us/library/ms179530(SQL.90).aspx

This database doesn't have any "lookup" tables? It's all user data?

Either above suggestion would work, as long as you don't have "lookup" table data, then you'll need to customize...

I was thinking more along the lines of disaster recovery, and not just testing the restore part of DR. The poster mentioned how the applications would connect after a...

I believe you cannot have two servers with the same name connected to a network. I don't think DNS allows that.

For testing you would need both servers up, in...

There are articles all over the internet on this. It's easy to test and play with on a test server. Essentially you're vunerable to sql injection if you...

We seem to have a major issue with BULK_INSERT after the SP3 install without any CU. We will be putting a support call in to MS.

Our bulk loads used...

Your topic is "I have mdf and ldf files how to restore these 2 files in sqlserver 2000", but it's posted in SQL 2005 Backup section.

Are you trying to restore...

I've converted from Oracle to MS SQL. When it comes to the sprocs and triggers; it's just hard work. There is no easy way around it. Like...

Tanya, I don't recall the version of SQL Prompt I was running. It was at least a year ago. I was using the version that I "won" from...

SQL Prompt has too much overhead. The 2008 Intellisense seems much faster and less intrusive. Maybe I didn't use SQL Prompt long enough, but it was too annoying...

To check the connection settings.

Server Properties==Connections

The other applications may not be noticing because they are connecting/disconnecting and not maintaining a connection. I'm just throwing out a potential theory. ...

Connection timeout settings?

This can be configured with the SQL Server instance and also with the application connection.

Why would you want an application to keep a connection open for an...

ALIAS

If your using alias' on the server, make sure you create them under both the 32-bit and 64-bit (SQL Native Client Configuration) in the configuration manager.