Now, kindly check the does remote connection is allowed for that server or not ( proposed Monitor Server).

Check that you are mentioning correct server name / instance name with correct...

Hi,

Might be this server is not in the same network.

Try to ping to server and find if it is traceable.

Firstly you have to unistall SQL Server from Add remove programm. Here you have to select the instance which you want to remove. IF you want to remove the shared...

HI,

IT depends on which track you want to follow.

For DBA Track

70-432 ( Implementation and Maintenance of SQL 2008)

For Developer Track

70-433 ( SQL server 2008 - Database Development).

It all upon your...

Hi,

As per my knowledge, You cannot directly upgade From Enterprise Edition to Standard Edition.

Below is the Microsoft link supporting to my words :

http://msdn.microsoft.com/en-us/library/ms143393.aspx

It Says from 2005 Enterprise edition,...

It would be advisable to use Transaction while issuing DML operations on the database.

and Begin transaction should follow with either Commit Transaction or Rollback transaction ( in case of any...

@vijay-2

There are no chances of the data loss provided you take a log backup every time you switch the recovery model ( from Full to Bulk Logged and...

Good. Finally your issue was solved.

Hi,

Check Aliases under SSCM.

if you are running the sql agent under domin account, then check that if you have created Alias in SQL Server Configuration Manager.

If not present then...

You should check the auto close properties of the database.

Auto Close should not be enabled for the database which is used frequently. Because auto close with close the database when...