Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SQL Server 2005 Copy Database Wizard Error

Posted on 2006-06-28
9
1,230 Views
Last Modified: 2008-01-09
I am new to SQL Server 2005 and I'm stuck.  I'm trying to use the Copy Database Wizard to move a database off of my local machine but after going through all of the steps it bombs out and returns the following error:

"While trying to find a folder on SQL an OLE DB error was encountered with error code 0x80004005 (Login timeout expired).
 (Copy Database Wizard)

------------------------------
ADDITIONAL INFORMATION:

While trying to find a folder on SQL an OLE DB error was encountered with error code 0x80004005 (Login timeout expired)."

I can't find anything on this error anywhere, any thoughts?

Thanks,

N
0
Comment
Question by:stretch73
  • 6
  • 2
9 Comments
 
LVL 13

Expert Comment

by:Atlanta_Mike
ID: 17004659
First thing...

Instead of using the copy database wizard. Why don't you just backup and restore to another database server.?

0
 

Author Comment

by:stretch73
ID: 17004682
I guess that will have to work, someone else at the office suggested it but the copy thing seemed pretty simple.

What is the procedure for that?
0
 

Author Comment

by:stretch73
ID: 17004834
Actually, I would really like to figure out how to do it with the copy function.  Someone is going to be inheriting this application soon and I would like to make it as simple as possible.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 27

Expert Comment

by:ptjcb
ID: 17005715
I understand what you want, but backup, copy to the other server, restore is easier for a database administrator.  

The copy database works, in theory, but the errors are OLE DB errors (programming ones) rather than internal to SQL. Backup and restore have been around for many versions of sql and we know what to do with errors. With the new features there is a learning curve. I have found that some of learning any new language or new extensions of the language will be wrestling with the error codes. Most are cryptic at best. Copy Database has only been around since 2000 (I don't remember it in 7, but I could be wrong). It looks as if they have enhanced it with Visual Studio.

If the newbie is a programmer with knowledge of VS .NET then they may be more comfortable with copy database.
0
 

Author Comment

by:stretch73
ID: 17008679
I follow, I'll just do the backup and restore.  Can you walk me through the steps on that?
0
 

Author Comment

by:stretch73
ID: 17008842
I've played around with it a little but I need to restore it to a different server, it keeps just re-creating the database within the same server registration.
0
 
LVL 27

Accepted Solution

by:
ptjcb earned 300 total points
ID: 17009044
In Enterprise Manager select the server and then using the Tools menu choose Backup Database. This will open the Backup window.  Select the database from the database drop down box. Type the name for the backup (it can be descriptive). Click Add in the Destination section. Navigate to a file on the server. Then click on the Options tab and check Verify Backup upon completion.

To restore - you have to have exclusive access to the database. Select the server, Tools, Restore Database. Use the Restore drop-down to find the database to restore. If you are restoring over another db, then in the Options tab choose Force Restore Over Existing Database. You may have to change the location of the files in the Restore Database As: textbox.
0
 

Author Comment

by:stretch73
ID: 17009183
I'm with you as far as the backup, that's pretty straightforward.  The restore is where I'm having trouble.  This is going to a completely separate server so do I need to copy the backup file out there first?
0
 

Author Comment

by:stretch73
ID: 17012076
PTCJB, that worked.  Had a bunch of peripheral problems but the restore over option got it.

Thanks,

N
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question