user49352's questions

In a database that is currently being replicated I want to stop the replication (stop the log reader process) for a period of time though I want to continue to take log backups on that same database.

Does the log backup free up the log for reuse or does it remain intact for the log reader task to perform the replication to copy the transactions to the distribution database? All of this assumes that the space for the log is available for the log growth. I am thinking that whatever is remaining in the transaction log that is marked for replication that has not been distributed will not be overwritten but I wanted to verify this.

If so, when I restart the log reader process the transactions are written to the distribution database then the log would then continue to be handled as it was in the past and shrink appropriately.

For SQL Server 2008 what is the maximum number of growths? And which view do I query to find that information for a datafile in my database?

Using a VPN connection I am able to RDP to all of my servers other than the Windows 2012 servers. When on the local network I was successfully able to connect to them.

I saw a post that seemed to fit my situation completely but that indicated that an individual needed to change a setting in his Windows 7 Remote Desktop Connection to 'Connect and don't warn me'. Mine was already set to that.

I also saw posts that appeared to indicate that there may be a role that needed to be set on the Windows 2012 server. Is that correct? If so, could you please give directions so that I could pass them to my server person.

Thanks in advance.

On a Windows Server 2012 I have SQL Server 2012 installed which has the SQL Server Native Client version 11. I am being told by a developer that he needs the SQL Server Native Client version 10.1 (SQLNCLI10.1).

I downloaded a native client sqlncli.msi but received the message 'Installation of SQL Server 2008 Native Client failed because a higher version already exists on the machine...' Is there another download to install or is there a way to copy certain files from a server already containing the desired Native Client and then performing the registration without doing a complete reinstallation?

Any help would be greatly appreciated.

This log reader agent worked perfectly for several months until the user referenced in the error was removed from the domain. After that time the error 'The process could not execute 'sp_replcmds' on 'SERVER'' was received with more detail 'Could not obtain information about Windows NT group/user' that referenced said user.

This user was referenced nowhere in the the log reader agent other than the Publication Access List from which it was subsequenctly removed. The agent would still not successfully start up.

The simple problem here, I believe, is that the log reader agent was created under that user and that no longer exists in the domain. Is there an 'owner' somewhere that needs to be changed?

Every other function on the database continues to execute successfully. Any other help or thought would be appreciated.

The environment is Windows Server 2003 SP2 32-bit, SQL Server 2008 R2 SP1

When logging on to the server the following message box is displayed 'you are attempting to open a file of type 'application extension' (.dll)'. If selected, the module is sqdedev.dll (SQL Setup Enumerator API).

This server was just converted from SQL Server 2000 SP4. The conversion took place without a hitch. The hot fix KB942288-v4 was applied to the server for the installer without a flaw and the upgrade ran rather quickly and the results were exactly as expected with the exception of this message.

Was there a flaw in the conversion or is there a way to fix this? This is a test server so it is not critical but I do not have a snapshot to roll back to.

Windows Server 2003 SP2, SQL Server 2000 SP4 (8.00.2039 - according to Add/Remove programs) but with patch 8.00.2055 applied according to 'select @@version'

When I try to apply the cumulative update 8.00.2187 the 'Instances to update' dialogue box in the wizard does not select anything and does not allow me to select anything. If I select 'next' I am told that I haven't selected anything.

When I installed 8.0.2187 directly to 8.00.2039 on another server there is no problem.

Do I need to remove 8.00.2055 prior to 8.00.2187? If so, how do I do that? Or it there another way to 'force' 8.00.2187 to install?

Windows Server 2003, SQL Server 2005 (9.00.3080)

I installed SS2005 SP4 without a problem and immediately started getting vsJitDebugger 'unhandled win32 exception' messages in the application log every couple of minutes. I changed the DEP to only essential programs (as suggested) but now I get the debugger popup.

I want to get rid of the 'unhandled win32 exception' messages completely as I don't know what caused them. I read in some posts about using ccmclean.exe, that is was a bad uninstall of the client application, and a Management Point issue.

Can someone help me with this? Thanks

My environment is Windows Server Standard 2003 SP2, SQL Server 2000 SP4 with a few additional patches, NetBackup Admin console 7.1 and NetBackup Client 6.5.3.

I take nightly full backups that restore with no problem. I also perform nightly server backups with NetBackup. After a native backup has been backed up with NetBackup to tape and subsequently restored to disk from tape it fails with the 'SQL-DMO(ODBC SQLState: 42000) An internal consistency' error. The RESTORE VERIFYONLY indicates that the backup set is valid. This restore has been attempted on server native backups with no success.

These restores are being done on the server that acted as the source so there is no issue with patch level, etc. between different servers.

Many other types of files have been restored with no apparent problem (Excel, .pst, .SLS).

Any help with this would be appreciated.

The NetBackup strategy currently being used was implemented in March against Virtual Servers on VMWare using the 'flash' methodology.

This error appears only to happen with SQL Server 2000 and .BAK files larger than 2G.

There are a number of good sites with versions and they list 8.00.2283 as downloadable but I can't find it anywhere. I can find other cumulative patches but not 2283.

On Windows Server 2003 I am using a web browser (http://servername/site) to get to a web site on itself (servername) referencing an entry in the hosts.txt file - required for the use of the software. I am receiving the user authentication box ('connect to') box. Verified that the integrated windows authentication is unchecked in the IIS properties.

I can access this web site (http://servername/site) successfully from another Windows Server 2003 and Windows XP with the hosts.txt entry. I can also access a web site (http://servername1/site1) from servername with the servername1 entry in the hosts.txt file.

From this I can see that servername is utilizing the hosts.txt file. For the IP address I tried both the actual address and the loopback (127.0.0.1) address.

I am on Service Pack 2. My CPU is running at 100% with either svchost.exe or services.exe. I know that this was common in XP, server 2000, etc. But now I only seem to find posts for Vista. What is the reason?

Microsoft server 2003.

There is a hidden file but I can't see it even though I have the 'show hidden files and folders' radio button set. I am a domain admin so shouldn't have a problem.

Another user with the same permissions can see it.

What else needs to be set?