SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Restoring .BAK file to a different server?
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

SohaibQazi
Starting Member

Pakistan
2 Posts

Posted - 07/28/2010 :  02:48:14  Show Profile  Reply with Quote
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
Go to Top of Page

SohaibQazi
Starting Member

Pakistan
2 Posts

Posted - 07/28/2010 :  02:49:06  Show Profile  Reply with Quote
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
Go to Top of Page

Kristen
Test

United Kingdom
22431 Posts

Posted - 07/28/2010 :  03:35:24  Show Profile  Reply with Quote
You cannot restore a backup made on SQL2005 onto SQL 2000 version.
Go to Top of Page

gijoemike
Starting Member

3 Posts

Posted - 08/19/2010 :  00:13:01  Show Profile  Reply with Quote
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!
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37287 Posts

Posted - 08/19/2010 :  12:50:15  Show Profile  Visit tkizer's Homepage  Reply with Quote
gijoemike,

You should start a new topic on this. What you put in the FROM DISK portion is where you placed the backup file. It's the WITH MOVE parts, then you're going to need help with. Start a new topic and we'll help you out.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

forexbob
Starting Member

6 Posts

Posted - 12/19/2010 :  23:14:22  Show Profile  Reply with Quote
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

Go to Top of Page

forexbob
Starting Member

6 Posts

Posted - 12/19/2010 :  23:17:35  Show Profile  Reply with Quote
...that should be "hooped"
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37287 Posts

Posted - 12/20/2010 :  10:40:16  Show Profile  Visit tkizer's Homepage  Reply with Quote
Bob, please start a new thread.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

renequimoyog
Starting Member

Philippines
4 Posts

Posted - 11/22/2011 :  03:01:32  Show Profile  Reply with Quote
This has worked for me thanks Tkizer
Go to Top of Page

lopezedgar
Starting Member

Mexico
1 Posts

Posted - 04/03/2013 :  04:49:44  Show Profile  Reply with Quote
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!!
Go to Top of Page

elliswhite
Starting Member

36 Posts

Posted - 05/03/2014 :  01:32:15  Show Profile  Reply with Quote
u only need to move your .bak file into another location, drive or server with log file then u can restore backup file there very easily by following simple steps. Check this http://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backups
Go to Top of Page

elliswhite
Starting Member

36 Posts

Posted - 05/03/2014 :  01:35:57  Show Profile  Reply with Quote
u can copy or move .bak file into new drive, location or server and then follow restore procedure there easily. Check this http://www.techrepublic.com/article/step-by-step-learn-how-to-restore-databases-in-microsoft-sql-server/
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000