1. Is it a named instance and Is the Browser Service running on the server ?

2. Or Are you specifying the Port number when connecting to the SQL Server instance...

If the .mdf and .ldf files are available for the date in question (Through Wndows or System backup), then they can be used to recover the lost data.

...

This could most probably due to

1. SQL Server service is stoped on the server you are trying to connect or

2. It is using Dedicated (Static) ports

...

You can block the IP address uisng the Firewall not explicitly by the SQL Server.

Please check the following link

http://blogs.msdn.com/b/sql_protocols/archive/2006/04/10/572605.aspx

...

You can Use

1. Activity Monitor

2. SQL Server Profiler

Thank You,

Best Regards,

SQLBuddy

I don't think that is correct.

What is the error message that you are getting ?

...

Please check if this helps

http://consultingblogs.emc.com/jamiethomson/archive/2007/02/09/SQL-Server-2005_3A00_-View-all-permissions--_2800_2_2900_.aspx

http://www.builderau.com.au/program/sqlserver/soa/Reviewing-SQL-Server-Permissions/0,339028455,339293054,00.htm

Thank You,

Best...

Hi Ravi,

...

As Steve and Grant mentioned, use a domain account for the SQL Server service and then provide Network drive access for this account and then provide the UNC path of...

I think you can do this ..

Existing Server ----------> Server A

Switched to VM -----------> Server B (This name should be unique)

Shut down old Server A

Rename Server B to...

Reorg the Indexes if the Fragmentation level is > 5% and <30%

Rebuild the Indexes if the Fragmentation level is > 30%

It's better to do reorg on Nightly basis and Rebuild...

Also you can use the filegroup backups to reduce the amount of backup time.

...

Hi George,

Please check the following Links

http://technet.microsoft.com/en-us/library/ms189329%28SQL.90%29.aspx

http://www.microsoft.com/sqlserver/2005/en/us/enterprise-compare-editions.aspx

http://www.sqlservercentral.com/articles/News/comparisonofsqlserver2005editions/1768/

...

If Server Name changed

from Server B to ServerA.

To reflect the name change inside the SQL Server

instance, you need to run the script below:

1. EXEC sp_dropserver ‘ServerB’, ‘droplogins’;

2. EXEC sp_addserver...

Hi George,

Could you check that with the MAXDOP hint ?

Check the following "Parallel...