Backing up to Colorado external tape

we've backed up SQL to a "regular" tape drive before, but now I am trying to
use a Colorado (Travan) external parallel port tape drive. Even though the
OS seems to see a tape there, I cannot mount it or make SQL see the tape.
Any ideas of what to do? Thanks.
Hello Neil,
Based on my experience, there is some known issue on certain Travan tape
devices. You may first try to call PSS to get the following hotfix to see
if it helps:
825742 Cannot Back Up Data to a Travan Tape Device Successfully
http://support.microsoft.com/?id=825742
If the issue persists, it is advised that you contact manufacturer of the
device to get their support on this. Hope this is helpful.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| Reply-To: "Neil W." <neilw@.netlib.com>
| From: "Neil W." <neilw@.netlib.com>
| Subject: Backing up to Colorado external tape
| Date: Mon, 31 Jan 2005 16:00:12 -0500
| Lines: 6
| Organization: NetLib
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| Message-ID: <OfJOyg9BFHA.1404@.TK2MSFTNGP11.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: 167.206.228.82
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFT NGP08.phx.gbl!TK2MSFTNGP11
.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376364
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| we've backed up SQL to a "regular" tape drive before, but now I am trying
to
| use a Colorado (Travan) external parallel port tape drive. Even though
the
| OS seems to see a tape there, I cannot mount it or make SQL see the tape.
| Any ideas of what to do? Thanks.
|
|
|
|||Thanks for the tip - but I am using Windows 2000. The included backup
program works fine - it is just that sql does not recognize that a tape is
mounted.
___________________
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
Hello Neil,
Based on my experience, there is some known issue on certain Travan tape
devices. You may first try to call PSS to get the following hotfix to see
if it helps:
825742 Cannot Back Up Data to a Travan Tape Device Successfully
http://support.microsoft.com/?id=825742
If the issue persists, it is advised that you contact manufacturer of the
device to get their support on this. Hope this is helpful.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| Reply-To: "Neil W." <neilw@.netlib.com>
| From: "Neil W." <neilw@.netlib.com>
| Subject: Backing up to Colorado external tape
| Date: Mon, 31 Jan 2005 16:00:12 -0500
| Lines: 6
| Organization: NetLib
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| Message-ID: <OfJOyg9BFHA.1404@.TK2MSFTNGP11.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: 167.206.228.82
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFT NGP08.phx.gbl!TK2MSFTNGP11
phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376364
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| we've backed up SQL to a "regular" tape drive before, but now I am trying
to
| use a Colorado (Travan) external parallel port tape drive. Even though
the
| OS seems to see a tape there, I cannot mount it or make SQL see the tape.
| Any ideas of what to do? Thanks.
|
|
|
|||Hi Neil
Why don't you use SQL to backup the database to disk and then have your
backup program grab the backup file and copy it to the tape? I know it's an
"extra" step, but it's maybe easier than getting SQL server to recognize the
tape.
Regards
Steen
Neil W. wrote:
> Thanks for the tip - but I am using Windows 2000. The included backup
> program works fine - it is just that sql does not recognize that a
> tape is mounted.
> ___________________
> "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
> Hello Neil,
> Based on my experience, there is some known issue on certain Travan
> tape devices. You may first try to call PSS to get the following
> hotfix to see if it helps:
> 825742 Cannot Back Up Data to a Travan Tape Device Successfully
> http://support.microsoft.com/?id=825742
> If the issue persists, it is advised that you contact manufacturer of
> the device to get their support on this. Hope this is helpful.
> Thanks & Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader
> so that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> --
>
cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFT NGP08.phx.gbl!TK2MSFTNGP11[vbcol=seagreen]
> phx.gbl
|||Hello Neil,
It seems RSM does not work properly. Can you run Ntbackup to backup OS
files? Did you once use a different tape properly.
You can check if it is listed in RSM device by the following method:
1. Right click My Computer->Manage->Storage->Removable Storage
2. Check if the tape is listed properly.
If not, you may contact the manufacturer if it is fully compatible with
Win2000. If so, you may want to use the following steps to rebuild RSM
database to test
1. Stop the RSM Service.
2. Delete the RSM databases located at %SystemRoot%\System32\NtmsData.
3. Restart the RSM Service, this will recreate new, empty RSM Databases.
As I mentioned, it is usually a hardware/driver related issue. I agree with
Steen because his workaround might be much easier at present.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
| From: "Steen Persson" <SPE@.REMOVEdatea.dk>
| References: <OfJOyg9BFHA.1404@.TK2MSFTNGP11.phx.gbl>
<DkH3gsACFHA.3152@.cpmsftngxa10.phx.gbl>
<O##zhiGCFHA.1392@.tk2msftngp13.phx.gbl>
| Subject: Re: Backing up to Colorado external tape
| Date: Tue, 1 Feb 2005 16:28:17 +0100
| Lines: 70
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| Message-ID: <#yF4oKHCFHA.824@.TK2MSFTNGP11.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: 213.173.238.82
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFT NGP08.phx.gbl!TK2MSFTNGP11
.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376456
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hi Neil
| Why don't you use SQL to backup the database to disk and then have your
| backup program grab the backup file and copy it to the tape? I know it's
an
| "extra" step, but it's maybe easier than getting SQL server to recognize
the
| tape.
|
| Regards
| Steen
|
| Neil W. wrote:
| > Thanks for the tip - but I am using Windows 2000. The included backup
| > program works fine - it is just that sql does not recognize that a
| > tape is mounted.
| >
| > ___________________
| >
| > "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| > Hello Neil,
| >
| > Based on my experience, there is some known issue on certain Travan
| > tape devices. You may first try to call PSS to get the following
| > hotfix to see if it helps:
| >
| > 825742 Cannot Back Up Data to a Travan Tape Device Successfully
| > http://support.microsoft.com/?id=825742
| >
| > If the issue persists, it is advised that you contact manufacturer of
| > the device to get their support on this. Hope this is helpful.
| >
| > Thanks & Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > When responding to posts, please "Reply to Group" via your newsreader
| > so that others may learn and benefit from your issue.
| >
| > ================================================== ===
| > This posting is provided "AS IS" with no warranties, and confers no
| > rights.
| >
| >
| > --
| >> Reply-To: "Neil W." <neilw@.netlib.com>
| >> From: "Neil W." <neilw@.netlib.com>
| >> Subject: Backing up to Colorado external tape
| >> Date: Mon, 31 Jan 2005 16:00:12 -0500
| >> Lines: 6
| >> Organization: NetLib
| >> X-Priority: 3
| >> X-MSMail-Priority: Normal
| >> X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| >> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| >> Message-ID: <OfJOyg9BFHA.1404@.TK2MSFTNGP11.phx.gbl>
| >> Newsgroups: microsoft.public.sqlserver.server
| >> NNTP-Posting-Host: 167.206.228.82
| >> Path:
| >
|
cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFT NGP08.phx.gbl!TK2MSFTNGP11
| > phx.gbl
| >> Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:376364
| >> X-Tomcat-NG: microsoft.public.sqlserver.server
| >>
| >> we've backed up SQL to a "regular" tape drive before, but now I am
| >> trying to use a Colorado (Travan) external parallel port tape drive.
| >> Even though the OS seems to see a tape there, I cannot mount it or
| >> make SQL see the tape. Any ideas of what to do? Thanks.
|
|
|