Welcome to SSQA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.

Thursday, May 24, 2007 - Posts

Recover from a corrupted transaction log file - on test server only
Say one fine morning you had a call stating one of the databases have lost the transaction log file due to a hardwrare issue (for discussion sake). Then the recovery option is to restore from the latest backup, that is a best practice too. In case if Read More...
Posted: Thursday, May 24, 2007 7:00 AM by SQL Master | 0 Comments
Filed under: , ,
SQL Server transaction log, SHRINK - to be or not to be?
You have a production database which has a very high growth rate. As a result the database transaction log gets full resulting a daily scheduled job to shrink. All the times this is affecting the performance on SQL Server, what is the best option to shrink Read More...
Posted: Thursday, May 24, 2007 6:42 AM by SQL Master | 1 Comments
Filed under: , ,
xp_cmdshell: a call to 'CreateProcess' failed with error code: '5'
Problem: SQL Server 2005 error: xp_cmdshell: a call to 'CreateProcess' failed with error code: '5'. We get above error when trying to execute XP_CMDSHELL even though it has been enabled using Surface Area Configuration tool and the login has SYSADMIN Read More...
Posted: Thursday, May 24, 2007 6:05 AM by SQL Master | 1 Comments
Filed under: , , , ,