SQLServerCentral / Backups / SQL Server 7,2000

Backup of SQL2K db to network pc

sathyguy — Fri, 17 May 2013 22:57:40 GMT

Friends,OS: windows 2003 sp1DB: sql server 2000 sp3the sql server is installed in C: drive.Now the C: drive is full (sometimes it going to 0bytes but currently 3 mb free). i cannot reduce any space in c: drive. So that backup is also not working.Now i would like to take a backup in the network pc.Can i take a backup of the db while the users are connected to the database?Now our users(15 users) are all connected to the database and they are working.if i take a backup, will it cause any problem to the server or will there be any disconnection during this backup.and moreover, what is the best way to get this data to a new server. now we have a new server without this database. only sql server 2000 is installed.thanks and waiting for somebody's help.

Backup Log cannot be performed because there is no current database backup

mqbk — Fri, 05 Apr 2013 08:48:09 GMT

I have a job that runs every two hours starting at 7 AM and ending at 5 to back up my transaction logs. The issues is for some reason it fails, but when you look at the even log it looks like every "user database" log file was created successfully, but it has a huge red x next to it. I then selected Log to table from the advanced options of the job just to see if I could find more information, and there it was my log file couldn't be backed up because there is no current database. I checked to see if the database was in simple mode, and it isn't. It's in full mode. I re-ran a full back up of the database it when off with out a hitch, but when I started the transaction log job again, it fails at the same spot. I did notice that the database has two log files attached to it. I am not sure what I am missing. Can anyone help?BACKUP LOG successfully processed 40 pages in 0.031 seconds (10.372 MB/sec). [SQLSTATE 01000]Processed 0 pages for database <Database name>, file <Database_Log 1>on file 1. [SQLSTATE 01000]Processed 76 pages for database <Database name>, file <Database_log 2> on file 1. [SQLSTATE 01000]BACKUP LOG successfully processed 76 pages in 0.055 seconds (11.245 MB/sec). [SQLSTATE 01000]Msg 4214, Sev 16, State 1, Line 1 : BACKUP LOG cannot be performed because there is no current database backup. [SQLSTATE 42000]Msg 3013, Sev 16, State 1, Line 1 : BACKUP LOG is terminating abnormally. [SQLSTATE 42000]

Best backup compression tools

Mh-397891 — Wed, 20 Feb 2008 13:54:29 GMT

We are planning to buy backup compression tool, please suggest which one will be good. Thanks!!

SQL backup with Block-Level technology

jwallace-613855 — Mon, 21 Jan 2008 07:13:50 GMT

Hi,I am running Block-Level Backup software on all my servers. The backup software provider recommends putting my SQL Server Databases in Simple recovery mode. I am not sure whether this is a good idea. I can not find any documentation regarding block-level backup technology and SQL Server recovery models. The backup software does not provide an agent to truncate the logs so I would need to run a log truncate script. I tried the truncate only command but I receive an know error since I am in Full Recovery mode. Can anyone give me any direction on this.Thanks,Jeff

msg 601: Could not continue scan with NOLOCK due to Data movement‎

christy.umoren — Fri, 15 Feb 2013 07:59:51 GMT

SCENARIO 1 Hi, i'm getting the error msg 601: Could not continue scan with NOLOCK due to Data movement‎ - from a job scheduled to run. This is how the error comes about;I have two sql servers, (both 2000) lets say A and B. server A is my production server while server B is my standby server. I scheduled a database and log backup on server A in which the destination for the backup files are on server B where its to be recovery (sort of like the log shipping we have in sql 2008).Now I have two jobs( say job1 and job2) scheduled on server A. Job1 is a procedure which is to perform a full backup and then a log backups to server B. Job2 is a procedure that is to recovery(restore) the backups from server B onto the standby server B in the order they were backed up.Pls note that job2 will also fail if job1 fail because there are no backup files for job2 to recovery.One day i noticed job1 had been failing causing job2 to also fail. On checking the job history and log files i saw that full backup will complete but log backup will fail with the above error causing the the job to fail...I have no NOLOCK statement in my procedureI have upgraded my service pack to SP4 because i was told its a service pack issue but still nothingI have ran DBCCC CHECKDB and no error was displayedSCENARIO 2 This scenario is exactly like Scenario 1, the only difference is that i get the above error when recovery of the 'log files' is being performed on server B (that means full database recovery is successful but log recovery fails) . So in the case, job1 is fine but job2 is failing.Pls can anyone help??!

How to take backup & restore for one table?

sharma-691993 — Thu, 12 Jun 2008 10:04:15 GMT

How to take backup & restore for one table?

SQL Express Backup

kgrady — Tue, 02 Nov 2010 07:05:24 GMT

I'm new to SQL and we have an SQLExpress database that we need to backup on a nightly basis. Is there a backup process with SQLExpress or will the Windows Server Backup process include the database if we point it to SQL location..?? Thank you..!!

BACKUP LOG cannot be performed ...

Michael Gerholdt — Tue, 19 Apr 2011 21:06:05 GMT

I am using SQL Server 2008 Express on a web server. Since SSIS and maintenance plans aren't available, I wrote a sproc, an sqlcmd file, and a bat file ... end result I have only one set of files and can pass parameter in. So I execute batch file from Task Scheduler passing in "Log" or "Database" or "Differential."It works fine, quite nicely.12.30 AM Full 3:30 AM Log 6:30 AM Diff 9:30 AM Log12:30 PM Diff 3:30 PM Log 6:30 PM Diff 9:30 PM LogEverything goes fine until the 9:30 PM Log backup, when for all User databases it failes with this in the audit log:BACKUP LOG cannot be performed because there is no current database backup.All the previous log backups succeed, and I'm just doing another Diff backup in between this Log backup at 9:30 pm and the previous one at 3:30 pm. What could be severing the sense of belonging to a media set or being aware of the Full backup taken at 12.30 AM?What would I look at to find out?Thanks for any ideas!

Transactional and Database Backups failing

forceman29 — Thu, 03 Jan 2013 11:49:41 GMT

Hey Guys, After doing as much research as I can online I'm currently stuck. Plus my knowledge of sql 2000 is smaller then a grain of salt. Just recently I have started to receive this error from our sql 2000 box. JOB RUN: 'Transaction Log Backup Job for DB Maintenance Plan 'DataConnect'' was run on 1/3/2013 at 11:35:00 AMDURATION: 0 hours, 28 minutes, 40 secondsSTATUS: FailedMESSAGES: The job failed. The Job was invoked by Schedule 40 (Schedule 1). The last step to run was step 1 (Step 1).I look at the history and the log file and this is what I find: MessageExecuted as user: SVAMAIN\sqlservice. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.I then go to the SQL Server logs and view the current log. At the same time when I received the email that the job failed I am able to find this: Source: spid69 BackupDiskFile::RequestDurableMedia: failure on backup device \\xxxxx. Operating system error 64(The specified network name is no longer available.).When I go to the location of where the backup file is there are transactional logs there (whether they are complete or not is another question but data was written to the network locations). Things have been going fine until today. Nothing on the network has changed. A few months back I had to move the backups from our SAN to our NAS due to storage issues, migrations, etc. The hop count hasn't changed and it's the same millsecond response time when doing a ping and tracert. From all the research I can see is that SQL 2000 really doesn't like it when the network connection get's congested and slows down. Instead of continuing to keep running it fails the job. Is there a way to force the Maintenance plan to keep going regardless of network congestion or slow response times from the destination NIC? Thank you for any help that you can provide :)

Transaction log back and point in time recovery

MSSQL_NOOB — Mon, 31 Dec 2012 08:17:25 GMT

SQL Server 2000 - Full database back up at 9:00pm; transaction log backup at 12:00pm. Internal database, therefore, database use normally from 7:00am - 9:00pm.Question 1) If backup mode is full; why doesn't it backup the transaction log and truncates / cleans it? Question 2) Transaction log is getting big at 8:00am - before the transaction log gets full, what is the best course of action and at what time and still be able to restore to point in time if anything happens to database? I was reading about [url=http://blog.sqlauthority.com/2006/12/30/sql-server-shrinking-truncate-log-file-log-full/]log shrinking[/url] but Question 3) do not understand reason for the double DBCC SHRINKFILEQuestion 4) What is, if any the implications it'll have on point in time recovery if I do DBCC SHRINKFILEThanks

Backup to desktop

MSSQL_NOOB — Thu, 20 Dec 2012 12:47:41 GMT

Connecting to MSSQL2000 (on a server somewhere) from SSMS2008 client on my desktop. I did a right click, Tasks and Backup... on one of the database. From there, I generate a script for the backup in SQL. Say, the following is the script.BACKUP DATABASE [DEVDB] TO DISK = N'[b]\\different_server_name\DEVDB\bkup\DEVDB_20121220_120038.bak[/b]' WITH NOFORMAT, NOINIT, NAME = N'UploadDownloadDev-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10GOMy question is can I change the script to backup to my local C drive:BACKUP DATABASE [DEVDB] TO DISK = N'[b]C:\BACKUP\DEVDB_20121220_120038.bak[/b]' WITH NOFORMAT, NOINIT, NAME = N'DevDB-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10GORun it from SSMS2008 client on my machine. Copy the backup home, restore it and have access to the data? If so, isn't that kinda dangerous? How do I prevent that from happening?

not part of a multiple family media set.

Bill Beadenkopf — Fri, 12 May 2006 07:12:00 GMT

Because we have not had a good backup for a few days, I am trying to do a backup to disk right now, outside of the schedule. I want to create a new file, but I get an error message saying that my file is "not part of a multiple family media set. BACKUP WITH FORMAT can be used to form a new media set. BACKUP DATABASE is terminating abnormally."

1. What is BACKUP WITH FORMAT?

2. Why won't it let me add a new file that is not part of the 'family' ?

3. How does it get to be part of the family?

Bill

Restore DB backup from Enterprise Edition to Standard Edition

chetanr.jain — Mon, 10 Jan 2011 23:56:29 GMT

Team,i have my production database on SQL 2000 Enterprise Edition. Now to test one of the component, i need to restore the backup to another server. To save on the cost, we have been given SQL 2000 Standard Edition ( not the enterprise Edition).Can i restore the prod db backup (SQL 2000 Ent) to Dev Box ( SQL 2000 Std).

why weekly translog backup is so large

sqladmin 45377 — Tue, 13 Nov 2012 16:30:12 GMT

I've got a sql 2000 DB with a .mdf size just under 3GB. the log file is about 2GB at this time. Most of the hourly/daily log backups are very small, between 2.5MB down to as small as 140K when there's little to no activity. However, just after my data backup maintenance plan runs the translog backup file is closer to 2.5GB. This plan runs sunday evenings only and backs up the DB and also runs the 'Reorganize data...' step under Optimizations. I also run a translog plan daily that backs up the Trans log only, once each business hour. Occasionally this server runs a bit low on disk space, so I'd like to know if there's any adjustment I could make to either maintenance plan that might result in a smaller translog backup after the Reorg Data operation. Thanks for any feedback!

Backup stored procedures,views,user defined functions from a db

dtx — Wed, 02 Apr 2008 23:59:25 GMT

Hi all!Is there a way to backup/dump all stored procedures, views, user defined functions and also triggers (if possible) from a database in MSSQL 2000?In fact I want to move all stored procedures, views, user defined functions and triggers from one database to another.The databases have the same structure but contain different data.Thanks

Auto backup and restore in remote SQL server 2000

shohelr2003 — Tue, 02 Oct 2012 22:46:47 GMT

Hi Experts,Say I have two Servers (ServerA and ServerB),I have performed database backup from ServerA and Put the backup file (.bak) to Remote Server(ServerB). Say the file name is "db_backup.bak"Now if I want to restore the backup file "db_backup.bak" on ServerB and the restore process should be started automatically.So in this case, what should I have to perform, please help me.Thanks in advance.Regards,Shohel

Checking for success of 3rd party backups

Jake Shelton — Mon, 01 Oct 2012 05:34:11 GMT

Hi all,Our full daily DB backups are handled by an external supplier whose software makes a call to SQL to perform those backups, and whenever they fail, we need to report on what db failed to backup.Ideally I want to setup a scheduled job to check this daily at 9am. Any ideas what tables/columns I need to query?Cheers,Jake

Auto Backup in remote server in sql server 2000

shohelr2003 — Sun, 30 Sep 2012 00:35:02 GMT

Hello Experts,I want to do auto backup of my database into remote servers directly. But I am not getting the solution. Please suggest me how to do this. My DBMS is SQL Server 2000 Enterprise Edition.Thank in advance.

Backup Transfer Speed

tony_nichols_2012 — Tue, 25 Sep 2012 16:39:16 GMT

I'm backing up terrabytes of production databases over a network.My transfer rates are fluctuating between 3 Mbps to 20 Mbps using Lightspeed. I have 32-bit SQL Server 2000 production servers backing up to a 64-bit file server on a gigabit connection.Is there any way I can increase my network i/o throughput without having to update my production to 64-bit ? TIA,Tony

Error msg: Could not continue scan with NOLOCK due to data movement.

christy.umoren — Thu, 06 Sep 2012 02:54:02 GMT

Hi, i keep getting the error msg;msg 601:Could not continue scan with NOLOCK due to data movement when backing up my production database. My backup file destination is on a separate server(standby server remotely connected) were recovery is to take place on the backup file to keep the standby database in sync with my production database (this is a form of Log shipping).Pls can anyone help me with error?it is a backup job that runs the backup procedurecreate procedure sp_bakdb@dbname sysname ---name of the db to be backed up@backuplocationpath nvarchar(256) ---unc path to location of the backed up database/log files; (linked server location)@baktyp varchar (20) ---backup type (full or log)asdeclare @backupfilename = @backuplocationpath + '\' + <someformat>set @dbname = lower@dbnameset @backuplocationpath = lower@backuplocationpath---backup the database/log to the specified locationprint 'Backing up ' + @dbname + ' to disk: ' + @backupfilenameif @baktyp = 'FULL'backup database @dbname to disk=@backupfilename else begin backup log @dbname to disk=@backupfilename end

All of a sudden, DB restore very slow

matt_jk — Tue, 02 Aug 2011 17:59:17 GMT

Nightly, database from server1 is backed up, the dump file copied to server2, and then restored on server2.The copy takes about 45 min, and the restore used to be about an hour. A week ago, for no reason that we can think of, the restore just decided to start taking 4 to 5 hours. We loaded on the pssdiag tool and ran it all night. Checked for blocking contention through the night, there is none. The perfmon output is so huge I'm not sure what to look for. Nothing changed on the machine, nothing installed. Disk array shows no bad disks, all error logs are clean. Can anybody shed some light on what to look for, before we end up calling MS support?

Determine Physical Device Name for a backupset.

Jamie Johnson-406551 — Tue, 30 Sep 2008 22:14:58 GMT

I am running the folowing query:SELECT TOP 1 M.physical_device_nameFROM msdb..backupset S JOIN msdb..backupmediafamily M ON M.media_set_id=S.media_set_idWHERE S.database_name = 'Gecko'AND s.type = 'D'ORDER by backup_start_date DESCwhich returns the following physical_device_name: '{80F398C7-58AC-4DC6-BC15-0B2BE1A62C8E}8'The physical address is in fact: 'E:\MSSQL\Backup\Gecko_db_200809301808.BAK'What would this guid be pointing at?

Backing up multiple databases on the Daily baises

tt-615680 — Tue, 24 Aug 2010 14:55:59 GMT

I want to backup multiple Databases on Daily biases and create a file for each Database. I would like the backups to have datetime stamp. I was going to use either Differential or incremental but I don't know the best solution. I would be grateful for your suggestions.Thank you in advance.

getting SLSFILEFORMAT::CloseSLSFile -> system exception error message

asbchakri — Mon, 25 Jun 2012 13:12:35 GMT

When running a Litespeed backup job, i was getting the following error messageSLSFILEFORMAT::CloseSLSFile -> system exceptionBut the backup job was generating for that date.

FILE 1 during restore

SQL33 — Fri, 22 Jun 2012 11:50:16 GMT

I have one old syslog collector SQL 2000 Database I'm trying to restore ... when I click "RESTORE DATABASE" and use "FROM DEVICE" then browse to the backup file location and provide the name off the backup file,.. then select RESTORE BACKUP SET and DATABASE COMPLETE" and click ok.. the RESTORE PROGRESS message appears with the word "FILE 1" in the "RESTORING" box, but it just sits there.. no progress and never does anything.Any thoughts on this would be very appreciated...>Thanks!

blocking

madhu.dba444 — Wed, 28 Dec 2011 13:15:55 GMT

wt type of blocking we will get in sqlserver

SQL SERVER EVENT ERROR

shani19831 — Mon, 21 May 2012 09:19:35 GMT

Hi guysI'm having trouble on finding out what causing this error on one of out sql servers.Date: 5/21/2012 Source: MSSQLSERVERTime: 3:00:00 AM Category (6)Type: Error Event ID 17055User: NT AUTHORITY\SYSTEMComputer: 'sqlserver name'Description3041:BACKUP failed to complete the command dump tranXpBL with truncate_onlydump tran PXBL with truncate_onlydump tran CMBL with truncate_onlydump tran RPBL with truncate_onlydump tran WRHBL with truncate_onlydump tran TLBL with truncate_onlydump tran RepDo you guys have any idea on what causes this errors and how to resolve them?I had searched on GOOGLE but there seems to be loads of typical errors but no exact resolution.Your effort will be highly appreciated.Regards,Shani

RedGate SQL BackupPro 7.0?

Ray Herring — Mon, 20 Feb 2012 09:02:01 GMT

Hi All,I know 6.5 has been out for awhile.Anyone know when/if 7.0 might come along?

How to automate a backup on prod and a restore on test?

kevinsql7 — Thu, 03 Sep 2009 08:14:24 GMT

We are running SQL Server 2000 (SP4) on Windows Server 2003. I am looking for a simple, easy to implement method that would allow me to automatically restore the production sql server backups to the test databases. Currently, I back up the sql server databases on the production server and then xcopy the backups (just for storage on another box) to the test server. Note the backup file name contains the date and time stamp (pubs_backup_200909020421.BAK) so the restore script would have to reference this exact name in a scheduled process. (I currently use the SQL Maintenance Plans on the Production Server to create my sql server backups with the date time stamp as part of the backup file name.) I would think I would have to use a script to backup the database on the production server, xcopy the backup to the test server, and then use a script to restore the database on the test server. 1) On Production Server:USE pubs BACKUP DATABASE pubs TO DISK= 'd:\sqlbackups\pubs_backup_200902031724.bak'; GO RESTORE VERIFYONLY FROM DISK = 'd:\sqlbackups\pubs_backup_200902031724.bak'; 2) On Test Server;Scheduled XCopy Process which copies the backup file from production server to test server.3) On Test Server:RESTORE DATABASE pubs FROM DISK = 'd:\sqlbackups\pubs_backup_200902031724.bak'; Please provide advice especially with how to handle the date time stamp placed on the backup file name by the SQL Maintenance Plans. Or, should I backup each daily file to a name like: 'd:\sqlbackups\pubs_backup_sunday.bak'And then have a scheduled restore script to restore this particular daily backup file name.Lastly, is there a way to spool the output of the backup, verify and restore commands to a text file?Thanks, Kevin

Operating System Error 999

JohnnyDBA — Sat, 27 Jun 2009 08:31:47 GMT

We have a customer that uses a snap server as storage for their SQL Server 2000 databases. Lately we've been getting issues creating the backups, especially on two of the very large databases (450 GB and 500 GB).The error that I see (among others) is the following:[quote]Operating system error 999(Error performing inpage operation.)[/quote]I haven't been able to find much explanation online regarding this error. The only two possibilities I've found are1) Not enough disk space - I don't think this is the issue, it looks like there is plenty of space2) Bad blocks on the drive - I don't know how to verify this.Please advise.John

Significance of backup_set_id field in restorehistory table??

dilip-196624 — Thu, 23 Jun 2005 08:37:00 GMT

Hi,In SQL BOL, it states that the below description for backup_set_id in restorehistorytable************************************************************backup_set_id int NOT NULL REFERENCES backupset(backup_set_id) ************************************************************But I dont think whether it actually references or not, becoz i did a backup and restore(on network server) chekced the backup_set_id in both tables i.e. backupset as well as restorehistory tables, But both are having different ids? So i think it wont be any useful if we want to relate both the tables. Any thoughts?Dilip

Database backup and Log backup Failing regularly, backups maintained in TDP

rgvala — Tue, 31 Jan 2012 07:29:00 GMT

I am getting regular backup failed tickets on a Database. When checked in server , database name dosnt exist, it comes with an extension of existing Database.The error i am getting on a database with database name and extension as DBName__20120131_140010_8237335. Here is the log of TDP“01/27/2012 20:05:36 Database Database_20120128_030053_1646338' does not exist. Make sure that the name is entered correctly.01/27/2012 20:05:36 BACKUP DATABASE is terminating abnormally.01/27/2012 20:05:36 Changed database context to 'master'. (HRESULT:0x80131501)”Can anyone give me the solution for this.Thanks in Advance.RegardsRam

Single table backup using sqlcmd

kamleshsinhchauhan — Tue, 31 Jan 2012 02:06:46 GMT

I need to take a single table backup using sqlcmd???? How can i take a backup of particular table using sqlcmd??

issue with rebuildm.exe

huy1002 — Wed, 20 Jul 2011 14:15:41 GMT

after i copied rebuildm.exe and sqlsui.dll from CD to the SQL instance where these files are missing, i i ran the exe file and here what i got:"There are no qualified maintainable instances to rebuild".Do you know why? Please help, i have never seen this issue before

db autogrowth settings

TJ-356724 — Tue, 10 Jan 2012 05:46:09 GMT

I am not a DBA but get into it on a periodically basis. We have db size of 50G with 25.3G free or 50%. Breakdown is as follows: Data 42G allocated with 17G free or 40%. Log 8.3G with 8.2 free or 99%. DB backup every day. Trans log backup everyday from 6 am to 11 pm. Only indexes with pages > 10 and fragmentation > 10 are reindexed once per week(this should probably be changed). The current(legacy) auto-growth is set at 3% for both data and log. We do not expect rapid db growth but can setup scripts to monitor. Given these conditions should auto-growth be set to 0 for both data and log? What is the most reasonable page count and fragmentation level to do DBCC DBREINDEX for the selected table\index?

REFRESH PRODUCTION DB to DEVELOPMESQNT

goofy2sql — Mon, 12 Dec 2011 20:46:23 GMT

HI Friends;I have a database in production which needs to be backedup and restored on Development box. THE PROD and DEV are two separate servers. The Development box has same databases that are on production. This needs to be replaced with latest production db's. Please help me the process I should follow;1. TSQL SCRIPT to BACKUP (what options, like format, init etc)2. RESTORE TSQL SCRIPT (what happens to existing files names on dev box.)3. HOW are users need to be mapped again.4. THESE PROD AND DEV. are in 2000 environment.Thanks for the help.SS

Any one using Tivoli, TDP from IBM????

devereauxj — Thu, 17 Feb 2005 12:18:00 GMT

We are using Tivoli TDP from IBM to do our backups to our tape robitic system. It has worked very well for backing and restoreing user databases.

My issue is with full instance restore, including all system databases. I did do full restores with SQL Server 2000 using backup devices. Now I am trying to do the same thing with the TDP utility.

My problem: I need to restore the user and system databases to another machine with a different instance name and maybe different drive config. I can restore the master, but it knows about the missing user databases and paths for the system databases. I have not been able to restore any user or system databases after the master.

Looking for someone who has done this with TDP, or might have more detail documentation. I have the standard document and the red book.

Thanks,

Joseph

Error on Backup to Netweork Location

Jack Corbett — Tue, 28 Dec 2004 13:15:00 GMT

I have a database, about 7GB, that I am attempting to backu pacross the network to a Firewire drive connected to another server. The bakcup runs and seems to be complete, but ends with an error. When I check the SQL Server log the error is:

BackupDiskFile::RequestDurableMedia: failure on backup device '\\cherry\dumps\mole\molert_full.BAK'. Operating system error 87(The parameter is incorrect.).

I have googled the error and have not found anything that is of any help. Most of the hits are just MS error code listings. Does anyone know anything about this Operating System Error?

I am successfully using htis backup strategy at another location.

Thanks,

sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

Cary P. Thrasher — Wed, 28 Jul 2004 12:25:00 GMT

At my Company, I set up a Maintenence Plan to back up one of our Databases (quite large) prior to the monthend processing. This was to ensure if data needed prior to month end load, data would be avaialble. I can run this myself and it works fine, but as a scheduled job it received this error. Does anyone know the answer to this. Additional info is that I set the plan to delete any backup old than three months, which hasn't been reached yet.

Error received -

sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

install Infosphere CDC SQL 2000

santuzzo01 — Thu, 20 Jan 2011 14:54:42 GMT

I’m trying to install IBM Infosphere CDC (old DataMirror Transformation Server) and I receive the message: IBM Infosphere Change Data Capture has detected multiple backups to the same file: C:\backups\mybase.trn.I deleted the file mybase.trn but still receive the same message. There is a requirement of Infosphere CDC to have only one backup in each file.I have SQL server 2000 SP4.Can anybody help me?