473,386 Members | 1,598 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

HELP: error 3154 when restoring a backup file

ddtpmyra
333 100+
I have this a backup file from a disk and I have to copy it on my database. When I tried to restored it I got this below message. Originally I created a database called SnapShot using Server Mgmnt Studio I just right click on the 'Snapshot' database and click the restore button the rest is i just fill up the directory.

Expand|Select|Wrap|Line Numbers
  1. Msg 3154, Level 16, State 4, Line 1
  2. The backup set holds a backup of a database other than the existing 'snapshot' database.
  3. Msg 3013, Level 16, State 1, Line 1
  4. RESTORE DATABASE is terminating abnormally.
The script generated to re-store my back up is like this.
Expand|Select|Wrap|Line Numbers
  1. RESTORE DATABASE [i2iBackup] FILE = N'T_LifeLong',  
  2. FILE = N'T_LifeLong_log' FROM  DISK = N'\\net\copy\001.bak' 
  3. WITH  RESTRICTED_USER,  FILE = 1,  NOUNLOAD,  REPLACE,  STATS = 10
  4. GO
  5.  
Am I doing it correct? All I want is to upload the backup file my collegue send me.

Thanks!
Mar 4 '11 #1
4 6843
ck9663
2,878 Expert 2GB
It means your backup is not for Snapshot. Also, try naming it something else. SQL 2005 have a snapshot feature. That could be a reserver word.

Good Luck!!!

~~ CK
Mar 4 '11 #2
ddtpmyra
333 100+
Actually the 'snapshot' is not the real name I just thought of best word to fit. Are you saying if I have a Copy001.bak I have to create same name of database for me to re-store it?

thanks!
Mar 4 '11 #3
ck9663
2,878 Expert 2GB
If that's the case then check if you have an existing database with that name. If you do, you can either check the WITH REPLACE option, rename the old one or restore it to a new one.

Good Luck!!!

~~ CK
Mar 5 '11 #4
ddtpmyra
333 100+
Problem solved! What happened was ... Im inside the database where I want to restore. I have to disconnect and use the master.

Thanks again for all your help!
Mar 16 '11 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Mark | last post by:
Not sure this is the right place for this questions, but here goes: I get an error message when deleting an table from a Access database. The code is as follows and the error message is after...
3
by: David B | last post by:
I have this code to find a file, place it in C:\ temp, zip it up then send it to floppy in drive A:\. When I run it it comes up with error 53 - source file not found. However it gets as far as...
3
by: Clodoaldo Pinto Neto | last post by:
Hi all, I'm restoring a database from 7.3.4 FC1 to 7.4.2 FC2: $ pg_restore -d KakaoStats KakaoStats.dump pg_restore: could not execute query: ERROR: could not access file...
2
by: OliviuG | last post by:
I have export to xls functionality in asp.net web form, implemented like this: Response.Clear(); Response.AddHeader("Content-Disposition", "attachment; filename=InvChangeHistory.xls");...
8
by: Claudio Grondi | last post by:
Here an example of what I mean (Python 2.4.2, IDLE 1.1.2, Windows XP SP2, NTFS file system, 80 GByte large file): Traceback (most recent call last): File "<pyshell#1>", line 1, in -toplevel-...
11
by: robertmeyer1 | last post by:
Hey. I have a mainform, based off a tblClient. Then 2 sbf’s based off queries. I’m trying to insert the sbf’s into the mainform to allow for data entry (using the Tab Control). I am linking the...
2
by: Gerd | last post by:
Hi all, I'm having a problem restoring backup from 2000 to 2005. The actual restore process went ok. However, the database user of the restored database is missing a Login Name. I've made...
2
by: Neil | last post by:
Is there a way to read a backup file to see if it contains a file without restoring the backup file? We are missing a record from a table, and I need to find out when it was deleted. We have...
2
peeaurjee
by: peeaurjee | last post by:
hi! I am using Ms Access 2003 on Xp and i have shared a database on the server through LAN. There is 1 Administrator account, 5 data entry users and 4 read only users. I think I have messed up with...
0
by: hivdb2 | last post by:
Hi all, I have an app developed in Access 2000/2003 (2000 compatible). I have a routine to refresh table links. Both files are MDB files (the front end and back end). The code I use is as...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.