Backing Up To A Tape Drive

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


ADVERTISEMENT

Skipped Folders When Backing Up SQL To Tape.

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

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

Tape Drive Issue

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

Tape Drive Not Detected

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

Unable To Backup To Tape Drive

Dec 17, 2007

i have taken full database backup on tape drive one week ago,by automated scripts ,now when i check the maintenance plan history , it says the task failed and gives a message that unable to open the \. ape0 ,with error


([Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device '\. ape0'. Device error or device off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.
)

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

Need To Know The Actual Size On The Tape Drive

Aug 16, 2007

Need to know the actual size on the tape drive

I€™m using LTO3 tape drive (400GB) the used media is for LTO2, currently I€™m looking for LTO4(1.6TB) but I need the backward compatibility to support LTO3 tapes so I can go for LTO2 media or LTO3 media.

I need to know the size of the database backup (Ms SQL2005 SP1 x64-bit, on Ms Windows 2003 R2 x64-bit) on the tape drive. I can see the backup size of the database but not the size on the tape which is using hardware compression.

Is there a way or a tool to view that.

View 4 Replies View Related

Would You Please Suggest A Good Backup Tape Drive?

Jul 23, 2005

First posting to the group. I have received a lot of valuable info from youguys. Now, an OT question:What's a good tape drive to perform unmanned weekly backups for a WindowsXP Pro box running SQL server 2000?--Joel Farris | AIM: FarrisJoel** Their Web. Your Way. http://getfirefox.com **

View 1 Replies View Related

Backing Up To Network Drive Without Trust

Oct 23, 1998

I need to know if there is a way to perform a SQL Server 6.5 backup to a remote network drive WITHOUT USING A TRUST LOGIN.

My network administrator refuses to put a TRUST relation on the Primary Domain Controller. I`m not really sure why, but I need a workaround.

Thanks,

"Work-around Bob"

View 1 Replies View Related

Backing Up To A Non-local Drive/location

Dec 19, 2007

I've been working with SQL Server for a few years now and I've had quite a few cases where users cannot backup SQL to a network location or external hard drive. Why can SQL not do this? Is it some limitation of the speeds at which SQL needs to backup the information and the external hard drives/network drives do not meet the requirements?

View 8 Replies View Related

Backing Up Data To Network Drive Mapped

Aug 6, 2003

I am new to the DB Administration.

How do i back up the data to a network drive mapped on a day to day basis.

View 4 Replies View Related

HELP. Back Up Problem When Backing Up To A Mapped Drive On Another Server

Mar 20, 2002

Hi,

I have a rather odd problem that hopefully you'll be able to shed some light on.

We want to back up the databases to a hard drive held on another server so I mapped the drive in explorer to the drive then went into Enterprise manager and tried to create a backup device and it won't see the mapped drive.

I've tried mapping to my PC and I can see that via enterprise managers backup stuff (infact any PC in the office works) but it won't see any of the servers even though we can map to them and access them via windows explorer.

I've tried when logged on via sa and the windows NT administrator and still no luck. In fact no matter what I type or do it fails and keeps telling me device error or device off line which it isn't.

On our test instance of SQL Sever we can backup to other servers but not the new live version!

Any thoughts on what might cause this to happen and how to fix it?

Help much appriciated.
Thanks Helen

View 1 Replies View Related

HELP. Back Up Problem When Backing Up To A Mapped Drive On Another Server

Mar 20, 2002

Hi,

I have a rather odd problem that hopefully you'll be able to shed some light on.

We want to back up the databases to a hard drive held on another server so I mapped the drive in explorer to the drive then went into Enterprise manager and tried to create a backup device and it won't see the mapped drive.

I've tried mapping to my PC and I can see that via enterprise managers backup stuff (infact any PC in the office works) but it won't see any of the servers even though we can map to them and access them via windows explorer.

I've tried when logged on via sa and the windows NT administrator and still no luck. In fact no matter what I type or do it fails and keeps telling me device error or device off line which it isn't.

On our test instance of SQL Sever we can backup to other servers but not the new live version!

Any thoughts on what might cause this to happen and how to fix it?

Help much appriciated.
Thanks Helen

View 1 Replies View Related

Can I Used A Shared Drive Rather Than A Mapped Drive With OpenRowSet?

Apr 4, 2008



Hi

I have been trying to use openrowset with a shared drive, and even though the share has "full control" permissions granted to "everyone" and the accout that SQL runs under has been granted explicit full control permissions I am unable to open the file which itself has no security on it.

Can I not use a \ path and only use mapped drives?

Thanks

below works...

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:5People.xls', [Sheet1$])

below doesn't work...

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=\cluster02FileManager5People.xls', [Sheet1$])

View 3 Replies View Related

How To Move A Log File From 'e' Drive To 'f' Drive....

Nov 9, 2000

I am trying to move a log file from one drive to another.

What I have done is add another file to my file group. So now my log has a file on the 'e' drive and one on the 'f' drive. I now want to remove the file on the 'e' drive. I have emptied the file on the 'e' drive. When doing the command:

ALTER DATABASE Uniprodruntime
REMOVE FILE m_rk_runtime_log

I get the following error message..

Server: Msg 5020, Level 16, State 1, Line 1
The primary data or log file cannot be removed from a database.

I have also gone into enterprise manager and tried to delete the file and it does nothing.

Has anyone run into this?

View 2 Replies View Related

SAN Drive Speed Vs Local Drive

Feb 12, 2007

How do you compare SAN drive vs local drive on a 32 bit server?

Is it good idea to move my DB files to a SAN instead of local?

Canada DBA

View 4 Replies View Related

TempDB Keeps Getting Filled And It Is In C Drive But It Should Be In T Drive

Nov 28, 2015

Server: SQL 2008 R2

 1: TempDB keeps getting filled.  Restart of the server has not fixed it. I shrink it, but the space gets filled again. Now I can't even shrink it anymore
2: TempDB is at the wrong location. Its current location is this :C:Program FilesMicrosoft SQL ServerMSSQL10_50.SQLPROD6MSSQLDATA empdb

How do I change its location? 

C:Program FilesMicrosoft SQL ServerMSSQL10_50.SQLPROD6MSSQLDATA empdb
Correct location of TempDB should be: TempDB(T:) But its not there

View 13 Replies View Related

Moving A SQL Server 2000 Database From A Local Drive To Another Local Drive

Jan 31, 2008

Being a very novice SQL Server administrator, I need to ask the experts a question.

How do I go about moving a database from 1 drive to another? The source drive (C is local to the server, but the target drive (E is on a Storage Area Network (SAN), although it is still a local drive for the server. I want to move the database from C: to E:. Can someone provide me with instructions?

Thanks,
Rick

View 4 Replies View Related

SQL 2012 :: How To Backup Half Of DBs From A Server On C Drive And Other Half On D Drive

Jan 16, 2015

How to backup half of dbs from a server on C drive and the other half on D drive and vice versa, first half on D drive and other half On C drive using only one job and one stored procedure??

Using scheduling from job add 2 schedules to the job so first schedule backup first half to C and second half to D , the second schedule backup first half to D and second half to D.

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

SQL 7 IDE Tape Backup Won't Work

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

Check If Tape Is In Device

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

Sp_help_revdatabase / Tape Backups

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

Backup To Tape Fails Sometimes

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

Tape Backup Device Not Seen In EM

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







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