I worked on an interesting SQL startup problem today. I don’t see this error very often, but since there wasn’t much on the web, I thought I would write it up and post it on my blog. Errorlog 2010-12-27 03:03:31.41 spid2s Warning: unable to allocate 'min server memory' of 13312MB. 2010-12-27 03:11:54.71 spid52 The operating
Read More »
Normally, the Snapshot create publication script only needs to lock the table long enough to generate a Create Table script for the Distribution Agent to apply to the Subscriber. However, the create Publication was being blocked on the Publisher. We discovered a database trigger used to AUDIT all schema modification on the Publisher was root
Read More »
Below is a slight modification to the How to: Initialize a Transactional Subscription from a Backup steps to handle Publisher database backups to multiple BAK FILES. 1) Execute sp_addpublication (Transact-SQL) at the Publisher on the publication database. Specify a value of true for @allow_initialize_from_backup = N’true’ and @immediate_sync = N’true’ 2) Create a backup of
Read More »
Here is another customer question about Replication I thought worth sharing. I am using SQL Server 2008 64 bits. I have to change the location of the data file (i.e. MDF file). I was planning to detach and attach. DB is also using Transactional Replication so I can’t detach the DB. Is there any way
Read More »
We had this question about SQL 2008 virtual cluster. Question: Is it possible to add node in existing SQL Server 2008 or 2008 R2 Failover cluster instance without downtime (without stopping SQL Server or MSCS services)? Answer: Absolutely! SQL Server 2008 was designed with rolling installation and upgrades in mind. To confirm: I built a
Read More »