DB Restore Error
Feb 22, 2005
Hi all, I'm getting this error when trying to restore a database:
"Device activation error. The physical file name 'E:program filesMS SQL serverMSSQLdataDBname.mdf' may be incorrect. File 'DBname_dat' cannot be restored to 'E:program filesMS SQL serverMSSQLdataDBname.mdf'. Use WITH MOVE to identify a valid location for the file. Device activation error. The physical file name 'E:program filesMS SQL serverMSSQLdataDBname.ldf' may be incorrect. File 'DBname_log' cannot be restored to 'E:program filesMS SQL serverMSSQLdataDBname.ldf'. Use WITH MOVE to identify a valid location for the file. RESTORE DATABASE is terminating abnormally."
What I'm doing is, on another personal sql server a backup was created of this DB, then sent to me. Now I created a new DB named after the one that was backed up. Then I go to restore the DB into the one I created. But i get this error. How can I trouble-shoot this?
View 3 Replies
ADVERTISEMENT
Jan 28, 2002
Hi,
I have a 40G database that I am trying to restore from tape. The original server has sp2 on it. On my first try I got a corruption error while restoring the database and later found on technet that a backup from a database that has "auto shrink" option enabled, might give corruption error 9004, and this is fixed with sp3. So I turned off the auto shrink off, took another tape bacdkup and tried restoring again, and this time I got the following error;
...
Processed 19 pages for database 'AGENT_CONNECT', file 'agent_connect_5_Log' on file 1.
Server: Msg 3624, Level 20, State 1, Line 1
Location: pageref.cpp:3889
Expression: pPage->GetLsn () == lp->GetPrevPageLsn ()
SPID: 14
Process ID: 129
Connection Broken
Can't even track the error number down on technet.
Any ideas?
Thanks very much in advance
B.
View 2 Replies
View Related
Jun 6, 2001
We are taking database backup using SQL backup option and trying to restore the database on another server giving the following error
Microsoft SQL-DMO (ODBC SQL state 42000)
The header for file d:power.mdf is not a valid database file header.The page audit property is incorrect.Restore could not start database "power".Backup or restore operation terminated obnormally
Please help
View 2 Replies
View Related
Dec 13, 1999
All,
I have a problem with restore a database.
I have a database 'prod' with 750Mb of data and 250Mb of log.
I create a new database with similar device, but when i try to restore it, i receive this message:
[SQL Server] Read on dump on device ‘D:TEMPackup.DAT’ failed, vsn=756 returns=-2. Please consult the SQL Server error log for more details.
Error 926 :[SQL Server] Database ‘production’ cannot be opened – it is in the middle of a load.
this is the result of Error log:
99/12/13 12:17:14.12 ods Using 'SSNMPN60.DLL' version '6.5.0.0' to listen on '.pipesqlquery'.
99/12/13 12:17:14.98 spid1 Recovery complete.
99/12/13 12:17:15.08 spid1 SQL Server's default sort order is:
99/12/13 12:17:15.08 spid1 'nocase' (ID = 52)
99/12/13 12:17:15.08 spid1 on top of default character set:
99/12/13 12:17:15.08 spid1 'iso_1' (ID = 1)
99/12/13 12:17:15.13 spid1 Launched startup procedure 'sp_sqlregister'
99/12/13 13:07:02.26 kernel initializing virtual device 1, C:prod_data_a15.DAT
99/12/13 13:07:22.43 kernel initializing virtual device 2, C:prod_log_a15.DAT
99/12/13 13:22:00.77 spid13 Trying to read after End of Data
99/12/13 13:27:54.88 spid13 Trying to read after End of Data
99/12/13 13:29:44.38 spid13 Trying to read after End of Data
I use SQL Server6.5 and NT4.0.
The backup has been doing with success by Networker.
Thanks for any help in advance
View 1 Replies
View Related
Nov 23, 2003
Please Help ! Urgent
initially when i started with the database only thing i did was kept backing up the data through dts. option was - device and i kept adding it to the same file. now my machine has crashed . i have installed the new sql server. How DO i Get My data Back . it give error - device activation error path----
restore trminated.
on one machine i got it back but that was the latest one - i want the data i added to the file first time.
Its urgent.
:(
View 4 Replies
View Related
Sep 20, 1999
Hi,
I have a got a error when I tried to restore a SQL Server 6.5 database.
Here is the error:
Error 268: [SQL Server] You cannot run SELECT INTO in this database. The DBO would have to run sp_option to enable this option.
I did turn on the option "Select into/Bulk Copy" using SQL Enterprise Manager but still doesn't work.
Any help would be appreciate.
View 1 Replies
View Related
Dec 8, 2004
I am getting an error when trying to restore a database. The file names and paths look to be correct. The error states that there is insufficient disk space, but the database being restored is 1.4GB and the amount of space on that drive is 17GB, so this should not be an issue. Does any one have any ideas?
Lindsay
View 3 Replies
View Related
Dec 20, 2007
Hi all,
Am new to ms sql server.Am using sql server 2005 on a windows server 2003.Am trying to restore a database from one server to another..so i took the backup of the database to be restored(.bak) and copied it to the other server..when i tried to restore i got the following error..
" TITLE: Microsoft SQL Server Management Studio
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
Too many backup devices specified for backup or restore; only 64 are allowed.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3205) "
How do i go about it?
View 3 Replies
View Related
Jul 20, 2005
Hi,While restoring the log we receive a message after about 30 minutes:Processed 1152109 pages for database 'restest', file 'sales_Log' onfile 1Server: Msg 9004, Leverl 21, State 20, Line 3An error occurred while processing the log for database ' '.It is unclear why the databasename is an empty string, I guess there must besomething corrupt hereo or a bug.These are the steps we followed:- restore database with norecovery (to different database)- restore the log with recoveryThe database stays un-accessable after the restore log, so it seems therewas no recovery done.When I look at the files I see a restest_Log with about the same sizeof the log we try to restore. It is unclear if the restore databaseput this file here, or it is created during the restore log.Someone has a clue?Regards,Rene
View 1 Replies
View Related
Nov 28, 2007
Hi,
I'm trying to do a backup which works fine and then when it gets to the restore it crashes with error message:
Msg 3154, Level 16, State 4, Line 8
The backup set holds a backup of a database other than the existing 'CompsnapTestBackup' database.
Msg 3013, Level 16, State 1, Line 8
RESTORE DATABASE is terminating abnormally.
HERE IS MY CODE:
use master
GO
--BACKUP DATABASE CompsnapTest
--TO DISK= 'C:TestCompsnapTestBackup.bak' ;
--RESTORE FILELISTONLY
--FROM DISK= 'C:TestCompsnapTestBackup.bak' ;
RESTORE DATABASE CompsnapTestBackup
FROM DISK= 'C:TestCompsnapTestBackup.bak'
WITH MOVE 'CompsnapTest_Data' TO 'C:TestTest2CompsnapTestBackup.mdf',
MOVE 'CompsnapTest_Log' TO 'C:TestTest2CompsnapTestBackup.ldf';
GO
thanks,
View 12 Replies
View Related
Aug 8, 2007
Hello,
I'm having a problem restoring a database from Full Backup/Recovery model. The error that I get when I try to restore the database is this, this error comes when it is 70% completed:
TSQL Command:
RESTORE DATABASE [ACT01] FROM DISK = N'C:ACTBackup.bak' WITH continue_after_error, FILE = 1, MOVE N'ACT01' TO N'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLACT01.mdf', MOVE N'ACT01_log' TO N'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLACT01_1.LDF', NOUNLOAD, REPLACE, STATS = 10
GO
Msg 3183, Level 16, State 2, Line 1
RESTORE detected an error on page (0:0) in database "ACT01" as read from the backup set.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
When i change the TSQL to restore verify only i get the following error:
Msg 3242, Level 16, State 2, Line 1
The file on device 'C:ACTBackup.bak' is not a valid Microsoft Tape Format backup set.
Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
Result:
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.
Msg 3242, Level 16, State 2, Line 1
The file on device 'C:ACTBackup.bak' is not a valid Microsoft Tape Format backup set.
Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
I do not have access to the original database, is there anyway to fix this?
View 1 Replies
View Related
Aug 8, 2007
Hello,
I'm having a problem restoring a database from Full Backup/Recovery model. The error that I get when I try to restore the database is this, this error comes when it is 70% completed:
TSQL Command:
RESTORE DATABASE [ACT01] FROM DISK = N'C:ACTBackup.bak' WITH continue_after_error, FILE = 1, MOVE N'ACT01' TO N'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLACT01.mdf', MOVE N'ACT01_log' TO N'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLACT01_1.LDF', NOUNLOAD, REPLACE, STATS = 10
GO
Msg 3183, Level 16, State 2, Line 1
RESTORE detected an error on page (0:0) in database "ACT01" as read from the backup set.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
When i change the TSQL to restore verify only i get the following error:
Msg 3242, Level 16, State 2, Line 1
The file on device 'C:ACTBackup.bak' is not a valid Microsoft Tape Format backup set.
Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
Result:
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.
Msg 3242, Level 16, State 2, Line 1
The file on device 'C:ACTBackup.bak' is not a valid Microsoft Tape Format backup set.
Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
I do not have access to the original database, is there anyway to fix this?
View 4 Replies
View Related
Nov 6, 2007
hi all,
i can't restore backup of me database by sql server managment i will attach the backup up and i hope to help me
http://filaty.com/f/711/985c9d2.hayat.zip.html
http://rapidshare.com/files/67920026/hayat.zip
View 1 Replies
View Related
Jun 13, 2001
We are taking database backup using SQL backup option and trying to restore the database on another server giving the following error
Microsoft SQL-DMO (ODBC SQL state 42000)
The header for file d:power.mdf is not a valid database file header.The page audit property is incorrect.Restore could not start database "power".Backup or restore operation terminated obnormally
The partition on both servers are same and directory structure also same
Please help
View 1 Replies
View Related
Sep 20, 1999
Hi,
When I restore my database on other sqlserver,the system prompted "The database you are attempting to load was dumped under a different sort order ID(42) than the one current running on this server(52),and at least one of them is a non-binary sort order".
How can I do?
Any help will be appreciated!
View 1 Replies
View Related
Aug 15, 2002
I' have several database to restore. I created scripts.
Here is an example:
RESTORE DATABASE DatabaseName FROM DISK = 'C:DatabaseName.bak'
This is the error message:
Server: Msg 3154, Level 16, State 2, Line 2
The backup set holds a backup of a database other than the existing 'CAMS' database.
Any ideas???
Thanks in advance - Vic
View 2 Replies
View Related
Jan 27, 2007
HI,
While restoring a database from a backup file having extension .back we are getting the following error
"back is not part of the multiple family media set backup with format can be used to form a new media set"
Please guide me how to handle this error.
Thanks,
Karthik
View 1 Replies
View Related
Jan 18, 2006
Hello !
I am just few months started to learn SQL server.
I just attempt to restore a database which I have backuped last week.
The following error appears each time when I was trying Restore it from Hard Disk.
Error :
RESTORE DATABASE must be used in single user mode. when trying restore the master database. RESTORE DATABASE is terminating abnormally.
Please help me to restore my database.
View 8 Replies
View Related
Nov 3, 2006
Hi,
I try to restore a backup copy of production database into development database, this is our routine process, which is scheduled every night, at the end of the restore process, development database is set to SIMPLE and log file is truncated. It works fine, but today the process failed because backup file is corrupted, so the database is in loading state, and I used the following restore command to restore database from another good copy of backup file:
restore database devcopy
from disk='c:dev.BAK'
with move 'dev_data' to 'G:DBFilesdevCopy_Data.MDF',
move 'dev_Log' to 'F:DBFILESdevCopy_Log.LDF',
replace
I got an error messge:
Server: Msg 5173, Level 16, State 1, Line 1
Cannot associate files with different databases.
Log file 'F:DBFILESdev_Log.LDF' does not match the primary file. It may be from a different database or the log may have been rebuilt previously.
Processed 4937208 pages for database 'devcopy', file 'dev_Data' on file 1.
Processed 2 pages for database 'svrsprodcopy', file 'dev_Log' on file 1.
RESTORE DATABASE successfully processed 4937210 pages in ... seconds
I do not know what' wrong, but the database is online
Thanks for help
View 6 Replies
View Related
Aug 18, 2006
Hi Team,
I try to restore my local database using the backup from the live server. However I encountered this type of error:
====================================================================
System.Data.SqlClient.SqlError: The path 'C:Microsoft SQL ServerFullTextApplication_FullText' has invalid attributes. It needs to be a directory. It must not be hidden, read-only, or on a removable drive. (Microsoft.SqlServer.Smo)
====================================================================
It worked before I added a full-text search feature. Any idea?
Thanks in advance.
View 15 Replies
View Related
Oct 12, 1999
I'm having a problem restoring from a SQL Server 7.0 backup file.
Here is the SQL statement:
RESTORE DATABASE NewDB
FROM DISK = 'C:ackupMyBackup.bak'
It generates this error:
Server: Msg 3132, Level 16, State 1, Line 2
The RAID set for database 'NewDB' is missing member number 2.
Server: Msg 3013, Level 16, State 1, Line 2
Backup or restore operation terminating abnormally.
The backup was made to a disk file on a Windows 98 machine running Desktop SQL. I'm trying to restore to a WINNT machine, but I don't think this should cause any problems.
The error message is bizarre since I don't have a RAID array on either machine.
I've also tried restoring to the exact same machine that created the backup file but a different DB name and got the same error.
I've tried creating the NewDB database before running the script and tried
using the Restore utility in Enterprise manager with the same results.
I'm stumped. Any Ideas?
View 3 Replies
View Related
Dec 3, 1999
I'm trying to use schedulled task to automate restore and i keep getting the error database in use, it is set to dbo only and single user, and it has me as the user that has the lock, i have tried to kill it but it won't go, i have even started and stopped the server. any ideas?
View 2 Replies
View Related
Apr 13, 2003
Database Restore & Attach Error
I have a problem with restoring or attaching DB files from different version of the engine. I Have a existing SQL server 7.x and another one is SQL 2000 but I try to backup my database and restore it into the 2000 engine This is the following Problem which occurs :-
1st Problem : During Restoration, The restoration process was runing fine until it reach the last inficatior tab and it fail and say Database terminated abnormal. I been try to restore into other machine also but it give me the same problem.
2nd Problem : Say I can't restore but I stop the engine and manual copy the *.mdf and *.ldf to another machine. I try to restore it but it "is on a network device not supported for database files." So what shall I Do with it.
Pls Advise If anything need to be done before I do the restoring and anything need to be done in both 7.x and 2000 Engine.
:confused:
View 1 Replies
View Related
Jul 25, 2006
I moved a sql 2005 report server db from one server to a newer box. I restored the db but I get the following error message
Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
THe ms help was of little use, anyone seen this before
View 3 Replies
View Related
Oct 5, 1998
Whenever I perform a backup or restore I receive the following message:
"A history record could not be written to msdb.sysbackuphistory..."
What can I do to resolve this error?
View 5 Replies
View Related
Oct 5, 1998
Hi SQLGurus,
I have this error isolated in my production environment running SAP/ SQL Server. The options for restoring from database backup
out of question. I tried delete records and dropping the table from SQL Entreprise Manager. when I do DBCC updateusage, it always
encounters this isolated table and stops the DBCC checks. The update statistics and table consistency DBCC checks are running ok.
Table Corrupt: object id does not match between extent in allocation page and Sysindexes; check the following extent: al
loc pg#=4187136 extent#=4187136 object id on extent=12 (object name = sysdepends) object id in Sysindexes=772353966 (ob
ject name = SAPWLSFIDX_OLD) DBCC execution completed. If DBCC printed error messages, see your System Administrator.
I would appreciate any help. Thank you.
View 1 Replies
View Related
Aug 24, 2006
From everything I'm reading, I shouldn't be getting this error in 2005: Too many backup devices specified for backup or restore; only 64 are allowed. RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3205)
I have both SQL Server 2000 and SQL Server 2005 (Express) on same dev box, have loaded SP 4 for 2000, I'm trying to restore this in 2005.
Why am I still getting this error?
Help is appreciated greatly. Thanks.
Sheryl
View 2 Replies
View Related
Feb 11, 2008
hi.. im having a hard time restoring my .bak file.... i have a stored procedure like this.. and every time i call this in my program an error displays... (database in use. the system administrator must have exclusive use ot the database to run the restore procedure)
CREATE PROCEDURE sp_db_restore
AS
RESTORE DATABASE Inventory
FROM DISK = 'C:MSSQL7BACKUPInventory.bak'
WITH MOVE 'Inventory_data' TO 'C:Inventory_data.mdf',
MOVE 'Inventory_log' TO 'C:Inventory_log.ldf',
REPLACE
'can u pls help me wd this.. tnx
View 4 Replies
View Related
Apr 22, 2008
Hi all
i create a setup project with visual studio 2005.
In this project i install cassini, sqlexpress, ajax and my site.
After this i have to restore a database i use for my application.
this is my code:
Server svr = new Server(@".SQLExpress");
Restore res = new Restore();
res.Database = "DbName";
res.Action = RestoreActionType.Database;
res.Devices.AddDevice(Application.StartupPath + @"DbName.bak", DeviceType.File);
.......
if i try to restore it in two machines (XP-Vista) where i have already installed sql server it works fine but when i try to restore it in a virgin machine i have a "Restore failed for Server 'MyServer' " error
So i suppose it's a problem of permission for user or is locked something in sqlexpress while it isn't in sql server
I try to change "Built-in account" in Configuration Manager from Network service to Local System but nothig
someone can help me?
thanks
Marco
View 4 Replies
View Related
Mar 10, 2008
I am trying to restore a database and it errors with Invalid Schema error 954. Does anybody have any ideas?
View 1 Replies
View Related
Jul 31, 2006
Hi all,
I am trying to restore and SQL 2000 database into a new SQL 2005 database. I performed by SQL 2000 backup and created a blank database FERS_Production in SQL 2005. FERS_Production was the original name of the database in the SQL 2000 instance.
I have tried giving the new database the same name as the original and a different name to the original database
(Below is the scripted T-SQL that I get from the DB Admin tool
RESTORE DATABASE [Fers_Production]
FILE = N'FERS_Production_dat',
FILE = N'FERS_Production_log'
FROM DISK = N'D:Microsoft SQL Server (2000)MSSQLBackupFers_ProductionFers_Production_db_200607270206.BAK'
WITH FILE = 1,
NOUNLOAD,
REPLACE,
STATS = 10
GO
When I run this I get the following error.
Msg 3154, Level 16, State 4, Line 1
The backup set holds a backup of a database other than the existing 'Fers_Production' database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Other searches I have performed trying to fix this problem have said to use the REPLACE clause with the RESTORE DATABASE command, but as you can see I am doing that.
Also I no longer have SQL 2000 installed so I cannot try to do a DTS copy which was another suggestion I came across.
Any help is much appriciated, many thanks
Derek
View 17 Replies
View Related
Jan 15, 2007
Dear All,
SQL : SQL Express 2005
I having a problem when trying to restore a database. there were around 10 databases, but one is giving the following error and restore fails, will be great if someone helps..
I also tried taking the backup to another site having SQL 2005 Standard edition, the same error comes.
-----
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server '.SQL2K5'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
An inconsistency was detected during an internal operation. Please contact technical support. Reference number 8. (Microsoft SQL Server, Error: 5243)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=5243&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I also installed Service Pack, no luck..HELP!!!
View 2 Replies
View Related
