Browse by Tags

Rename a SQL Server instance, a little catch

Published 14 December 7 4:4 AM | SSQA.net

Can I rename an instance of SQL Server after I have already installed it on the computer? Simple answer is Yes and you can change the name of an instance as long as the server is not clustered. There is a little catch between 2000 and 2005 version, by...

Filed under: sql server, msdn, technet, instance, read, best practices, installation, servers, rename, local

How to read Database transaction log in SQL Server?

Published 27 September 7 7:13 PM | SSQA.net

Another frequently asked questions in the forums and newsgroups, I have seen similar ones recently. I believe most of the newbie users ask this question and even more as interview based questions. So here is the catch in order to accomplish the task,...

Filed under: sql server, ssms, tools, transaction log, dba, read, access, audit, log file, third party, resolution

SQL Server Express installation error: System Configuration Checker Fails with "Performance Monitor Counter Check Failed" Message

Published 13 September 7 10:31 AM | SSQA.net

While installing SQL Server Express 2005 you might have come across the error: System Configuration Checker Fails with "Performance Monitor Counter Check Failed" Message As you have seen that one of the README file for SQL 2005 installation...

Filed under: sql server, security, read, sql express, installation, registry, perflib, everyone

Get backup and restore performance stats with a DMV

Published 12 June 7 8:25 AM | SSQA.net

Normally the backup and restore operation will be quick enough or depends upon the server configuration to complete. Say if you have started with a 2GB size of database and over the time as that database is updated, the amount of data that is included...

Filed under: sql server, stats, performance, restore, backup, dmv, read

Behaviour of SP_READERRORLOG in SQL 2000 and 2005

Published 22 May 7 3:3 AM | SSQA.net

You may be aware that SP_READERRORLOG can be used from a query analyzer or query editor to read the error log contents without opening the file on the disk or from Management Studio (or Enterprise Manager). I'm not sure whether you have observed that...

Filed under: sql server, microsoft, error, read, log, version, BOL, documentation