Troubleshooting SQL Server error “The operating system returned error 1453”

Troubleshooting SQL Server error “The operating system returned error 1453” Chris Skorlinski Microsoft SQL Server Escalation Services 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…

2

Lock Timeout in Replication Create Publication

Lock Timeout in Replication Create Publication Chris Skorlinski Microsoft SQL Server Escalation Services 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…

0

How to: Initialize a Transactional Subscription from a Backup with Multiple Backup Files

How to: Initialize a Transactional Subscription from a Backup with Multiple Backup Files Chris Skorlinski Microsoft SQL Server Escalation Services 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…

2

How to move MDF/NDF for a Replicated Database

How to move MDF/NDF for a Replicated Database Chris Skorlinski Microsoft SQL Server Escalation Services 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…

3

Adding node to SQL 2008 cluster does not require SQL restart.

Adding node to SQL 2008 cluster does not require SQL restart. Chris Skorlinski SQL Server Escalation Services 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!…

0

Unexplained Latency in the Distribution Agent using Named Pipe

Unexplained Latency in the Distribution Agent using Named Pipe Chris Skorlinski Microsoft SQL Server Escalation Services. Just wanted to give a heads up about a SQL Replication Distribution Agent Latency problem we observed today.  The Distribution Agent to 1 subscriber was only delivering about 500 cmds/sec while other subscribers were getting 4000 cmds/sec.  We noticed…

0

Welcome to Camp GeekaLot for SQL DBAs

  Welcome to Camp GeekaLot Camp for SQL DBAs to Share Tips and Practices Chris Skorlinski Microsoft SQL Server Escalation Services I recently hosted a SQL DBA best practices discussion with the Charlotte SQL Server Users Group.  It was a lot of fun to exchange DBA best practices and have a little fun along the…

1

ORA-01830: date format picture ends before converting entire input string

ORA-01830: date format picture ends before converting entire input string Chris Skorlinski Microsoft SQL Server Escalation Services Microsoft SQL Server has the ability to REPLICATE data changes to Oracle.  We see more and more customers migrating to SQL Server, then setting up SQL data Replication to move change SQL data back to a legacy Oracle…

0

How to cleanup Replication Bits

How to cleanup Replication Bits Chris Skorlinski Microsoft SQL Server Escalation Services For SQL 2005 and SQL 2008 the sp_removedbreplication stored procedure works great for removing the SQL Replication bits from a database.  SQL 2000 has an older version of this SP which doesn’t always cleanup the database.  You can use the following steps in…

3

Unexplained slowness in SQL 2008 on Windows 2008 R2

Chris Skorlinski Microsoft SQL Server Escalation Services A customer called today about an unexplained slowness in SQL Server 2008 on Windows 2008 R2.  All SQL data looked great, no blocking, no obvious IO bottlenecks, just overall slow performance. 976700  An application stops responding, experiences low performance, or experiences high privileged CPU usage if many large…

0