SQL SERVER 2000 Legato Tape Recovery

Sep 25, 2007



I have SQL Server 2000 Standard Version backups going to Disk then we have Legato Networker Software to make backups of these backup directories to TAPE.

When we retrieve the file from the TAPE and use to recover the database we get the following errors: (Notice some work and some do not. This is from command 'restore verifyonly from disk='

Server: Msg 3242, Level 16, State 2, Line 1
The file on device '\backupfilersqlbackupsqlserver
ecovered_iis_mainsqlbackupsqlserveriss_mainiss_main_tlog_200709210130.TRN' is not a valid Microsoft Tape Format backup set.
Server: Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
The backup set is valid.
The backup set is valid.
Server: Msg 3242, Level 16, State 1, Line 4
The file on device '\backupfilersqlbackupsqlserver
ecovered_iis_mainsqlbackupsqlserveriss_mainiss_main_tlog_200709180130.TRN' is not a valid Microsoft Tape Format backup set.
Server: Msg 3013, Level 16, State 1, Line 4
VERIFY DATABASE is terminating abnormally.
The backup set is valid.
The backup set is valid.

If I take the original backup file that are on disk they are all valid.

Thanks for any help that can lead me to the solution

Mike

View 8 Replies


ADVERTISEMENT

Tape Backup Recovery Time

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

SQL Server 2000 Does Not See Tape Drive

Mar 23, 2007

We are currently trying to restore a copy of our production database to a different server. Unfortunately SQL does not see the tape drives and we are not able to add them. The tape drives are installed and visible in device manager. I have updated all drivers and firmware but still no luck. Any ideas would be appreciated. Thanks

View 1 Replies View Related

SQL Server 2000 Tape Backup Error

Jul 24, 2006

I have schedule backup job from SQL Server 2000 to Tape. Each Jobs consist of 4 steps which backup different database.

Sometimes I encounter problem. The Message is

Executed as user:dbo. The file on device '\.Tape0' is not a valid Microsoft Tape Format backup set. [SQLSTATE 42000] (Error 3242) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.

There is no problem at the command, as it will run normally when i manually trigger the schedule job. Sometimes the error occur only after few days the job run.

View 6 Replies View Related

Backing Up The SQL Server 2000 Database Using Tape Drives

Jun 9, 2006

Dear sir/madam,

I am from NTU, Singapore and we have a windows 2003 server edition installed on a DELL server and it also runs MS SQL server 2000 for a project of ours. We have installed a HP tape drive on the dell server and it works fine if ntbackup is used at the command prompt but then the SQL enterprise manager does not recognize the tape drive and backing up of our database is of high priority as it contains sensitive information. But the tape drive is installed properly as the device manager does not show any error and ntbackup also recognizes it. I cant seem to figure out why SQL server 2000 cannot recognize it. It would be very helpful if you could kindly guide me on this issue.

Thanking you

Regards

Lavanya Janardhanan



View 1 Replies View Related

SQL 2000 Backup On DLT Tape

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

SQL 2000 Tape Backup Fail

Jul 20, 2005

Environment: Win Server 2003 Standard Version, SQL Server 2000, HPDDS3 Tape(local).Backup procedure:1. open SQL Server Enterprise Manager2. find the database i want to backup3. right click and select "All Tasks"-"Backup Databse..."4. Select "destination"-"backup to"-->>"Tape"5. Click "Add", Select "Tape" device name(or may address)"\.Tape0"6. Click "OK" begin to backupError:system prompt:The file on device '\.Tape0' is not a valid Microsoft Tape Formatbackup set. BACKUP DATABSE is terminating abormally.On this SAME server, using the same TAPE, but USE Tapeware(a HP backupsoftware come with HP tape machine) to back file, everything is OK.I don't have any clue about this. am new to Windwos, new to SQLserver. Any body could show me light? Thanks in advance.A.Y. From shanghai/China

View 6 Replies View Related

Recovery Of A Table From SQL SERVER 2000

Jul 28, 2007

Unfortunately a table is Deleted by me from my database.
Now How I can Recover that
I have no data and structure of that table Now.
It Was Very IMP. Table .
So Plz Help.......

View 8 Replies View Related

Legato/SQL Failover Question.

Dec 13, 2004

Question(s):
If you are using Legato to mirror your database server are you running any specialized scripts against the system tables at failover time? Are you running any kind of script at failover?

Background:
We are using Legato to mirror several of our critical database servers and it’s really worked well for us but a situation occurred last week that causes me some concern and I’d like to know what other Legator users are doing.

Normally our failovers are for short durations, a few hours at most. This time the failover occurred over several days. I found that any job that executed a step with a DTS package was failing.

It seems that there’s a documented issue from Microsoft, that when the originating_server column in the sysjobs table contained a value other than the name of the current server, the job fails. The fix was simple. I changed the originating_server name to the current server and all was well. When we went back to the primary server, I changed the value back again.

This brings me to the question about any special scripts or processes that you may be running at failover time. Any information you share is greatly appreciated.

Sidney Ives
Database Administrator
Sentara Healthcare

View 1 Replies View Related

Disaster Recovery: SQL Server 2000 On Win 2000 Server.

Sep 13, 2007

This past Monday, our Raid 5 array failed on our SQL 2000 server (standard edition). Long story short, we were able to get the data back, mostly. In SQL server Ent. Mgr., I had to restore 4 databases that were 'Suspect' and "greyed out". No problems there... I was able to restore them.

What was interesting was that the SQL Server Agent would not start. As it turned out, a few files were either corrupt or missing after we got the machine back up. We had to restore a few files from tape backup and now the SQL Server Agent starts... but now I have a new problem.

For some reason, my default SQL Server Agent "Job" that is scheduled to run once per day fails. It appears that all of the databases get backed up, but for some reason, the msdbdata.mdf database is NOT being backed up.

I have a few questions. Could my msdbdata.mdf be corrupt? I have a successful backup of the msdbdata.mdf table from 9/10/2007. Can I just restore from that? Will there be any repercussions to any of the other database tables if I do?

Furthermore, should I just restore the msdbdata.mdf, master.mdf and the model.mdf? I really have no idea what these tables do and the repercussions of modifying them. I am not a DBA (obviously) and I just don't want to make an mistakes.

Thanks, CFDev.

View 5 Replies View Related

SQL 2000 Test Server Database Recovery Bombed

Feb 3, 2008

I am a SQL lightweight and I tried to update the data on the test SQL server with the data on the production server and now the test SQL server won't start.

I was trying to move a sql database from our production server to our test server and things got mucked up. I think where I went wrong is that I tried to backup the database on the Production server and then restore it to the test server. I think I should have backup the production server and then detached the databases from the test server and then attached the backups. I got in a hurry and had an attitude that SQL is so good that if I mess up, I can recover.

These are the databases I recovered to test server:

Builder
CSales
CIB
Master
Model
MSDBdata

Now SQL server won€™t start and I get the error message that the database Model is in the middle of being restored. We are on SQL 2000. I tried to start from a command line with the €“f switch and it still can€™t come up.

Should I reinstall SQL and then attach the databases?

Do I need to bring over the Master, Model and MSDBdata data bases from the production servers.

View 7 Replies View Related

SQL 2000 Server, Need Help Creating Documentation/disaster Recovery Plan...

Sep 27, 2006

I currently work for a company that has had a "family business" mentality for many years. The only trouble is, it has grown into a fairly large company over the years and that mentality just doesn't cut it anymore (We have around 200 employees in 2 offices, and 25-50 remote users).

I have recently taken over the role of System Administrator, and I'm having a lot of trouble trying to get everything under wraps. There are a LOT of un-documented things happening with our database/web server, and in order to keep things safe & secure, I need to try & flesh out what those mystery settings would be. I feel that NOW is the time to get some solid documentation down, to protect my ass before some critical failure happens.

I'm wading into unknown waters here, and I'm hoping that somebody who's "been there" might have some tips to make my life a little easier.

I have an IBM Bladecenter, and a spare blade with which I can use to re-produce as close to a mirror copy of our system as possible. I have installed windows 2003 /w SQL2000 and restored a full backup of our databases and imported all database user accounts, and logins. What about Maintenance Jobs? Error Logs? Patches/Hotfixes? Service accounts? Membership roles? System databases? ODBC Sources? Services? Startup Scripts? I'm sure the list could go on & on... What are some of the crucial details I should look into?

Has anybody been in this boat before having little knowledge of what was built before you arrived, and have any insight on how to get through this without too much headache?

View 5 Replies View Related

FAQ: Are There Any Whitepapers About Building A Disaster Recovery Site At A Remote Location For SQL Server 2000

Sep 9, 2006

Hi,

Sorry for the wide distribution.

I'm trying to find any useful whitepapers about how to effectively build and operate a disaster recovery site at a remote location for SQL Server 2000. Does anyone know where to find such information?

I also know that one good option for my customer is using the Mirroring feature of SQL Server 2005. What are the other options? Is Replication an effective one for a mission-critical database (online banking)?

Thanks in advance

View 3 Replies View Related

Recovery :: Server Local High Availability Using Failover Cluster And Disaster Recovery Using AlwaysOn

Aug 17, 2015

We have a requirement to build SQL environment which will give us local high availability and disaster recovery to second site. We have two sites- Site A & Site B. We are planning to have two nodes at Site A and 2 nodes at Site B. All four nodes will be part of same Windows failover cluster. We will build two SQL Cluster, InstanceA will be clustered between the nodes at Site A Server and InstanceB will be clustered between the nodes at Site B, we will enable Always On Between the InstanceA and InstanceB and will be primary owner where data will be written on InstanceA and will be replicated to InstaceB. URL....Now we want we will have instanceC on the Site B and data will be writen from the application available on Site B, will be replicated to the instance on the Site A as replica.

View 6 Replies View Related

SQL Server Admin 2014 :: Is Bulk Logged Recovery Model Support Point In Time Recovery

Dec 23, 2014

is bulk logged recovery model support point in time recovery

View 9 Replies View Related

Server Back Up From Tape,emergency Help

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

Remote Tape Backup Device On SQL Server

Aug 7, 1998

Does anyone know if it is possible to have a tape device another server as a tape dump device on SQL. Instead on removing the tape drive and installing it locally ?!?

Regards

Jasper

View 2 Replies View Related

SQL Server 2005 Log Shipping And 3rd Party Tape Backups

May 27, 2008

Hello,

I would like to know if anyone has a recommended method for having backups to tape while running log shipping. For example, is it possible to copy the transaction log backups used for log shipping to tape and apply them to a Full Database Restore from a 3rd Party Backup tool such as Veritas?

My goal is to be able to do a point-in-time restore from tape and still be able to use SQL Server 2005 Log Shipping.

Thanks,

Erik

View 1 Replies View Related

Recovery Model Code In SQL 2000

Jun 13, 2007

In SQL 2005, sys.databases has a column named recovery_model that stores a code for the type of recovery model used by the database. Where is the recovery_model column in the SQL 2000 master database?



Thanks,

Craig

View 1 Replies View Related

Will Rebooting The SQLServer 2000,Is It Change Recovery Model Of MSDB Database

Apr 3, 2008

Hi All

Will Rebooting the SQLServer 2000,Is it change recovery model of MSDB Database
Please help...

View 6 Replies View Related

Recovery :: Pages On A Full Recovery Model Database Corrupted

Sep 17, 2015

Pages on a full recovery model database corrupted, need to ensure data loss is minimal for restore operation am thinking about restoring the latest full backup.

View 4 Replies View Related

Transact SQL :: Change Db In Recovery To No-recovery And Restore Transaction Log?

May 5, 2015

in the process of migrating a big db from server 1 to server 2, we had to roll back the change. I started with taking a full db backup and restoring it on server 2 with norecovery, and then a couple logs with norecovery, and then the last log with recovery.

Is there some way to continue this chain now, I mean to change the db to norecovery, or other way to restore logs. 

I dont want to do a new full backup.

If I try to do a log restore now i get the message:

Msg 3117, Level 16, State 4, Line 1

The log or differential backup cannot be restored because no files are ready to rollforward.

Msg 3013, Level 16, State 1, Line 1

RESTORE LOG is terminating abnormally.

View 6 Replies View Related

Recovery :: AG Databases Went Into Synchronizing / In Recovery After Upgrading To 2014

Sep 19, 2015

We have 3 replica AG setup. 2 replicas are in sync/automatic failover, the other(DR Server, different subnet) in asynchronous/manual mode…All these replicas were on sql server 2012, Recently we upgraded DR server to 2014. Since then we have a problem, the AG databases in 2014 instance went into ‘Synchronizing/ in recovery’ state…The SQL server error log has message, the recovery couldn’t start for the database ‘XYZ’…We tried to create a new database and add it to AG , it works for fine for other two 2012 replicas, but on 2014 we see the same issue

View 3 Replies View Related

Recovery :: AG Database In Reverting / In Recovery State

Nov 1, 2015

We have an issue with a 3 node SQL 2012 Always on availability group. Normal operation is node 1 (primary replica) with node 2 and node 3 as secondary replicas.After some patching, SQL wasn't running on node 1 hence the AG flipped over to node 2. This went unnoticed for some time and the transaction log for one of the AG databases became full on node 2 and node 3. (I think this is because it couldn't commit the transactions on node 1 so couldn't truncate it's t-log?) The DB is using synchronous replication btw.So I started SQL on node 1 and flipped the AG back to node 1 (with a data loss warning but I accepted this).Now the issue is that on node 2 and 3, the DB in question is stuck in a "Reverting / In Recovery" State. I've tried various commands such as ALTER DATABASE SET ONLINE, RESTORE DATABASE WITH RECOVERY etc but these fail stating unable to obtain a lock on the DB.

The weird thing is that on node 1 the state of the DB is "synchronised".how to resolve this issue on node 2 and 3? I've left them overnight (in case they were rolling back transactions, the DB is fairly large) but nothing seems to have happened. remove the DB from the AG in node 2 and 3 and add it back in again, ie recreate the replication?

View 2 Replies View Related

Recovery :: How To Do A Full Disaster Recovery

Sep 10, 2015

If you are doing a disaster recovery of an entire SQL 2005 cluster, can you just install SQL server and restore the system database to get the configuration?

View 4 Replies View Related

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 View Related

Tape Backup

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

Can't Restore DB From DAT Tape

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

What Data Tape In SQL Allows 98.3 Or 103.4

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

Restoring A Database From Tape

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

Tape Backup Problem

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

Backup And Copy To Tape

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

Multiple DB Backups To One Tape. How?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved