Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
attackmonkey
Starting Member
19 Posts |
 Posted - 2002-12-09 : 05:04:31
|
| hi,I'm relatively new to some of the admin aspects of using SQL server. I have a problem sometime's when I'm trying to copy DB's from one server to another. Usually one of two things happens:1. Using the DTS Wizard to export the data results in unknown SQL-DMO errors and the process dies.2. Using the old backup/restore method, it appears to work, but then the DB show up as suspect and I can't get it backDoes anyone know whath the causes of these problems are, adn could they point me in the direction of any useful resources/information? So far, I haven't had any luck finding anything useful.:(Thanks in advance for any help and advice! |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-12-09 : 07:41:39
|
quote:
hi,I'm relatively new to some of the admin aspects of using SQL server. I have a problem sometime's when I'm trying to copy DB's from one server to another. Usually one of two things happens:1. Using the DTS Wizard to export the data results in unknown SQL-DMO errors and the process dies.2. Using the old backup/restore method, it appears to work, but then the DB show up as suspect and I can't get it backDoes anyone know whath the causes of these problems are, adn could they point me in the direction of any useful resources/information? So far, I haven't had any luck finding anything useful.:(Thanks in advance for any help and advice!
the db is set to suspect generally when the sql server is unable to complete recovery on a database because of no free disk space.so first check if there is enough space in the data as well as log files and ample diskspace available.you will find plenty of help in BOL under the topic [suspect databases]harshal. |
 |
|
|
|
|
|
Copy DB's between servers