Tape Restore Help....
Dec 17, 1999
hi,
We have a service provider that handles the SQL database for us. And every month we will receive a Tape backup of the updated database from them for in house development purpose.
Anyways, I tried to restore the Tape backup I recently received and I kept on getting this error message: "The media family on device 'Tape0' is incorrectly formed. SQL Server cannot process this media family. Backup or resotre operation terminating abnormally."
I have set the Complete Database backup and the Overwrite option for this particular restore. Please help, any idea is apperciated.
Thanks,
Ray
View 1 Replies
ADVERTISEMENT
Oct 30, 1998
Just for background info: I am trying to take a backup of a DB made from a Server(#1) located on a client site and restore to a server that is in house Server(#2). Both servers are running SQL Server 6.5 and all configuration settings are the same except Server(#1) has (DB Lib Ver 6.50.213) and Server(#2) has (DB Lib Ver 6.50.201).
When I try to restore the DAT tape (backup made from Server #1) onto Server #2 I get these errors in this order:
1st --[DB-Library] Unexpected EOF from SQL Server. Connection broken.--
2nd --Error 605 [SQL Server] Attempt to fetch logical page 72915 in database 'DBname' belongs to object '0', not to object 'sysobjects'.--
Does anybody have any ideas and what could be causing these errors?
Would the different DB-Library versions cause these errors?
I know the tape isn't corrupt because the tape can be used to restore on Server(#1).
Any ideas would be greatly appreciated!
View 1 Replies
View Related
Feb 24, 2000
Hi
I have two database called test1 and test2 both are of same size(both device and log). I run the following statements to take the backup of both the databases using the tape device 'tapedevice1'. dump database test1 to 'tapedevice1'
dump database test2 to 'tapedevice1'
After this I run the load statement
load database test2 from 'tapedevice1'.
It just restore the database test2 with test1 data which is added first to the tape with a warning.
Is there any restriction that in a single tape backup of more than one database is not possible.
Your valuable suggestion appreciated
Jiji
View 1 Replies
View Related
Jul 6, 2007
I'm trying to test my backups by restoring from production onto a DEV machine.
However, when I insert the backup tape into the drive, then go into SSMS and right click on
Databases -> Restore Database -> From Device .... -> Tape -> Add -> (my tape drive \.Tape0) -> Contents
it displays the contents as it should.
So I click "Close" to close the contents and bring me back to the Specify Backup where I have \.Tape0 selected and I then click "OK"
SSMS sits for a few seconds, and then I get a time out error message:
TITLE: Microsoft SQL Server Management Studio
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
That's all the further I can get... any suggestions?
I'm VERY perplexed by this...
View 2 Replies
View Related
Apr 11, 2007
I backup the database into tape0 using management studio and can see the contents in the backup media.
However when I tried to restore, the error "timeout expired" appears and sometimes together with the error "restore headeronly is terminated abnormally".
Please advice and thank you in advance!
Below is the error message:
===================================
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteWithResults(String query)
at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSqlWithResults(Server server, String cmd)
at Microsoft.SqlServer.Management.Smo.Restore.ReadBackupHeader(Server srv)
at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.buttonSelectDevice_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
===================================
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (.Net SqlClient Data Provider)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476
------------------------------
Server Name: NTSRV1
Error Number: -2
Severity: 11
State: 0
------------------------------
Program Location:
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected)
at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand)
View 3 Replies
View Related
Jul 6, 2007
I'm trying to test my backups by restoring from production onto a DEV machine.
However, when I insert the backup tape into the drive, then go into SSMS and right click on
Databases -> Restore Database -> From Device .... -> Tape -> Add -> (my tape drive \.Tape0) -> Contents
it displays the contents as it should.
So I click "Close" to close the contents and bring me back to the Specify Backup where I have \.Tape0 selected and I then click "OK"
SSMS sits for a few seconds, and then I get a time out error message:
TITLE: Microsoft SQL Server Management Studio
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
That's all the further I can get... any suggestions?
I'm VERY perplexed by this...
View 11 Replies
View Related
Apr 24, 2000
Hi,
Does Any one know How to find out How much space left in a Tape Drive?
Is it possible with Win nt OR Win 2000?
or It required some special utility.
Any one know please suggest,
Thanks
Nil.
View 2 Replies
View Related
Oct 26, 2006
I want to store 98.3, 0.4 or 103.4 like numbers in a SQL database, but I'm having a hard time selecting the correct data type. Also what should be the precision and scale. What is a precision and scale? Please help......
int
varchar
decimal
numeric
View 13 Replies
View Related
Apr 19, 2001
Does anyone know if it is at all possible to restore a single database from tape if no backup jobs have been ran or setup for this database. However, the server itself has been backuped to tape. So I would like to restore this database from the server tape backup. If so, how do I accomplish this?
View 1 Replies
View Related
Apr 18, 2000
Hi
I Have 8 small databases around 10 to 30 MB each.
I am taking tape backup. Full database backup Daily.
Now problem i am facing that i am not able to schedule this process because
when it complete one database backup, tape automatically come out. So
due to this reason i am not able to schdule this job.
If any one has solution for this please suggest.
Thanks.
Nil.
View 1 Replies
View Related
Jan 9, 2001
Hello,
I need to backup the database to file and then copy it to Tape. Can anyone guide me how I should do it. I need to automate it.
Thanks.
Rea
View 2 Replies
View Related
Oct 30, 2000
Perhaps this maybe a silly simple questions SCENERIO: Say i want to make a nightly backup of the Masterdb and the same for a user database. One that kicks off at 8 and the other at 9. For soem reason I am having difficult time with this..
Some help please??
View 1 Replies
View Related
Nov 4, 1999
We have Dell Optiplex GX1 PCs with Seagate ST22000 IDE tape backup devices, running NT Workstation or NT Server and SQL 7.0 with SP1, NTSP5.
SQL 6.5 will backup successfully to these devices, but SQL 7.0 will not.
The most common error message is 18257, Device or media does not support ...
42000 Syntax error, permission violation, or other nonspecific error...
View 3 Replies
View Related
Sep 9, 1998
Is there a way to check if a tape drive contains a tape? I would like
to check this prior to doing an incremental transaction log dump...
ben
View 1 Replies
View Related
Mar 3, 1999
I have a COTS database on MSSQL 6.5, no service packs...
I used sp_help_revdatabase to create the same database on a different server, using the same data and log device sizes and paths. I scripted the database, tables, stored procedures, and user defined datatypes, created them on the new server, and tried to restore a tape dump from the previous server to the new database. It would say "restoring", but then "DBLibrary is dead or connection broken", when I click OK to this message, it sais "restore complete" then the database appears grayed out and reads "loading".
View 1 Replies
View Related
Jul 2, 2001
I am trying to backup a database to a tape. It works when it wants to. I get a 3013 error. The drive is fully functional. Seagate backup works fine. SQL Backup does not. I think it might be that the tape needs retensioning sometimes. Here is the sql statement: BACKUP DATABASE pubs TO TAPE='.ape0' WITH FORMAT. Is there a retension parameter I am failing to see?
View 2 Replies
View Related
Jan 13, 2005
Hi Folks,
I have a SQL Server 7.0 with and exteranl SCSI tape device.
When I attempt to backup a database in EM the tape device is being greyed out.
I have add the backup device using sp_dumpdevice and made sure that it is in sysdevices table. It will not allow me to add this backup device from the drop down.
1. Why does EM not see this device ?
2. If I try to back this up using T-SQL will I be able to use the registared tape device.
Thanks Folks
View 2 Replies
View Related
May 17, 2007
I want to create a backup device for the tape drive.
So I go in "Server Objects"=>"Backup Devices" and create a new device. Problem is: In "Destination" I can't select "Tape:".
The ntbackup.exe program recognizes the tape drive, but SQL2005 not.
I have this:
-SQL2005 Enterprise edition 64bit.
-Tape drive HP StorageWorks Ultrium 960.
Someone knows how I can create a backupdevice for the tape?
Thanks
IF Debugging = removing bugs from program THEN programming := putting bugs in program;
View 4 Replies
View Related
Jan 24, 2008
i have a tape drive where i backup database every weekends, and i have a tape which shows that set created and size column displays -0 bytes. what does that mean , i also want to know how much space is left in the tape drive so that i can backup accordingly
Please help me out for this issue
View 1 Replies
View Related
Feb 5, 2008
I have a SQL 2005 Server (SP1) running on Windows 2003 server machine. Now windows can detect the tape drive attached to the system as 'HP StorageWorks DLT VS160'. Even 'ntbackup' detects it and is able to backup data to the tape drive. However, SQL Server is unable to detect the tape drive. The tape does not show up in the Backup Devices in Server Objects and hence I'm unable to take backups directly to the tape via SQL Server. How do I get SQL 2005 to recognize the tape drive?
View 5 Replies
View Related
Jul 20, 2005
HiWe are running SQL 2000 Enterprice version with SP3a on a DellPoweedge 5600 server running Advance Server. It has Tape drivePowerVault 110T (DLT VS80 Tape Drive) & uses DLT tapeIV tapes. A DBmaintenance job had been specified to backup on to tape daily. I havefollowing issues;1.The backup job sometimes fails with the following error in Eventlog(Event ID:17055)3041: Backup failed to complete the command BACKUP DATABASE [UNIQRS]TO TAPE = N"\.Tape0 WITH NOINIT, NOUNLOAD, NOSKIP, STATS = 10,NOFORMAT. The job is specified with the Verification option.2. If I try to restore a succeeded backup it asks for a initial tapewith a past date which does not exists3. Is there a way to view the content of the tape & free space etc.4. It is recommended to put a disk backup & transfer it to tape usingWindows backup utility. Is there a way to automate this by initiatingthe Backup utility when the SQL finishes the disk backup.ThanksChirath
View 2 Replies
View Related
Mar 9, 2007
I am setting up a new SQL Server that has an external HP 920 SAS Ultrium tape drive attached to it via a p400 sas card.
I am running 2003 R2 x64 with 2005 SQL Server x64, and I am trying to set up my DB backup plan but for some reason I can't get SQL to recognize my tape drive, alhough it is listed in device manager.
Anyone have any thoughts? I'm kind of stumped.
Thanks in advance,
Mark.
View 5 Replies
View Related
Nov 7, 2006
I've got a new HP ML370 G4 Server 2003 SP1 with a fresh install of SQL 2005 SP1. I'm trying to create a backup device for the internal HP DAT 40 and tape is greyed out as an option. I have the newest HP software drivers and firmware. The tape drive is seen by Server 2003 device manager and by NTBACKUP. I can backup using that program. Why doesn't SQL 2005 see it? I tried a new HP Ultrium tape drive with the same results. Anyone else see this and can recommend a fix? TIA
View 11 Replies
View Related
Aug 29, 2007
Hello,
I am trying to configure the backup device on SQL Server 2005.
I cannot get the Tape device list.
The Tape Device is attached physicaly to the server ! (IBM Ultrium-TD3 scsi). I can 'see' the device using Windows Backup; but I cannot even get the list of tapes on SQL Server.
Can you please give me some help on this one ?!
Thank you all.
Youss
View 6 Replies
View Related
Jan 19, 2007
Hello,
TSQL command works fine,
C:SQLCMD
1> BACKUP DATABASE TestDB TO TAPE = '\.Tape0'
2> GO
but how to append more than one databases( SQL 2005) to the same tape.
Having said this, what is the solution for " I've got a new HP ML370 G4 Server 2003 SP1 with a fresh install of SQL 2005 SP1. I'm trying to create a backup device for the internal HP DAT 40 and tape is greyed out as an option .........." Pls advice me.
View 1 Replies
View Related
Nov 28, 2007
Hello!
Me and my collegues was recently assigned to maintain a SQL Server 2000 instance, which pretty much only holds one database.
From what we can tell, a backup of this database has never been created, atleast not through SQL Server.
When asking the previous owner, the answer was "We have been taking 'Legato backups' every day!"
We now intend to schedule a SQL Server backup job, but out of curiosity...
In case of a disaster, would these "Legato backups" have been any use at all?
Please elaborate :-)
View 5 Replies
View Related
Mar 7, 2000
Is it possible to switch back to SQL 6.5 after upgrading to SQL 7.0 using the tape method? During the tape upgrade the 6.x devices are deleted. Is there no backout plan?
View 1 Replies
View Related
Jan 13, 2000
Hi,
How do we know that tape backups is working. And how do we know what is on them.
dindu
View 1 Replies
View Related
Nov 7, 2001
My company is using backup exec to bacup all servers and when it came to this particular server these backups were skipped. I checked the log files and backups that are ran within SQL. Can someone explain to me what may have caused this. My guess is that there was something with the media that was trying to backup this server. Thanks for all of you help.
Below is the error message that was recieved after backup exec attempted to backup up this server.
Media Name: "DIFF"
Backup of "SQLserver1E$ "
Backup set #49 on storage media #1
Backup set description: "Daily 5"
Backup Type: DIFFERENTIAL - Changed Files
Backup started on 11/05/2001 at 11:46:00 PM.
The item MSSQL7Datadatabase1_Data.MDF in use - skipped.
The item MSSQL7Datadatabase1_Log.LDF in use - skipped.
The item MSSQL7Datadatabase2_Data.MDF in use - skipped.
The item MSSQL7Datadatabase2_Log.LDF in use - skipped.
The item MSSQL7Datamaster.mdf in use - skipped.
The item MSSQL7Datamastlog.ldf in use - skipped.
The item MSSQL7Datamodel.mdf in use - skipped.
The item MSSQL7Datamodellog.ldf in use - skipped.
The item MSSQL7Datamsdbdata.mdf in use - skipped.
The item MSSQL7Datamsdblog.ldf in use - skipped.
The item MSSQL7Dataorthwnd.ldf in use - skipped.
The item MSSQL7Dataorthwnd.mdf in use - skipped.
The item MSSQL7Datapubs.mdf in use - skipped.
The item MSSQL7Datapubs_log.ldf in use - skipped.
The item MSSQL7Datasysdev_Data.MDF in use - skipped.
The item MSSQL7Datasysdev_Log.LDF in use - skipped.
The item MSSQL7DataTEMPDB.MDF in use - skipped.
The item MSSQL7DataTEMPLOG.LDF in use - skipped.
Access denied to directory emp.
^ ^ ^ ^ ^
Backup completed on 11/05/2001 at 11:47:02 PM.
Backed up 55 files in 48 directories.
19 items were skipped.
Processed 84,537,951 bytes in 1 minute and 2 seconds.
View 1 Replies
View Related
Feb 24, 1999
Hi,
we have backups taken regularly on tape device.
When I restore the back up on the same server,it is working.
But if I try to resotre the same backup on a new server it is giving problems
I have the same configuration of the new and old server.
It is giving error 10005 DB process dead and after that the database is marked grey and in bracket (loading)
and a lot of other errors like Begin Stack Trace,
sympton dump created,end stack trace ,etc( A very Long List of errors) and a new dump is created in log directory
It is also telling "EXCEPTION_ACCESS_VIOLATION"
i am having the same problem on all the servers we have.
Help me regarding this.
DP
View 1 Replies
View Related
Jun 28, 2002
Can someone please help in in understanding what I have done wrong. My company is using Backup Exec 7.3 as it's back up application. I have built a server, installed SQL, Built an database and added logins. I am backing up my database and Transact Log Files to specific folders on my partioned drive. Why when I run the backup ups, It backs up everything EXCEPT for my SQL folders. It seems to Skipp all SQL Folders. Please Help, I need to have this funtion working properly. What have I done wrong or what do I need to do to make this stop. Does this perhaps have something to dwil Here is an example of the backup Message in Backup Exec that I am recieving:
Media Name: "DIFF"
Backup of "FEPTESTE$ "
Backup set #41 on storage media #1
Backup set description: "Daily 6"
Backup Type: DIFFERENTIAL - Changed Files
Backup started on 6/28/02 at 12:36:21 AM.
The item Microsoft SQL ServerDataMSSQLDataTESTDB_Data.MDF in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatamaster.mdf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatamastlog.ldf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatamodel.mdf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatamodellog.ldf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatamsdbdata.mdf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatamsdblog.ldf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDataorthwnd.ldf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDataorthwnd.mdf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatapubs.mdf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatapubs_log.ldf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDataempdb.mdf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDataemplog.ldf in use - skipped.
The item Microsoft SQL ServerDataMSSQLLOGTEST_Log.LDF in use - skipped.
Backup completed on 6/28/02 at 12:37:11 AM.
Backed up 48 files in 24 directories.
14 items were skipped.
Processed 23,876,604 bytes in 50 seconds.
Throughput rate: 27.3 MB/min
View 1 Replies
View Related
Jul 28, 2004
How much time does a 20 g tape backup take to recovery
I am on 6.5 sql and have compacq 15/30 gb DLT
How best to configure a standby sqk 2000 server
salim
__________________
View 8 Replies
View Related
Aug 16, 2004
emergency help, our server1 is down, we need to restore everything from tape using server2, but when i put the tape in the server2, it said "unreadble media", what should i do to restore everything? How can the tape to be readble? Thanks, thanks.
View 14 Replies
View Related
