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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-10 : 08:49:19
|
| Ajit writes "Hi there,I have backup file of database of sql 7.0. I want to restore my database on another machine with SQL 2000. I cangnt database and log files directory as well. I tried to create SQL 7 folder system but it is not working.Any help? Please it is killing me.Cheers,Ajit" |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-04-10 : 09:37:30
|
| Well, what exactly are you having trouble with? It would be difficult for us to help you unless you tell us exactly what you are trying to do, and what error message you are getting. Anyhow. If you have a database backup, you should be able to issue a RESTORE DATABASE command from Query Analyzer (see BOL for syntax and samples). If the backup file is on a network share, make sure that the service account for your SQL2k has rights to access that share.---------------Strong SQL Developer wanted in the Boston area. Please e-mail if interested.Edited by - izaltsman on 04/10/2002 09:38:17 |
 |
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2002-04-10 : 11:58:36
|
| Hard to understand the question, but I'll play along. Sounds like you need to use the WITH MOVE option. JamesH. |
|
|
|
|
|
|
Restoring .bak file of SQL 7 to SQL 2000.