Monthly Archives: March 2012

Restore fails with tail of log error

For sql server 2005 and above, When you take a full backup of the FULL recovered database and try to restore earlier backup it may fail with following error Msg 3159, Level 16, State 1, Line 1 The tail of … Continue reading

Posted in Backup and Restore, Transaction Log, Troubleshooting | Tagged , | Leave a comment

Error 0xC0014062: Unable to complete login process due to delay in opening server connection

Sometimes on a heavy loaded server(many databases/connection). You may get an error log when your backup maintenance plan job gets fails with the following error Message: Executed as user: xxx\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 64-bit  … Continue reading

Posted in Bug, Limitation | Tagged , , | Leave a comment

Command Prompt connectivity –U option

When you try to connect to sql server using isql/osql or sqlcmd there are two authentication you can use windows authentication and sql authentication. -E option is used for windows authentication where you domain windows login which you have connected … Continue reading

Posted in Basic, Limitation | Tagged , , | Leave a comment