SecuriData Online Backup for Microsoft SQL 2005 and SQL 2005 Express
- Online Backup Media Presentations
- What is Online Backup
- Online Backup & Firewalls
- Online Backup Data Encryption
- Online Backup e-Notifications
- Restore File System Backups
- Online Backup Installation & Small Business Server2003
- Online Backup Microsoft Exchange Server
- Online Backup for Exchange, Lotus Notes and Novell GroupWise (Brick Level)
- Online Backup for Microsoft SQL Server
- Online Backup for Oracle Database Server
- Online Backup for Netware
- Migrate Service from MSDE to SQL 2005
- Online Backup - Service Account Logon
- Online Backup - Bare Metal Restore
SecuriData Online Backup for Microsoft SQL 2005 and SQL 2005 Express
This article deals with the online backup of Microsoft SQL 2005 and SQL 2005 Express.
Online Backup for Microsoft SQL 2005 and SQL 2005 Express
Troubleshooting / Error Messages
Problem
If you try to backup a remote instance of Microsoft SQL 2005 or SQL Express 2005, it may fail with the following error:
"SQL server does not exist or access denied. ConnectionOpen (Connect( )).SQL:exec xp_msver ProductVersion)"
Reason
The remote SQL Server instance may not be configured for remote connections.
By default, SQL Server Express 2005 is installed (configured) only for local connections.
By default, MS SQL Server 2005 is installed (configured) for remote connections, but this might have been changed.
Workaround
Use the SQL 2005 "Surface Area Configuration for Services and Connections" tool:
1. Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration > Surface Area Configuration for Services and Connections.
2. Browse the Instance tree for Database Engine > Remote Connections. Select “Local and remote connections” and “Using TCP/IP and named pipes”.
3. Start SQL Browser service on the remote server.
Note: This does not apply to local SQL Server instances (residing on the SecuriData Online Backup host machine).
-----------------------------------------
Problem
64-bit Windows SecuriData Online Backup Service fails to create a new MS SQL Server backup set (in New Backup Set Wizard) with the following popup error:
"Runtime Error!
Program: c:\program files\Data Storage\DS-Client\dsclient.exe
R6034
An application has made an attempt to load the C runtime library incorrectly.
Please contact the application's support team for more information."
Reason
This is a Microsoft Bug with MS SQL Server 2005.
The 64-bit MS SQL Server 2005 release (prior to Service Pack 1) has a problem with native 64-bit applications that use SQL-DMO (SQL Distributed Management Objects).
Solution
The MS SQL Server 2005 minimum requirement for SecuriData’s Online Backup Service is Service Pack 1.
Use 64-bit MS SQL Server 2005 Service Pack 1 for the SecuriData online backup service database