Script existing server side trace to create a new trace with same definition

I wrote this script today and thought of sharing since it might be useful for you. I wrote it because there is no option to set rollover of a existing server side trace and we have lost the original script which created this server side trace in SQL Server. So idea is to script existing…


Login failed for user ‘sa’ while installing SQL Server 2005

I was working in a SQL Server 2005 setup case which failed while starting SQL Service with error:  SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user ‘sa’. Refer to server error logs and setup logs for more information.   Then…

5

Rule "Same architecture installation" failed while installing SQL Server 2008 R2

Error:   Installating DEFAULT instance of SQL Server 2008 R2 Express Edition with Advanced Services on a Windows 7 64bit with AMD Phenom(tm) II X4 945 Processor failed with error:  —————————  Rule Check Result  —————————  Rule “Same architecture installation” failed.   The CPU architecture of installing feature(s) is different than the instance specified. To continue,…

2

"Wait on the Database Engine recovery handle failed" while installing SQL Server 2008

I worked on a customer service request where SQL Server 2008 Enterprise edition installation was throwing error: Wait on the Database Engine recovery handle failed. After examining SQL Error log from the Setup logs folder, noted: 2010-08-27 17:15:04.51 spid7s      Starting up database ‘mssqlsystemresource’. 2010-08-27 17:15:04.52 spid7s      The resource database build version is 10.00.1600. This is…

7

How to define backup interval for Full, Differential, TLog

Designing an effective SQL Server backup/Restore strategy Designing an affective backup and restore strategy is required to bring database online when you encounter these situations: 1.       Database gets corrupted due to I/O issues 2.       Need to roll back the database to a previous timeframe because of user error 3.       Meet audit compliances 4.       Power failure…


Who is connected when in Single User Mode

Here is how to find out who is connected to your server when you are in single user mode:   METHOD 1: ————- à Start your SQL Server in normal multi-user mode and enable login auditing for both successful and failed logins à Open Management Studio à Right click on server name àProperties àSecurity tab…

2

Welcome to my MSDN Blog

Hello! My name is Sakthivel Chidambaram. I work with SQL Server Product Support team at Microsoft. I’m going talk about some simple SQL stuffs here. Have a great day! Legal Disclaimer: These postings are provided “AS IS” with no warranties, and confers no rights.    Additionally, views expressed herein are my own and not those of…