I have been doing research into various high availability options for SQL Server 2005. With regard to high availability, what circumstances would favor clustering over mirroring as an option? From what I can tell, mirroring has numerous advantages including not having the single point of failure storage equipment, no expensive clustering hardware to buy, and faster automatic failover assuming you have a witness server. The only situation I can think of that favors clustering is [...]

At my place of employment we have been thinking about upgrading from SQL Server 2000 to the latest (2008). We know that the DTS packages will have to be dealt with since the newer server software no longer supports them. Has anyone done this transition before and how easy is it? Are there any snags you ran into that we should be aware of? Make sure you run upgrade advisor. There were a lot of [...]

Scenario: We want to use SQL Server 2005 Standard’s version of DB mirroring along with a witness server in an Active Directory domain environment. The database is fed from a 3rd party app server that cannot be modified apart from the DB connection string. Two questions related to this: How can we make the failure somewhat invisible (or at least, require less manual work) to our 3rd party app server spending as little money as [...]

when installing SQL Server 2005, I get this error. Can anyone tell me how to sort this out? Thanks, Optician Performance Monitor Counter Requirement (Error) Messages Performance Monitor Counter Requirement The System Configuration Check for Performance Monitor counter registry value has failed. For details, see How to: Increment the Counter Registry Key for Setup in SQL Server 2005, in the readme file or in SQL Server Books Online. This solution addresses (from here) your problem: [...]

My company has a VPS with a webhost that serves a few websites. I would like to set up an automated backup that will cover as much of the system as possible. Server Info: VPS is running in Microsoft Virtual Server Enterprise Edition Windows Server 2003 Web Edition (32 bit) Microsoft SQL Server 2005 Express Backup Sources: Individual website web root folders Databases for each site (if needed) IIS settings Other misc. files (not OS [...]

I want to add an AD security group to my MS SQL 2005, which will contain the personal allowed to fully manage all aspects of the server. I have created the group (DOMAINSQL Admins) and added it to the Security -> Logins list, on the server. Yet, a user, member of that group, can’t connected. It gets: Error number 18456, Severity 14, State 1 I have granted everything available on the Logins list. I have [...]

I have a shared hosted SQL Server 2005 at an ISP, that I can connect to from SQL Server 2005 Management Studio. However, I cannot connect from SQL Server 2008 Management Studio. I log on with SQL Server authentication (username+password). When I connect, I get the error: The server principal “MyUserName” is not able to access the database [name of first database on server - 00_something - not mine] under the current security context. How [...]

On a machine that is running IIS 6.0 and SQL Server 2005, where are the different locations that can limit the max number of database connections? If by “number of connections” you mean the size of the connection pool, then this applies: A connection pool is created for each unique connection string. When a pool is created, multiple connection objects are created and added to the pool so that the minimum pool size requirement is [...]

I have a database in full recovery model. This database’s transaction log backups (scheduled via a Maintenance Plan) fail nightly. Here is the database’s CREATE statement, etc: USE [master] GO /****** Object: Database [Gatekeeper] Script Date: 05/18/2009 15:31:26 ******/ CREATE DATABASE [Gatekeeper] ON PRIMARY ( NAME = N’Gatekeeper_dat’, FILENAME = N’F:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAGatekeeper.mdf’ , SIZE = 20480KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N’Gatekeeper_log’, FILENAME = N’E:Program [...]

Is there a way to schedule a job on Windows Server 2003 [small business edition] that will create a backup of a SQL 2005 Express DB? I’m not sure if there is a native job/process for this on SQL Express or not. If there is not, how would I go about creating one? I use expressmaint – works like a champ Check more discussion of this question. Bookmark on Delicious Digg this post Recommend on [...]