Archives: March 2012
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 the log for the database “restoretest” has not been backed… Read more
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
Executed as user: xxx\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started:… Read more
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 to will be used(your windows credential).
There is… Read more