Archives

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.

Done

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
Date:9/15/2010
Time: 7:00:19 AM
User:N/A
Computer:ServerName
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 http://support.veritas.com/docs/264616