SQL Server

2 May 2011
SQL Server 2005

There are many complicated technical explanations solutions & Guides to resolve this.

But if you are like me and just want to solve the problem & move along. This is what you need to do .

1. backup the transaction logs ONLY

2. Backup the database ( Full ) for safety

3. Shrink the database

4. Shrink the files.


Side Note: If you run a maintenance plan regularly to back up the transaction logs & databases you will not have to learn this the hard way  as I did.

15 Sep 2010

Event Type: Error
Event Source: Backup Exec
Event Category:None
Event ID:57860
Time: 7:00:19 AM
Description: An error occurred while attempting to log in to the following server: “Server name”.  SQL error number: “0011”.  SQL error message: “[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.  

Refer to Symantec Knowledgebase article Document ID: 264616