Hello,
We are currently migrating from NT to 2K servers and I
have been assigned to port over an MSDE database from the
NT environment to Windows 2000 Server.
Can someone please point me to a tutorial on how to backup
and restore an MSDE database..
Thanks,
niv
Hi ,
There is no syntax difference in backup and restore commands for a regular
sql server installation and msde.
You can use the following sample commands to perform backup and restore
Examples
A. Back up the entire MyNwind database
Note The MyNwind database is shown for illustration only.
This example creates a logical backup device in which a full backup of the
MyNwind database is placed.
-- Create a logical backup device for the full MyNwind backup.
USE master
EXEC sp_addumpdevice 'disk', 'MyNwind_1',
DISK ='c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwind_1.dat'
-- Back up the full MyNwind database.
BACKUP DATABASE MyNwind TO MyNwind_1
B. Back up the database and log
This example creates both a full database and log backup. The database is
backed up to a logical backup device called MyNwind_2, and then the log is
backed up to a logical backup device called MyNwindLog1.
Note Creating a logical backup device needs to be done only once.
-- Create the backup device for the full MyNwind backup.
USE master
EXEC sp_addumpdevice 'disk', 'MyNwind_2',
'c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwind_2.dat'
--Create the log backup device.
USE master
EXEC sp_addumpdevice 'disk', 'MyNwindLog1',
'c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwindLog1.dat'
-- Back up the full MyNwind database.
BACKUP DATABASE MyNwind TO MyNwind_2
-- Update activity has occurred since the full database backup.
-- Back up the log of the MyNwind database.
BACKUP LOG MyNwind
TO MyNwindLog1
http://msdn.microsoft.com/library/de...us/adminsql/ad
_bkprst_8v3n.asp - Detailed informatin about backup and restore operations
along with examples.
Showing posts with label port. Show all posts
Showing posts with label port. Show all posts
Wednesday, March 7, 2012
Friday, February 10, 2012
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.
|
|
|
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.
|
|
|
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!TK2MSFTNGP08.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!TK2MSFTNGP08.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!TK2MSFTNGP08.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!TK2MSFTNGP08.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!TK2MSFTNGP08.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.
|
|
|
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!TK2MSFTNGP08.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!TK2MSFTNGP08.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!TK2MSFTNGP08.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!TK2MSFTNGP08.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!TK2MSFTNGP08.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.
|
|
|
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!TK2MSFTNGP08.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!TK2MSFTNGP08.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.
>
> --
>> 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!TK2MSFTNGP08.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.|||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!TK2MSFTNGP08.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!TK2MSFTNGP08.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.
|
|
|
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!TK2MSFTNGP08.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!TK2MSFTNGP08.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.
>
> --
>> 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!TK2MSFTNGP08.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.|||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!TK2MSFTNGP08.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!TK2MSFTNGP08.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.
|
|
|
Subscribe to:
Posts (Atom)