Restore database - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Restore database

Author

Topic

Jack121
Starting Member

14 Posts

Posted - 2007-11-02 : 06:35:15

Hello ..I have a database backup file called TEST.bak that was created on my friends Pc, I would like to use it on my laptop. I tried to restore but I get an error message "To many backup decvices specified for backup or restore, only 64 are allowed"..
what does this mean, and how can I fix this?

Jack

sudheer.v538@gmail.com
Starting Member

10 Posts

Posted - 2007-11-02 : 06:51:17

Hi, First u have to copy that TEST.BAK file to ur laptop and then ...
In GENERAL tab - FROM DEVICE - SELECT DEVICES - ADD - specify the exact FILE NAME.
If any file name exists before adding, remove all those.
Hope this helps u.

-- Siddhu

Sudheer

Jack121
Starting Member

14 Posts

Posted - 2007-11-02 : 07:11:20

Ok..still new to this.....where exactly is the General tab..I am using SQL Server Mangement Studio..

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-11-02 : 07:25:10

Are you trying to restore a backup of sql server 2005's database at 2000?

Madhivanan

Failing to plan is Planning to fail

Jack121
Starting Member

14 Posts

Posted - 2007-11-02 : 07:32:41

No..I am restoring to 2005..why do you ask?

sudheer.v538@gmail.com
Starting Member

10 Posts

Posted - 2007-11-02 : 07:45:04

SQL SERVER MANAGEMENT STUDIO - OBJECT EXPLORER - DATABASES(right clik) - RESTORE DATABASE - GENERAL - TO DATABASE:[RESTORING NAME], FROM DEVICE - As usual process above i mentioned...

Sudheer

Jack121
Starting Member

14 Posts

Posted - 2007-11-02 : 11:56:41

This is what I did previously ..and I still getthe same error message
"To many backup decvices specified for backup or restore, only 64 are allowed"..
the database was not initally created on my laptop though..what am I doing wrong?

Paul

Kristen
Test

22859 Posts

Posted - 2007-11-02 : 12:01:39

Might be worth trying to make the restore using SQL syntax, you might get some more helpful error messages. I can't believe the one you are getting has anything to do with the underlying problem (unless the BAK file has become corrupted)

See: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=RESTORE%20syntax%20/%20example

Kristen

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-02 : 22:25:17

Check backup file with 'restore verifyonly'.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources