Home > sql server > SQL Server 2000: Database copy wizard - Claims files already exist (they don't) or there is not enough disk space (there is)

SQL Server 2000: Database copy wizard - Claims files already exist (they don't) or there is not enough disk space (there is)

July 28Hits:2
Advertisement

I am trying to copy some SQL Server Agent Jobs from one server to another (both using SQL Server 2000).

I found out how to create a script that creates them all, but these jobs seem to have dependencies, such as DTS packages, and I need to copy everything (and don't really know what I'm doing, let's be honest).

So I tried the built in Database Copy Wizard (in Enterprise Manager, remember that?). But as you can see in the screenshots linked below, it claims the destination .mdf and .ldf files already exist (they don't), or there is not enough disk space (there is).

SQL Server 2000: Database copy wizard - Claims files already exist (they don't) or there is not enough disk space (there is)

See how next to both rows, there is a green tick in status? But then, further down, there is a red cross. The screen is confusing: is there an error or not?

If you click on Modify (sorry, silly rules about links when you have low rep):

http:// img16.imageshack.us/img16/9439/cdwerror2.png

Once again, I have all green ticks, but then those nasty red crosses down the bottom. Which is it saying? Or is it saying both?

So I continued anyway... and after it's done, the following failures are reported on screen:

CDW Logins Task Step: fails, but this is OK - it just couldn't transfer the administrator login (I think that's not a problem, becasue it's that machine's local windows admin logon).

CDW MSDB Task Step: fails, objects scripted OK, but can't be transferred, e.g.:

 Transfer MSBD  Update_Daily_Person_Set (SQL SERVER AGENT JOB)   Step Error Source: Microsoft Data Transformation Services (DTS) Package  Step Error Description:Unspecified error   Step Error code: 80004005  Step Error Help File:sqldts80.hlp  Step Error Help Context ID:1100

I'm not sure where to find sqldts80.hlp (anyone know?) and googling for the 80004005 SQL Server error reveals that it could be any one of about a hundred different things (literally) depending on the rest of the error message (none was given in this case).

CDW Databases Task Step:

The actual copying of the .mdf files failed. One DB wouldn't attempt to copy because it had active connections - I assume I can just disconnect those to solve that part.

Thanks for reading this far!

I tried allowing "Everyone" write permissions on the destination folder, no change. Any other ideas?

Answers

I've never used the copy database wizard to copy a system database, but it's possible that it won't work for that. I know that task has been flaky for me and I've rarely used it.

Are you moving servers? msdb has system information, and if you don't intend to replace all that info on the new server, I wouldn't necessarily transfer it.

Moving DTS packages is a pain, but you can open them and save them to a new server (save as), or you can use something like this http://www.sqldts.com/204.aspx

For jobs, those are simple script files, and there aren't likely many dependencies on logins for them. If there are, sp_help_revlogin will move those to a new server through a script.

I know it seems complicated, but it's not that bad, and the manual time is probably lost here in researching the issue.

The the transfer, you have a destination folder, but there is a path stored in the logical files, and it's possible that it matches up with the new server. Are the installs default? Same paths for msdb.mdf on both serers?

Related Articles

  • SQL Server 2000: Database copy wizard - Claims files already exist (they don't) or there is not enough disk space (there is)

    SQL Server 2000: Database copy wizard - Claims files already exist (they don't) or there is not enough disk space (there is)July 28

    I am trying to copy some SQL Server Agent Jobs from one server to another (both using SQL Server 2000). I found out how to create a script that creates them all, but these jobs seem to have dependencies, such as DTS packages, and I need to copy every

  • Copy a SQL Server 2000 database to another box without interrupting the backup chainApril 3

    I have a small-but-important MS SQL Server 2000 database that I'd like to copy to a development box. I understand that the usual way to do this is to make a copy of a full backup file, and restore that backup onto the dev box. The twist here is that

  • Unable to copy a DB from SQL Server 2000 to SQL Server 2012 using copy wizardOctober 7

    I am trying to copy a database from SQL Server 2000 to SQL Server 2012 using copy wizard in my local machine where SQL Server 2012 is installed. But, the wizard is not detecting destination server. Source DB is on a network and Destination is my loca

  • Your First SQL Server 2000 Database

    Your First SQL Server 2000 DatabaseApril 10

    Try surfing around the Internet and find a popular site that doesn't use some sort of database to store its content. I bet you'll have a tough time finding just one popular site (i.e. receiving over 5,000 unique visitors a day) that doesn't use some

  • Attaching A Non-MDF SQL-Server 2000 DatabaseFebruary 11

    I am trying to view a copy of a SQL Server 2000 database I received, but I cannot find a way to 'attach' the database to my instance of SQL Server. I have fairly limited experience working with SQL Server, but for the most part the databases I've wor

  • Upgrade SQL Server 2000 database to 2008 R2 and enable new featuresSeptember 22

    I have recently upgraded SQL Server 2000 database to 2008 R2. What I did was: Shutdown SQL Server 2000 (express) service on old machine, Move datafiles (mydatabase.mdf and mydatabase.ldf) to new machine, Run SQL Server Management Studio 2008, Connect

  • Can a SQL Server 2000 database be hosted on SQL Server 2005/2008December 30

    I have a SQL Server 2000 database backup, but I don't have SQL Server 2000 installed. I have SQL Server 2005 installed. I'd like not to have multiple pieces of DB server software installed. Is it possible in either SQL Server 2005 or SQL Server 2008

  • Restore sql server 2000 database to 2008March 21

    I am not a DBA. I will be doing this for the first time. So I am not sure what all I am supposed to do? I will be restoring sql server 2000 database to sql server 2008. Are there anywhere step by step instructions to do this? I know I am supposed to

  • SQL Server 2000 database attach error to SQL Server 2005March 5

    I have a SQL Server 2000 database (mdf and ldf). When I try to attach it, using SQL Server Management Studio Express 2005, I get this error: Attach database failed for Server 'XXXXX\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo) An exception occurred

  • Encrypting a column in SQL Server 2000 databaseJuly 9

    I've been tasked with encrypting several years worth of sensitive data (don't ask) stored in a SQL Server 2000 Database. I need to encrypt both historical data and come up with a process to encrypt and decrypt new data as it flows through the system.

  • SQL Server 2000 - Database Table Dissappeared. What are the possible reasons?January 6

    We've had a table disappear from our production SQL Server 2000 database. It's running on RAID 5 storage so we're pretty confident that it's not hardware-related corruption. We're aware that this indicates a possible breach of security. We're investi

  • Is SQL Server Management Studio capable of managing SQL Server 2000 databases?July 28

    I know this is really basic, but I can't find the answer in Google or SF, so I thought I'd better just ask. If I run SQL Server 2008 R2 Management Studio on my PC, can I manage a SQL Server 2000 database server? I know I can do it from SQL Server 200

  • Find last access datetime stamp for objects in SQL Server 2000 databaseOctober 8

    I'm in the planning stage/phase of migrating one of our SQL Server 2000 databases to 2008. Our database holds numerous tables (hundreds) and stored procedures (hundreds). I'm trying to figure out which are in use and which are not. My first guess was

  • upgrading sql server 2000 database to sql server 2012April 9

    Seeking some advice about an oudated database system we're working with.... hope this is an appropriate place to post this question. I work with a city government arts program. In 2004, we contracted with a local database developer to develop a syste

  • Restore SQL Server 2000 Database in useJuly 17

    I need to restore a SQL Server 2000 database to a backup of about 2 days ago. I have just backed it up and have tried to restore it, but it says it is in use. What is the best way to find out who is still using it and then how to disconnect them? I i

  • How to backup an SQL Server 2000 database on Windows 10?February 3

    Introduction I have been assigned to an old site running on classic ASP and an SQL Server 2000 database. I don't have root access to the server since it's a basic hosting plan. The problem We are intending to migrate the site and DB to another server

  • Migrating SQL server 2000 database to SQL server 2005August 14

    Can any one suggest variou ways of migrating a database from SQL server 2000 to 2005. How do I make sure all constraints, primary keys and indexes are preserved. Is there any migration tool that preserves them. --------------Solutions------------- Th

  • get a sql server 2000 database out of emergency modeSeptember 22

    there is a db in emergency mode,which i was told to make it "normal". in the enterprise manager i can not see any objects(like tables, users and stuff). in the guy's computer, i connect to the server via toad, and copied all the tables and users

  • Is there a way to use a SQL Server 2000 database in SSIS 2012?June 13

    I just got my first chance to install SQL Server 2012 on a test machine. I also installed all of the management and Visual Studios components. I created a copy of one of my SSIS 2008 packages and converted it to 2012. The conversion worked jsut fine,

  • Export a SQL Server 2000 database to Server 2012January 7

    I have a production environment running Windows Server 2000 and a development environment using SQL Server 2012. I need to make updates to the DB and implement some new features using .ASP. Is there a way to export the 2000 database and import it int

Copyright (C) 2017 ceus-now.com, All Rights Reserved. webmaster#ceus-now.com 14 q. 1.120 s.