| Author |
 Topic  |
|
SohaibQazi
Starting Member
Pakistan
2 Posts |
 Posted - 07/28/2010 : 02:48:14
|
Hi
I have a question. I had Sql Server 2005 installed on my system. I took backup of my DB with .bak extension. Then i have uninstalled sql server 2005 and installed sql server 2000.
Now i want to restore my database. I have opened Enterprise Manager of Sql Server 2000 and in DataBases Folder i go with All Tasks--> RestoreDatabase and a Screen appeared in front of me asking some info about restoration. I tried to restore my DB from disk as i have a backup on my disk. But when i clicked ok, it is giving me error "Too many backup devices specified for backup or restore; only 64 are allowed."
Can anyone tell me how to fix this issue???
Any little help will be appreciated greatly. Thanks in Advance
Regards
Sohaib Qazi
Sohaib Qazi
Software Engineer (Eycon Private Limited)
Contact # +92-345-5552423
Email # sohaib_qau@hotmail.com
|
 |
|
|
SohaibQazi
Starting Member
Pakistan
2 Posts |
Posted - 07/28/2010 : 02:49:06
|
Hi
I have a question. I had Sql Server 2005 installed on my system. I took backup of my DB with .bak extension. Then i have uninstalled sql server 2005 and installed sql server 2000.
Now i want to restore my database. I have opened Enterprise Manager of Sql Server 2000 and in DataBases Folder i go with All Tasks--> RestoreDatabase and a Screen appeared in front of me asking some info about restoration. I tried to restore my DB from disk as i have a backup on my disk. But when i clicked ok, it is giving me error "Too many backup devices specified for backup or restore; only 64 are allowed."
Can anyone tell me how to fix this issue???
Any little help will be appreciated greatly. Thanks in Advance
Regards
Sohaib Qazi
Sohaib Qazi
Software Engineer (Eycon Private Limited)
Contact # +92-345-5552423
Email # sohaib_qau@hotmail.com
|
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 07/28/2010 : 03:35:24
|
| You cannot restore a backup made on SQL2005 onto SQL 2000 version. |
|
|
|
gijoemike
Starting Member
3 Posts |
Posted - 08/19/2010 : 00:13:01
|
quote:
Originally posted by tkizer
Oops, missing a comma:
RESTORE DATABASE Storeshop
FROM DISK = 'C:\Backup.BAK'
WITH REPLACE, MOVE 'storeshop' TO 'C:\MSSQL\DATA\Storeshop_Data.MDF',
MOVE 'storeshop_log' TO 'C:\MSSQL\DATA\Storeshop_Log.LDF'
Tara
I'm trying to do what you did here. To restore a .bak file to my new shared hosting windows server that has ms sql.
How do I find the path of the .bak file?
I uploaded the .bak file to my shared-hosting-godaddy windows server. The server details said:
Absolute Hosting Path:
D:\Hosting\6581143\html
I tried:
RESTORE FILELISTONLY
FROM DISK = 'D:\Hosting\6581143\html\paintcheck.bak'
But error:
Cannot open backup device 'D:\Hosting\6581143\html\paintcheck.bak'. Operating system error 3(The system cannot find the path specified.). RESTORE FILELIST is terminating abnormally.
Thanks! |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
forexbob
Starting Member
6 Posts |
Posted - 12/19/2010 : 23:14:22
|
This is a very long thread, time wise. But I wanted to see if you helpful folks could assist me.
I did:
RESTORE FILELISTONLY
FROM DISK = 'C:\VealeDataBase.BAK'
and got the following information.
D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\VealeDataBase.mdf
D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\VealeDataBase_log.LDF
D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\VealeDataBase
Now I'm going to stop here for two reasons.
1. This looks nothing like what Arlene posted waaaay back.
2. I don't have a "Program Files" folder on my D: drive
Regardless I forged ahead to see what errors I would get for more troubleshooting info.
So I did this: (following the syntax in Tara's post from....waaaay back)
RESTORE DATABASE VealeDataBase
FROM DISK = 'C:\VealeDataBase.BAK'
WITH REPLACE, MOVE 'VealeDataBase' TO 'C:\Documents and Settings\Oolon\My Documents\Visual Studio 2010\Projects\TheVeales\App_Data\VealeDataBase_Data.MDF',
MOVE 'VealeDataBase_log' TO 'C:\Documents and Settings\Oolon\My Documents\Visual Studio 2010\Projects\TheVeales\App_Data\VealeDataBase_Log.LDF'
And I got this error:
Msg 3283, Level 16, State 3, Line 1
The file "sysft_VealeDataBase" failed to initialize correctly. Examine the error logs for more details.
Msg 3013, Level 16, State 1, Line 1
...which I have seen in this thread before.
So I checked the error log and got this:
The operating system returned the error '5(Access is denied.)' while attempting 'DeleteTree' on 'C:\Inetpub\wwwroot\bin' at 'fulltext.cpp'(1729)
So I gave "Everyone" full access, eventually, to the c: and d: drive (just in case) and....
I get the same error. I'm not sure how access can be denied when I've blanket authorization.
I've had to move my sites to another host as my original host is....well, pretty much useless.
I've rebuilt one site, I'm in the process of building the second, but there is info in the db that I would like to be able to restore to the third site. I can rebuild the site, but I can't replace the data.
Opinions, ideas, tell me I'm hopped and forget it.....
Thanks
Bob
|
|
|
|
forexbob
Starting Member
6 Posts |
Posted - 12/19/2010 : 23:17:35
|
| ...that should be "hooped" |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
renequimoyog
Starting Member
Philippines
4 Posts |
Posted - 11/22/2011 : 03:01:32
|
| This has worked for me thanks Tkizer |
|
|
|
lopezedgar
Starting Member
Mexico
1 Posts |
Posted - 04/03/2013 : 04:49:44
|
quote:
Originally posted by tkizer
Oops, missing a comma:
RESTORE DATABASE Storeshop
FROM DISK = 'C:\Backup.BAK'
WITH REPLACE, MOVE 'storeshop' TO 'C:\MSSQL\DATA\Storeshop_Data.MDF',
MOVE 'storeshop_log' TO 'C:\MSSQL\DATA\Storeshop_Log.LDF'
Tara
Thank you for your answer it also helped me too!!! Greetings from Mexico city!! |
|
|
|
Topic |
|
Restoring .BAK file to a different server?
