Recent content by flstffatboy

I was wondering what potential issues we may face with upgrading our current SQL Server environment. We were hoping to do an in place upgrade. I'm concerned since our version and licensing will change. Currently we have SQL Server 2000 Enterprise edition with CAL based licensing on an active...

bborissov, That worked perfectly. Thank you very much. FLSTF

Hello, I'm getting the following error when running this code within a SQL Server 2000 job. There code runs fine within query analyzer. Could anyone shed any light on this? Error - "Syntax error converting datetime from character string. [SQLSTATE 22007] (Error 241). The step failed." Code...

mrdenny, I went ahead and Disabled publishing and subscriptions after I ran the sp_repldone and then the active portion of the log file disappeared. I think it worked even though I received the message in the previous response I had. I have just successfully truncated the log and everything...

mrdenny, Just tried your suggestion and receive the following message when running sp_repldone Server: Msg 18752, Level 16, State 1, Procedure sp_repldone, Line 1 Another log reader is replicating the database. Not sure why it would think another log reader is replication this database. It...

When I run the backup log with truncate_only I get the following message: The log was not truncated because records at the beginning of the log are pending replication. Ensure the Log Reader Agent is running or use sp_repldone to mark transactions as distributed. When I run sp_repldone I...

Ovatvvon, When you say does this use DTS are you refering to the backup and restore from production to our test environment OR if we have ever used DTS period on the database? The backup to retore does not use DTS but I have used DTS before in conjunction with the database for other tasks. I...

This particular database should not have replication running on it. It was created from a full backup from our production database which had replication running on it and restored to our test instance. I have backed up production and restored to our test database over 100 times whithout ever...

This gives me the message that the command completed successfully. Still unable to shrink the log though. Thanks, FLSTF

Ovatvvon, Understood. I wasn't using the GUI and I looked up the syntax in BOL and could not find a WITH option under the CREATE DATABSE statement for SQL Server 2000. I even tried the following which returned an invalid statement. CREATE DATABASE preproddb ON PRIMARY (FILENAME = 'H:\Program...

mrdenny, I do not see any option on the create database statement with the attach_rebuild_log option. I'm running SQL Server 2000. I did however see a Create Database with a FOR ATTACH option. I tried this and received the same error I did when I tried to do a attach or attach_single_file...

mrdenny, Yes both the L drive and the path to the DATA folder exist. I'm trying to do the detach/attach in the current path the log files already exist in. I have only renamed the existing log files in the L drive of the DATA folder after doing the detach but prior to attaching. FLSTF

mrdenny, Thanks for your reply. I should have noted yesterday that I tried that as well. Below is the exact steps I used when using the sp_attach_single_file_db 1. Detach the database EXEC sp_detach_db 'preproddb', 'true' 2. Rename the log files associated to the preproddb database. 3...

Hello all, I have a SQL Server 2000 test database which is a backup and restored copy from our production database. The production database has transactional replication running on it but the test database does not. I'm having issues with trying to shrink the transaction log for the test...

Thanks Paul.