NO ONE CAN STOP SQL SERVER!!!!!!

Anyone that can stop services (usually admins) can stop the service.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

On the sql server, there is a server network utility that is in the MS SQL Server program group. Check that for the libraries that are running. Client Network Utility...

Has something changed on the server? Is the server all of a sudden taking longer?

Are you running this in QA?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Is the database in EM?

I suspect someone changed something. Be sure the server network utility and client network utility match for access. Also, are these the same box?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best...

Msdb isn't usually an issue. We remove guest here.

master is another story. there are things that are needed. you can default the users to antoher db and remove access from...

The data set may be entirely in memory for both boxes, so I'm not surprised. The boost on the server is when there are lots of people using it, not...

I think there is a resource kit utility to do this, but a quick search on Technet doesn't find it.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Personally I like working with thin clients and a web browser, but then again, that is for simple apps and requires a different mindset. Try to deliver minimal information per...

Can you tell which parts are producing the deadlock? I'd run the proc with a profile running and include the SQL Stmt adn the deadlock events and try to track...

Or the server isn't listening for sockets (check the server network utility).

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Scare me too.

The restore from a network share is the same as another restore, use the UNC path, be sure the SQLAgent has rights to read from the share.

Steve...

ttp://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q263/5/56.asp&NoWebContent=1

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Is this everytime you run a full backup? How are you doing this (EM, code?)

could you have multiple backup jobs scheduled?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

If he has the password and rights in MSDB he should be able to update it.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

If you are trying to "share" the database file between servers, you cannot do this. A server holds the locks on the file and it cannot be shared, even in...