Fast Guide: Solving SQL Server errors

Backup and restore errors

• Error restoring a database from production to a disaster recovery server
• Database restore error in vb.net code
• Getting failed Windows server back after boot device error
• Backup error when dropping, inserting into or truncating a table
• Error caused by corrupt block on disk

Connection errors

• Sqldriverconnect error
• Error with pull subscription connection from a remote server
• Error connecting to Web-based application
• Max connections-reached error
• Error with SQL Server driver: Shared memory; connection open
• Error when trying to connect IIS and SQL Server
• Errors when submitting data from Web

Conversion errors

• Getting type mismatch error converting string to date
• Error converting varchar to numeric
• Error converting Sybase data to SQL Server
• Error converting char to datetime

Copy and clone errors

• Error trying to copy new DLL over old one
• Error 21002 cloning SQL Server 7 database solution

Installation and upgrade errors

• Installing SQL Server 2000 on Windows XP
• Problems trying to install SQL Server on a two-node cluster on SAN

Log file errors

• Error about full tempdb log file
• Handling a transaction log full error in T-SQL
• Attaching a database that has missing log file

Login and access errors

• Login fails for user 'myservernameaspnet'
• Mismatched permissions errors after moving SQL Server
• Operating system error when creating or opening a physical device
• Problem trying to connect with the sa account
• Login errors caused by memory problems
• Can't log in with 'sa' and 'password'
• Error running a stored procedure that references a remote server
• Query works fine in Query Analyzer, but error via ASP

Replication errors

• Error setting up replication across network domains
• Error replicating data from Internet server to dial-up SQL server
• Replication error between two standalone servers with same local and sa accounts
• Error in "Not for replication" database
• Error trying to drop linked servers

SQL errors

• Maximum group value creating SQL syntax error
• SQL statement error when trying to retrieve a DB2 date in Julian format
• SQL syntax error when making a selection on boolean
• Subquery error for select statement in DB2

Table errors

• Missing keyword error when using ON DELETE and ON UPDATE on same table
• Problem creating trigger to update reservations table
• Foreign key must reference a unique key

More error-related resources rom SearchSQLServer.com

• Ask the Experts: Don't see your error on this list? Ask our experts for help.
• Tip: Using 'error handling' in stored procedures
• Tip: Renaming foreign keys