Okay. Thank you Gail. I will be looking now on how to do that. I've never done it before so I will be investigating what the steps should...

Part of the name is related to the company except for a portion of it makes no sense. We are getting hit every 1/2 seconds and filling up the...

The ip address that you see in the error message is the sql server ip. That is why it is so difficult to identify.

Oh cool! That's even better.

No, I don't mean that. What I am saying is that I will put the database in offline mode and then kill the .net sqlclient connections to the database...

After posting I found that the application server which has a service running on it to connect to the database server is what is initiating the .net sqlclient connections. ...

Is this the command to bring it back online after the restore:

use master

alter database MyDatabase set online

I agree with you completely. I guess because they are asking fron a database perspective what should be backed up, I thought I would the question.

Yes, I found this (see below) on social.msdn.microsoft.com web and was going to try this. Since we are on a clustered server, the start command didn't work and that...

-dD:\Data\ATS\FLOR\MSSQL.1\MSSQL\DATA\master.mdf;-eD:\Data\ATS\FLOR\MSSQL.1\MSSQL\LOG\ERRORLOG;-lD:\Data\ATS\FLOR\MSSQL.1\MSSQL\DATA\mastlog.ldf -c -T3608

-c -T3608 is what I was adding. It was to allow the the sqlserver to be brought up so I could detach msdb and repair. That...

I was wondering is there a script to automate this? I would like to automate so that I don't have to keep on top of new sql logins.

Thanks.

Patti

Hey all, what the application team decided to do is have me delete all the users except two. One user is an admin type account and the other is...

No they are not all developers. I have queried the application team to determine if all the 50+ users need to been defined and will go from there.

Do have...

I will be calling the database a different name. If I put the test database under a different instance which I was thinking of doing, then I have to...

Thank you. I wasn't sure if SSIS was cluster aware. It wasn't configured that way but you were right, all I had to do was install Integration services...