Welcome to MSDN Blogs Sign in | Join | Help

February 2009 - Posts

Thursday, February 26, 2009 6:09 AM

You encounter error message "The system cannot find the file specified" when attempting to perform backups using sqlvdi

Symptoms you encounter: SQL Server 2000 SP4 x86 is installed on a Windows 2003 X64 server. You use x64 backup applications to perform backups of databases. These backup applications use sqlvdi to interact with the SQL Server. You installed the sqlvdi.dll
Posted by psssql | 1 Comments
Tuesday, February 24, 2009 8:01 PM

SQL Server 2005 and 2008 Setup Failures (Compressed DATA Directory)

We are always looking at customer issue reports in order to improve our software and your experience.   The SQL Server Setup development team has identified numerous Watson reports of failed setups due to the compression state of the DATA directory.
Posted by psssql | 5 Comments
Filed under: , ,
Monday, February 23, 2009 3:37 PM

How It Works: Resource Governor 'INTERNAL' Group

From: Customer Sent: Friday, February 20, 2009 2:04 PM I have seen sometimes a user connection classified as Internal when I run the following query:   USE master ; SELECT sess . session_id , cast ( sess . login_name as varchar ( 40 )) login_name
Posted by psssql | 1 Comments
Filed under: ,
Friday, February 20, 2009 5:41 PM

SQL Server 2005 or 2008 Reporting Error 17883 - Stalled Scheduler Warnings

SQL Server 2005 introduced a background worker to flush trace event streams.   The trace buffer is flushed when it becomes fully populated but a partially populated trace buffer remains in-memory until events fill the buffer or the background
Posted by psssql | 1 Comments
Friday, February 20, 2009 3:36 PM

SQL Server: Is CHECKDB A Necessity?

From: SQL Server Customer Sent: Friday, February 20, 2009 5:08 AM   I’m often asked by professionals whether CheckDB is still recommended on SQL2k8.  SQL is calculating a checksum to avoid physical page corruption since 2k5. However in
Posted by psssql | 1 Comments
Thursday, February 19, 2009 12:56 AM

How to copy DTS 2000 packages between servers (and from SQL 2000 to SQL 2005 and SQL 2008)

I was posed the question today, how do I migrate my SQL Server 2000 DTS packages to a SQL 2005 Server without upgrading them, thus leaving them as legacy DTS 2000 packages within SQL 2005? In other words, how do I copy or move DTS 2000 packages into SQL
Posted by psssql | 2 Comments
Filed under: , , , , ,
Friday, February 13, 2009 4:16 PM

Searching for Duplicate SPN's got a little easier

We get a lot of calls related to Kerberos configuration, and I'm planning to write more about our experiences and troubleshooting techniques for these types of issues across the box (Engine, AS and RS). With Windows 2000/2003 SetSPN had only a few commands
Posted by psssql | 2 Comments
Wednesday, February 11, 2009 7:52 PM

How It Works: File Stream Compression with Backup/Restore

The question of file stream compression during backup and restore arose last week and makes for a good clarification topic. Shown here is a conceptual layout of a database containing file stream containers.    On the left the folders represent
Posted by psssql | 2 Comments
Wednesday, February 11, 2009 6:58 PM

PRB: RML Utilities - ReadTrace processing fails with "Attempt to use an invalid variant type"

Summary ReadTrace processing may unexpectedly fail with the following error: A serious error condition (true == pVariant->FIsUnknownType()) has been encountered.                
Posted by psssql | 1 Comments
Filed under: ,
Wednesday, February 11, 2009 2:49 PM

RML Utilities: Recommended SQL Server 2008 updates for ReadTrace processing

There have been a couple of SQL Server 2008 fixes shipped in recent Cumulative Updates, that address issues you may encounter during ReadTrace processing and .RML generation, or OStress replay.  Here are the updates we recommend if you use SQL Server
Posted by psssql | 1 Comments
Tuesday, February 10, 2009 8:37 AM

How to troubleshoot leaked SqlConnection Objects (.NET 2.0) - Part 2

In the last post in this series, we looked at how we can determine that our Connection pool was exhausted. In this post I'm going to go a little deeper into the Internal connection itself and how we can verify if this is a closed or active connection.
Posted by psssql | 0 Comments
Monday, February 09, 2009 5:22 PM

SQLIOSim: Default Testing Pattern

The SQLIOSim knowledge base article outlines the various configuration files in detail.  http://support.microsoft.com/kb/231619 - How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem. I still get inquires about what
Posted by psssql | 1 Comments
Thursday, February 05, 2009 8:54 PM

How to troubleshoot leaked SqlConnection objects (.NET 2.0) - Part 1

One of my colleagues, Kamil Sykora, compiled a document that goes through how to troubleshoot leaked SqlConnection objects (from a .NET 2.0 perspective).  It was a fairly large document, so I’m not going to post the whole thing.  I’m
Posted by psssql | 3 Comments
Monday, February 02, 2009 2:37 PM

Why aren't my subscriptions working?

I ran across an interesting issue the other day with subscriptions not firing.  I had never ran across this before, but once I was done it made sense.  It was also a good exercise of walking through how subscriptions work.  This may be
Posted by psssql | 1 Comments
 
Page view tracker