Backup Error

Hi
I have SQL7 running and is being backed up with ArcServ 9. The server has ArcServ SQL backup client running but the backups keep coming up with errors when trying to backup the contents of the \MSSQL\FTDATA directory. The message is "The process cannot access the file because it is being used by another process.
Is it important to backup the FTDATA directory
cheer
nuvethe arcserve is not able to backup ftdata directory cause its used by sql
server.. it might have mdf and ldf files in it..
ur already using arcserv sql backup client .. why dont u use that to backup
sql database instead of backing up the whole directory. (if u dont have
arcserve open file backup agent this directory will never be backed up)
other alternate is backup the database using sql jobs in to one of the
directory may be d:\backup and backup this directory by arcserve .
Hope this would solve your query ..
Regards,
Mayur
"Nuve" <anonymous@.discussions.microsoft.com> wrote in message
news:8B7872E2-9CBB-4E44-AC44-E1A03E9525AB@.microsoft.com...
> Hi
> I have SQL7 running and is being backed up with ArcServ 9. The server has
ArcServ SQL backup client running but the backups keep coming up with errors
when trying to backup the contents of the \MSSQL\FTDATA directory. The
message is "The process cannot access the file because it is being used by
another process."
> Is it important to backup the FTDATA directory?
> cheers
> nuve|||The ftdata directory does not have any databases in it (.mdf or .ldf files).
This is the location where the full text search indexes and catalogs are
kept.
If Arcserve will not backup open files, then you will have to bring the
databases, or the server down in order to backup that directory... and if
you are using full text search it is important. ( But can be regenerated
from the data in the tables if you must... It would just take a while.)
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Nuve" <anonymous@.discussions.microsoft.com> wrote in message
news:8B7872E2-9CBB-4E44-AC44-E1A03E9525AB@.microsoft.com...
> Hi
> I have SQL7 running and is being backed up with ArcServ 9. The server has
ArcServ SQL backup client running but the backups keep coming up with errors
when trying to backup the contents of the \MSSQL\FTDATA directory. The
message is "The process cannot access the file because it is being used by
another process."
> Is it important to backup the FTDATA directory?
> cheers
> nuve

Backup Error

Hi
I have SQL7 running and is being backed up with ArcServ 9. The server has Ar
cServ SQL backup client running but the backups keep coming up with errors w
hen trying to backup the contents of the \MSSQL\FTDATA directory. The messag
e is "The process cannot ac
cess the file because it is being used by another process."
Is it important to backup the FTDATA directory?
cheers
nuvethe arcserve is not able to backup ftdata directory cause its used by sql
server.. it might have mdf and ldf files in it..
ur already using arcserv sql backup client .. why dont u use that to backup
sql database instead of backing up the whole directory. (if u dont have
arcserve open file backup agent this directory will never be backed up)
other alternate is backup the database using sql jobs in to one of the
directory may be d:\backup and backup this directory by arcserve .
Hope this would solve your query ..
Regards,
Mayur
"Nuve" <anonymous@.discussions.microsoft.com> wrote in message
news:8B7872E2-9CBB-4E44-AC44-E1A03E9525AB@.microsoft.com...
> Hi
> I have SQL7 running and is being backed up with ArcServ 9. The server has
ArcServ SQL backup client running but the backups keep coming up with errors
when trying to backup the contents of the \MSSQL\FTDATA directory. The
message is "The process cannot access the file because it is being used by
another process."
> Is it important to backup the FTDATA directory?
> cheers
> nuve|||The ftdata directory does not have any databases in it (.mdf or .ldf files).
This is the location where the full text search indexes and catalogs are
kept.
If Arcserve will not backup open files, then you will have to bring the
databases, or the server down in order to backup that directory... and if
you are using full text search it is important. ( But can be regenerated
from the data in the tables if you must... It would just take a while.)
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Nuve" <anonymous@.discussions.microsoft.com> wrote in message
news:8B7872E2-9CBB-4E44-AC44-E1A03E9525AB@.microsoft.com...
> Hi
> I have SQL7 running and is being backed up with ArcServ 9. The server has
ArcServ SQL backup client running but the backups keep coming up with errors
when trying to backup the contents of the \MSSQL\FTDATA directory. The
message is "The process cannot access the file because it is being used by
another process."
> Is it important to backup the FTDATA directory?
> cheers
> nuvesql

Backup DB on compressed folder

Hi I have a very strange case here.
Currently our db server is short of space and as a temp solution database is backed up to a compressed folder. OS is W2K advanced Edition and SQL is Enterprise version. Database is 62GB now. every time Db backup fails after backup running for 2hrs and hal
f. the error msg says that "18210 :
BackupMedium::ReportIoError: write failure on backup device 'd:\mssql\backup\DataDMP01.BAK'. Operating system error 33(The process cannot access the file because another process has locked a portion of the file.)."
we have tried another file name or rebooting the server, but none helps.
I doubt that compressed fold causes the problem or exceeds the file size limit, but can not find any clue on it.
Pls help.
thanks for reply.
George
Compressed drives are not supported for sql server databases and to the best
of my knowledge backups either. If you are low on disk space I would
suggest using a product such as SQL LiteSpeed.
Andrew J. Kelly SQL MVP
"george" <georgey@.cryptologic.com> wrote in message
news:D916C3F2-92F3-405C-9951-39D3E1D095CC@.microsoft.com...
> Hi I have a very strange case here.
> Currently our db server is short of space and as a temp solution database
is backed up to a compressed folder. OS is W2K advanced Edition and SQL is
Enterprise version. Database is 62GB now. every time Db backup fails after
backup running for 2hrs and half. the error msg says that "18210 :
> BackupMedium::ReportIoError: write failure on backup device
'd:\mssql\backup\DataDMP01.BAK'. Operating system error 33(The process
cannot access the file because another process has locked a portion of the
file.)."
> we have tried another file name or rebooting the server, but none helps.
> I doubt that compressed fold causes the problem or exceeds the file size
limit, but can not find any clue on it.
> Pls help.
> thanks for reply.
> George

Backup DB on compressed folder

Hi I have a very strange case here.
Currently our db server is short of space and as a temp solution database is
backed up to a compressed folder. OS is W2K advanced Edition and SQL is Ent
erprise version. Database is 62GB now. every time Db backup fails after back
up running for 2hrs and hal
f. the error msg says that "18210 :
BackupMedium::ReportIoError: write failure on backup device 'd:\mssql\backup
\DataDMP01.BAK'. Operating system error 33(The process cannot access the fil
e because another process has locked a portion of the file.)."
we have tried another file name or rebooting the server, but none helps.
I doubt that compressed fold causes the problem or exceeds the file size lim
it, but can not find any clue on it.
Pls help.
thanks for reply.
GeorgeCompressed drives are not supported for sql server databases and to the best
of my knowledge backups either. If you are low on disk space I would
suggest using a product such as SQL LiteSpeed.
Andrew J. Kelly SQL MVP
"george" <georgey@.cryptologic.com> wrote in message
news:D916C3F2-92F3-405C-9951-39D3E1D095CC@.microsoft.com...
> Hi I have a very strange case here.
> Currently our db server is short of space and as a temp solution database
is backed up to a compressed folder. OS is W2K advanced Edition and SQL is
Enterprise version. Database is 62GB now. every time Db backup fails after
backup running for 2hrs and half. the error msg says that "18210 :
> BackupMedium::ReportIoError: write failure on backup device
'd:\mssql\backup\DataDMP01.BAK'. Operating system error 33(The process
cannot access the file because another process has locked a portion of the
file.)."
> we have tried another file name or rebooting the server, but none helps.
> I doubt that compressed fold causes the problem or exceeds the file size
limit, but can not find any clue on it.
> Pls help.
> thanks for reply.
> George

backup causes file size to grow

I backed up my database using the sql command Backup database xxx to disk = 'yyy'
When it completed the file size of my database approximately tripled. Did I
just corrupt some data? The application appears to continue to run ok. I
have experienced performance problems in the past and assumed it was hardware
related. Maybe my database was just sized too small'?Which file tripled? The database is made up of by default one data file and
one log file. Was it the data or log file that grew? If it was the log
file then you need to know that log backups can not finish during a full
backup. So if your log file was small to begin with and someone did a large
(or lots of ) transactions during the full backup the log file may have had
to grow since it could not be truncated during the full backup.
--
Andrew J. Kelly SQL MVP
"doug" <doug@.discussions.microsoft.com> wrote in message
news:D9566F87-EC93-4950-9B59-0CF936AF0D74@.microsoft.com...
>I backed up my database using the sql command Backup database xxx to disk
>=> 'yyy'
> When it completed the file size of my database approximately tripled. Did
> I
> just corrupt some data? The application appears to continue to run ok. I
> have experienced performance problems in the past and assumed it was
> hardware
> related. Maybe my database was just sized too small'?|||It was the data file (.mdb) that grew. My log file (.ldf) is basically the
same size it was. I went from a 6gb database file to a 20gb database file.
Thanks in advance for any advice.
"Andrew J. Kelly" wrote:
> Which file tripled? The database is made up of by default one data file and
> one log file. Was it the data or log file that grew? If it was the log
> file then you need to know that log backups can not finish during a full
> backup. So if your log file was small to begin with and someone did a large
> (or lots of ) transactions during the full backup the log file may have had
> to grow since it could not be truncated during the full backup.
> --
> Andrew J. Kelly SQL MVP
>
> "doug" <doug@.discussions.microsoft.com> wrote in message
> news:D9566F87-EC93-4950-9B59-0CF936AF0D74@.microsoft.com...
> >I backed up my database using the sql command Backup database xxx to disk
> >=> > 'yyy'
> >
> > When it completed the file size of my database approximately tripled. Did
> > I
> > just corrupt some data? The application appears to continue to run ok. I
> > have experienced performance problems in the past and assumed it was
> > hardware
> > related. Maybe my database was just sized too small'?
>
>|||Are you positive that no one issued an ALTER DATABASE command that may have
grown the file? I have never heard of a db file growing from a backup
before. If it was due to autogrow there should have been lots of log
entries as well.
--
Andrew J. Kelly SQL MVP
"doug" <doug@.discussions.microsoft.com> wrote in message
news:68FFC5B6-9B4B-4194-A360-64FE8B2003AB@.microsoft.com...
> It was the data file (.mdb) that grew. My log file (.ldf) is basically
> the
> same size it was. I went from a 6gb database file to a 20gb database
> file.
> Thanks in advance for any advice.
> "Andrew J. Kelly" wrote:
>> Which file tripled? The database is made up of by default one data file
>> and
>> one log file. Was it the data or log file that grew? If it was the log
>> file then you need to know that log backups can not finish during a full
>> backup. So if your log file was small to begin with and someone did a
>> large
>> (or lots of ) transactions during the full backup the log file may have
>> had
>> to grow since it could not be truncated during the full backup.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "doug" <doug@.discussions.microsoft.com> wrote in message
>> news:D9566F87-EC93-4950-9B59-0CF936AF0D74@.microsoft.com...
>> >I backed up my database using the sql command Backup database xxx to
>> >disk
>> >=>> > 'yyy'
>> >
>> > When it completed the file size of my database approximately tripled.
>> > Did
>> > I
>> > just corrupt some data? The application appears to continue to run ok.
>> > I
>> > have experienced performance problems in the past and assumed it was
>> > hardware
>> > related. Maybe my database was just sized too small'?
>>|||is this sql 2005, and do you have full-text indexing? If so, expect large
backup files.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"doug" <doug@.discussions.microsoft.com> wrote in message
news:D9566F87-EC93-4950-9B59-0CF936AF0D74@.microsoft.com...
>I backed up my database using the sql command Backup database xxx to disk
>=> 'yyy'
> When it completed the file size of my database approximately tripled. Did
> I
> just corrupt some data? The application appears to continue to run ok. I
> have experienced performance problems in the past and assumed it was
> hardware
> related. Maybe my database was just sized too small'?

backup causes file size to grow

I backed up my database using the sql command Backup database xxx to disk =
'yyy'
When it completed the file size of my database approximately tripled. Did I
just corrupt some data? The application appears to continue to run ok. I
have experienced performance problems in the past and assumed it was hardwar
e
related. Maybe my database was just sized too small'?Which file tripled? The database is made up of by default one data file and
one log file. Was it the data or log file that grew? If it was the log
file then you need to know that log backups can not finish during a full
backup. So if your log file was small to begin with and someone did a large
(or lots of ) transactions during the full backup the log file may have had
to grow since it could not be truncated during the full backup.
Andrew J. Kelly SQL MVP
"doug" <doug@.discussions.microsoft.com> wrote in message
news:D9566F87-EC93-4950-9B59-0CF936AF0D74@.microsoft.com...
>I backed up my database using the sql command Backup database xxx to disk
>=
> 'yyy'
> When it completed the file size of my database approximately tripled. Did
> I
> just corrupt some data? The application appears to continue to run ok. I
> have experienced performance problems in the past and assumed it was
> hardware
> related. Maybe my database was just sized too small'?|||It was the data file (.mdb) that grew. My log file (.ldf) is basically the
same size it was. I went from a 6gb database file to a 20gb database file.
Thanks in advance for any advice.
"Andrew J. Kelly" wrote:

> Which file tripled? The database is made up of by default one data file a
nd
> one log file. Was it the data or log file that grew? If it was the log
> file then you need to know that log backups can not finish during a full
> backup. So if your log file was small to begin with and someone did a lar
ge
> (or lots of ) transactions during the full backup the log file may have ha
d
> to grow since it could not be truncated during the full backup.
> --
> Andrew J. Kelly SQL MVP
>
> "doug" <doug@.discussions.microsoft.com> wrote in message
> news:D9566F87-EC93-4950-9B59-0CF936AF0D74@.microsoft.com...
>
>|||Are you positive that no one issued an ALTER DATABASE command that may have
grown the file? I have never heard of a db file growing from a backup
before. If it was due to autogrow there should have been lots of log
entries as well.
Andrew J. Kelly SQL MVP
"doug" <doug@.discussions.microsoft.com> wrote in message
news:68FFC5B6-9B4B-4194-A360-64FE8B2003AB@.microsoft.com...[vbcol=seagreen]
> It was the data file (.mdb) that grew. My log file (.ldf) is basically
> the
> same size it was. I went from a 6gb database file to a 20gb database
> file.
> Thanks in advance for any advice.
> "Andrew J. Kelly" wrote:
>|||is this sql 2005, and do you have full-text indexing? If so, expect large
backup files.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"doug" <doug@.discussions.microsoft.com> wrote in message
news:D9566F87-EC93-4950-9B59-0CF936AF0D74@.microsoft.com...
>I backed up my database using the sql command Backup database xxx to disk
>=
> 'yyy'
> When it completed the file size of my database approximately tripled. Did
> I
> just corrupt some data? The application appears to continue to run ok. I
> have experienced performance problems in the past and assumed it was
> hardware
> related. Maybe my database was just sized too small'?

Backup and zip the Transaction log file

Once the procedure is executed the database transaction log would be backed up and zipped with a blank text file which has the
the current date DD/MM/yyyy as the text file name

exec ('exec master..xp_cmdshell ''dtsrun /SItchy /Usa /PF!gl@.59b#fl@.#f!uxr /N'+@.defaultCSVFeed_DTS+''' ')
exec ('exec master..xp_cmdshell ''E:\Inetpub\wwwroot\BIASS\wzzip.exe E:\Inetpub\wwwroot\'+@.SiteFolder+'\Admin\BIA_DataF eed\'+@.FileName+'.zip E:\Inetpub\wwwroot\'+@.SiteFolder+'\Admin\BIA_DataF eed\'+@.FileName+'.'+@.defaultCSVFeed_FileType+''' ')

Pls let me know how can i zip the backup file with a blank text file with the date as the file name of the blank text file...hey... its URGENT.... pls can anybody help me on this...... :(

Backup and zip the Transaction log file

Once the procedure is executed the database transaction log would be backed up and zipped with a blank text file which has the
the current date DD/MM/yyyy as the text file name

exec ('exec master..xp_cmdshell ''dtsrun /SItchy /Usa /PF!gl@.59b#fl@.#f!uxr /N'+@.defaultCSVFeed_DTS+''' ')
exec ('exec master..xp_cmdshell ''E:\Inetpub\wwwroot\BIASS\wzzip.exe E:\Inetpub\wwwroot\'+@.SiteFolder+'\Admin\BIA_DataF eed\'+@.FileName+'.zip E:\Inetpub\wwwroot\'+@.SiteFolder+'\Admin\BIA_DataF eed\'+@.FileName+'.'+@.defaultCSVFeed_FileType+''' ')

Pls let me know how can i zip the backup file with a blank text file with the date as the file name of the blank text file...As you have posted a question in the articles section it is being moved to SQL Server Forum.

MODERATOR.

Back-Up and restore

Hi Guys,
I have a database, which I recently backed up. Now I would like to
restore this back-up on another server. So basically I m trying to
create a copy of my database on the other server.
How can I restore this back-up file on the other server. When I try
doing that from the Enterprise Manager, it says that I have to choose
from an existing backup file. I m using SQL Server 2000 on Win 2K.
So basically what I want is to create the database from scratch on the
new server using that back up file from the other database. Can somebody
tell me the procedure for this. I m a newbie at SQL Server.
Thanks.
Ricky
--
Posted via http://dbforums.comRicky, it should be fairly straight forward. Use Enterprise Manager and
fire off the restore wizard. Just restore database from device and navigate
to the backup file. If you have problems, I highly recommend going to the
Books online and lookup the topic "RESTORE DATABASE" and do the restore from
Query Analyzer in T-SQL. You may find T-SQL a little more difficult, but
it's more rewarding and more flexible that the GUI for all database
functions. The only thing that comed to mind that I've never done with QA
is to get a table in design view and rearrange the column order... and that
is just cosmetic anyway.
hth,
Eric
"Ricky_Singh" <member32195@.dbforums.com> wrote in message
news:3082099.1057594899@.dbforums.com...
> Hi Guys,
> I have a database, which I recently backed up. Now I would like to
> restore this back-up on another server. So basically I m trying to
> create a copy of my database on the other server.
> How can I restore this back-up file on the other server. When I try
> doing that from the Enterprise Manager, it says that I have to choose
> from an existing backup file. I m using SQL Server 2000 on Win 2K.
> So basically what I want is to create the database from scratch on the
> new server using that back up file from the other database. Can somebody
> tell me the procedure for this. I m a newbie at SQL Server.
> Thanks.
> Ricky
> --
> Posted via http://dbforums.com|||Hi Ricky,
You said :
>>'I have a database, which I recently backed up. Now I would like torestore
this back-up on another server. So basically I m trying to create a copy of
my database on the other server'. <<
It seems to me that you already have a backup available that you want to
restore...do the following :
1) Copy the backup file across to the new server.
2) On the new server, create a database device ( Expand: Management > Right
click on 'Backup' > New backup device, note the path and give it a
descrpiptive name (somedbname.bak)
3) Right click on the database you want to restore, All Tasks > Restore
Database
4) Click on 'From Device' and click 'Select Devices' on device name > click
Add.
5) click on filename and browse to the location where you copied the old
backup file and click ok.
6) Now, don't close all the windows, come back to the restore database
window and click on 'Options' tab and select the 'Force restore over
existing database'
7) in the Logical filename, check the old server for the logica filename
(somedbname) and enter it there, do the same for both log and mdf files.
8) In the 'Move to Physical filename' make sure it is pointing to the data
and log files of this new database.
Note that, the logical filename is not the path, but just a name, you can
get it by going to the old server, right click the database > properties --
the 'Filename' here is the logical filename -- do the same for the
Transaction log tab as well.
After you hit restore...it will complete the restore and give u a message
saying that restore is complete...
Hope this helps.
Regards,
Andy.
PS: This information is Ad-hoc and i cannot be held responsible for any
action you might take, I recommend that you consult a few people and then go
about it.
Thanks
"Ricky_Singh" <member32195@.dbforums.com> wrote in message
news:3082099.1057594899@.dbforums.com...
> Hi Guys,
> I have a database, which I recently backed up. Now I would like to
> restore this back-up on another server. So basically I m trying to
> create a copy of my database on the other server.
> How can I restore this back-up file on the other server. When I try
> doing that from the Enterprise Manager, it says that I have to choose
> from an existing backup file. I m using SQL Server 2000 on Win 2K.
> So basically what I want is to create the database from scratch on the
> new server using that back up file from the other database. Can somebody
> tell me the procedure for this. I m a newbie at SQL Server.
> Thanks.
> Ricky
> --
> Posted via http://dbforums.com

Backup a large database

1) What is the best way to backup a large database >100GB.
Backed up files should be able to restore on a DR server,
I can not use file group backup because it will only allow
me to restore it back to original server.
If use dump database method will give me a 100GB single
file.
2) How can I upgrade a database from SQL 7.0 with a single
30 GB data file in primary group (only one file group ) to
SQL 2000 with multiple file groups, I have tried to create
a database with two file groups in SQL 2000 then restore
the backup taken from SQL 7.0 , but this will restore the
single file setting from SQL 7.0 and over written the
database setting in SQL 2000 .Ji
Have you tried to compress you backup file (like .ZIP or .RAR) ?
"Ji" <zhijun.ji@.rbc.com> wrote in message
news:038c01c354c5$05752680$a301280a@.phx.gbl...
> 1) What is the best way to backup a large database >100GB.
> Backed up files should be able to restore on a DR server,
> I can not use file group backup because it will only allow
> me to restore it back to original server.
> If use dump database method will give me a 100GB single
> file.
> 2) How can I upgrade a database from SQL 7.0 with a single
> 30 GB data file in primary group (only one file group ) to
> SQL 2000 with multiple file groups, I have tried to create
> a database with two file groups in SQL 2000 then restore
> the backup taken from SQL 7.0 , but this will restore the
> single file setting from SQL 7.0 and over written the
> database setting in SQL 2000 .
>|||Ji,
> 1) What is the best way to backup a large database >100GB.
> Backed up files should be able to restore on a DR server,
> I can not use file group backup because it will only allow
> me to restore it back to original server.
> If use dump database method will give me a 100GB single
> file.
Get yourself one or more large tape units - DLT or Super AIT for instance.
Then backup straight to tape.
> 2) How can I upgrade a database from SQL 7.0 with a single
> 30 GB data file in primary group (only one file group ) to
> SQL 2000 with multiple file groups, I have tried to create
> a database with two file groups in SQL 2000 then restore
> the backup taken from SQL 7.0 , but this will restore the
> single file setting from SQL 7.0 and over written the
> database setting in SQL 2000 .
Use the database upgrade wizard that came with SQL 2000.
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq

Backup

If a 250 MB database contains only 30 MB of data, how much of the database is written when the database is backed up? Why?
a. 30 MB
b. 250 MB
c. 220 MB
d. 60 MBIf you have a 250Mb Db which only contains 30Mb of data. Then the backup should be around the 30Mb mark give or take.

A database being 250Mb in size, most likely would include data, transaction log and unused space. Your transaction log is not included in a full database dump. And the space allocated to your db which is not currently filled with data is also not backed up.

I'm sure the answer also depends on your version of SQL Server as well. Does this answer your question?

Originally posted by ssivaprasad
If a 250 MB database contains only 30 MB of data, how much of the database is written when the database is backed up? Why?
a. 30 MB
b. 250 MB
c. 220 MB
d. 60 MB|||Valid explanation by Bmalar, looks like you(siva) struck with one of questions from certifications.

Backup

How do you back up the Agent Jobs and the Local Packages under Data
Transformation services? Does this get backed up when you back up the Master
database?
Thanks
RickThey get backed up when you backup the msdb database.
-Sue
On Wed, 13 Aug 2003 15:14:27 -0700, "Rick V"
<rick@.di-wave.com> wrote:
>How do you back up the Agent Jobs and the Local Packages under Data
>Transformation services? Does this get backed up when you back up the Master
>database?
> Thanks
> Rick
>|||Thanks very much!!!
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:9ngljvsocne65i7n5lsftphqpddsqs579u@.4ax.com...
> They get backed up when you backup the msdb database.
> -Sue
> On Wed, 13 Aug 2003 15:14:27 -0700, "Rick V"
> <rick@.di-wave.com> wrote:
> >How do you back up the Agent Jobs and the Local Packages under Data
> >Transformation services? Does this get backed up when you back up the
Master
> >database?
> >
> > Thanks
> > Rick
> >
>

Backup

I have backed up a sql server 2000 db to a BAK file called george.bak for
exapmle. I need to restore this databse into a another sqll server 2000.
How can i do this using enterprise manager or any method.I'd prefer doing such things by QA
exec SRV.master.dbo.sp_executesql N'RESTORE DATABASE pubs
FROM DISK =''C:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\testback.bak'''
Note : Take a look at RESTORE article in the BOL you 'll need probably use
WITH MOVE option
"George Schneider" <georgedschneider@.news.postalias> wrote in message
news:D2AE92DF-5D3F-40C5-ACFD-5E2F75AD9D11@.microsoft.com...
>I have backed up a sql server 2000 db to a BAK file called george.bak for
> exapmle. I need to restore this databse into a another sqll server 2000.
> How can i do this using enterprise manager or any method.|||Hello George,
You may want to refer to the following articles which shall address this
issue:
314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546
224071 INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/?id=224071
Best 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.
--
>From: "Uri Dimant" <urid@.iscar.co.il>
>References: <D2AE92DF-5D3F-40C5-ACFD-5E2F75AD9D11@.microsoft.com>
>Subject: Re: Backup
>Date: Sun, 22 Jan 2006 10:23:56 +0200
>Lines: 21
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <uZ2Zx0yHGHA.2040@.TK2MSFTNGP14.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: bzq-25-106-78.cust.bezeqint.net 212.25.106.78
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:418437
>X-Tomcat-NG: microsoft.public.sqlserver.server
>I'd prefer doing such things by QA
>
>exec SRV.master.dbo.sp_executesql N'RESTORE DATABASE pubs
>FROM DISK =''C:\Program Files\Microsoft SQL
>Server\MSSQL\BACKUP\testback.bak'''
>
>Note : Take a look at RESTORE article in the BOL you 'll need probably
use
>WITH MOVE option
>
>
>"George Schneider" <georgedschneider@.news.postalias> wrote in message
>news:D2AE92DF-5D3F-40C5-ACFD-5E2F75AD9D11@.microsoft.com...
>
>

Backup

I have backed up a sql server 2000 db to a BAK file called george.bak for
exapmle. I need to restore this databse into a another sqll server 2000.
How can i do this using enterprise manager or any method.
I'd prefer doing such things by QA
exec SRV.master.dbo.sp_executesql N'RESTORE DATABASE pubs
FROM DISK =''C:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\testback.bak'''
Note : Take a look at RESTORE article in the BOL you 'll need probably use
WITH MOVE option
"George Schneider" <georgedschneider@.news.postalias> wrote in message
news:D2AE92DF-5D3F-40C5-ACFD-5E2F75AD9D11@.microsoft.com...
>I have backed up a sql server 2000 db to a BAK file called george.bak for
> exapmle. I need to restore this databse into a another sqll server 2000.
> How can i do this using enterprise manager or any method.
|||Hello George,
You may want to refer to the following articles which shall address this
issue:
314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546
224071 INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/?id=224071
Best 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.
--
>From: "Uri Dimant" <urid@.iscar.co.il>
>References: <D2AE92DF-5D3F-40C5-ACFD-5E2F75AD9D11@.microsoft.com>
>Subject: Re: Backup
>Date: Sun, 22 Jan 2006 10:23:56 +0200
>Lines: 21
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <uZ2Zx0yHGHA.2040@.TK2MSFTNGP14.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: bzq-25-106-78.cust.bezeqint.net 212.25.106.78
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP14.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:418437
>X-Tomcat-NG: microsoft.public.sqlserver.server
>I'd prefer doing such things by QA
>
>exec SRV.master.dbo.sp_executesql N'RESTORE DATABASE pubs
>FROM DISK =''C:\Program Files\Microsoft SQL
>Server\MSSQL\BACKUP\testback.bak'''
>
>Note : Take a look at RESTORE article in the BOL you 'll need probably
use
>WITH MOVE option
>
>
>"George Schneider" <georgedschneider@.news.postalias> wrote in message
>news:D2AE92DF-5D3F-40C5-ACFD-5E2F75AD9D11@.microsoft.com...
>
>

Backup

I have backed up a sql server 2000 db to a BAK file called george.bak for
exapmle. I need to restore this databse into a another sqll server 2000.
How can i do this using enterprise manager or any method.I'd prefer doing such things by QA
exec SRV.master.dbo.sp_executesql N'RESTORE DATABASE pubs
FROM DISK =''C:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\testback.bak'''
Note : Take a look at RESTORE article in the BOL you 'll need probably use
WITH MOVE option
"George Schneider" <georgedschneider@.news.postalias> wrote in message
news:D2AE92DF-5D3F-40C5-ACFD-5E2F75AD9D11@.microsoft.com...
>I have backed up a sql server 2000 db to a BAK file called george.bak for
> exapmle. I need to restore this databse into a another sqll server 2000.
> How can i do this using enterprise manager or any method.|||Hello George,
You may want to refer to the following articles which shall address this
issue:
314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546
224071 INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/?id=224071
Best 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.
>From: "Uri Dimant" <urid@.iscar.co.il>
>References: <D2AE92DF-5D3F-40C5-ACFD-5E2F75AD9D11@.microsoft.com>
>Subject: Re: Backup
>Date: Sun, 22 Jan 2006 10:23:56 +0200
>Lines: 21
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <uZ2Zx0yHGHA.2040@.TK2MSFTNGP14.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: bzq-25-106-78.cust.bezeqint.net 212.25.106.78
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:418437
>X-Tomcat-NG: microsoft.public.sqlserver.server
>I'd prefer doing such things by QA
>
>exec SRV.master.dbo.sp_executesql N'RESTORE DATABASE pubs
>FROM DISK =''C:\Program Files\Microsoft SQL
>Server\MSSQL\BACKUP\testback.bak'''
>
>Note : Take a look at RESTORE article in the BOL you 'll need probably
use
>WITH MOVE option
>
>
>"George Schneider" <georgedschneider@.news.postalias> wrote in message
>news:D2AE92DF-5D3F-40C5-ACFD-5E2F75AD9D11@.microsoft.com...
>>I have backed up a sql server 2000 db to a BAK file called george.bak for
>> exapmle. I need to restore this databse into a another sqll server 2000.
>> How can i do this using enterprise manager or any method.
>
>

Backing up trans log of system dbs

Guys,

Should the transaction log of the system databases be backed up and if so, how often should this be done, generally?

Currently, we are backing up the system databases daily. The transaction log of the system databases, however, is not backed up.

Recently, I was wondering what exactly could happen, which would imply that we need to back up the transaction log of the system databases.

As far as I understand, 'msdb' contains things like jobs, dts. As such, if no jobs/dts are added in the middle of the day, there is no need to back up the trans log of this db - there could even be no reason, in such case, to back this db up at all!

'master' db would change if we add/modify objects/properties and so on ... so unless many changes are made, no need for backing up its trans log.

Having said that, could anyone enlighten me as to whether it is necessary to back up the transaction log of the system dbs and/or what it depends on and/or when it is suggested to do so?

Thanks youBy default, master and msdb are set to simple recovery, so the transaction log backups would error out. I would strongly suggest not tampering with these databases. For myself, I back them up in full once a week to disk, and every night in full to tape. They are small by today's standards.|||Thanks Mcrowley

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.
|
|
|

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.
|
|
|

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.
|
|
|