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…

0

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…

0

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…

0