Backup failure

All,
I am receiving the following error when I try to backup to tape from SQL using backup under the Management folder in Enterprise manager. Logged in as administrator. Can backup the pubs, Northwind and master databases with no problem.
The database is approx. 8.5GB and the tape can hold 40GB formatted. Using option to overwrite and initialize.
Microsoft SQL-DMO (ODBC SQLState: 42000)
Write on '\\.\Tape0' failed, status = 1117. See the SQL Server error log for more details, backup database is terminating abnormally.
In the error log;
Internal I/O request 0x075CB728: op: write, pBuffer: 0x07d3000, size: 65536, position: 11141120, UMS: internal: 0xC0000185, internalhigh: 0x10000, offset: 0xAA0000, offsethigh: 0x0, m_buf: 0x07d30000, m_len: 65536, m_actualbytes: 65536, m_errcode: 1117, b
ackupfile: \\.\Tape0
Any thought would be appreciated.
Regards,
Dave
can you back it up to disk instead of to tape?
can you backup a large file from disk to tape?
I will do it this way because backup done faster and eliminating the hassle
of dealing with the tape drive.
my 0.02
"David" <anonymous@.discussions.microsoft.com> wrote in message
news:C1CCFEFC-AD93-4715-919F-C468273BD974@.microsoft.com...
> All,
> I am receiving the following error when I try to backup to tape from SQL
using backup under the Management folder in Enterprise manager. Logged in as
administrator. Can backup the pubs, Northwind and master databases with no
problem.
> The database is approx. 8.5GB and the tape can hold 40GB formatted. Using
option to overwrite and initialize.
> Microsoft SQL-DMO (ODBC SQLState: 42000)
> Write on '\\.\Tape0' failed, status = 1117. See the SQL Server error log
for more details, backup database is terminating abnormally.
> In the error log;
> Internal I/O request 0x075CB728: op: write, pBuffer: 0x07d3000, size:
65536, position: 11141120, UMS: internal: 0xC0000185, internalhigh: 0x10000,
offset: 0xAA0000, offsethigh: 0x0, m_buf: 0x07d30000, m_len: 65536,
m_actualbytes: 65536, m_errcode: 1117, backupfile: \\.\Tape0
> Any thought would be appreciated.
> Regards,
> Dave

Backup failure

All,
I am receiving the following error when I try to backup to tape from SQL usi
ng backup under the Management folder in Enterprise manager. Logged in as ad
ministrator. Can backup the pubs, Northwind and master databases with no pro
blem.
The database is approx. 8.5GB and the tape can hold 40GB formatted. Using op
tion to overwrite and initialize.
Microsoft SQL-DMO (ODBC SQLState: 42000)
Write on '\\.\Tape0' failed, status = 1117. See the SQL Server error log for
more details, backup database is terminating abnormally.
In the error log;
Internal I/O request 0x075CB728: op: write, pBuffer: 0x07d3000, size: 65536,
position: 11141120, UMS: internal: 0xC0000185, internalhigh: 0x10000, offse
t: 0xAA0000, offsethigh: 0x0, m_buf: 0x07d30000, m_len: 65536, m_actualbytes
: 65536, m_errcode: 1117, b
ackupfile: \\.\Tape0
Any thought would be appreciated.
Regards,
Davecan you back it up to disk instead of to tape?
can you backup a large file from disk to tape?
I will do it this way because backup done faster and eliminating the hassle
of dealing with the tape drive.
my 0.02
"David" <anonymous@.discussions.microsoft.com> wrote in message
news:C1CCFEFC-AD93-4715-919F-C468273BD974@.microsoft.com...
> All,
> I am receiving the following error when I try to backup to tape from SQL
using backup under the Management folder in Enterprise manager. Logged in as
administrator. Can backup the pubs, Northwind and master databases with no
problem.
> The database is approx. 8.5GB and the tape can hold 40GB formatted. Using
option to overwrite and initialize.
> Microsoft SQL-DMO (ODBC SQLState: 42000)
> Write on '\\.\Tape0' failed, status = 1117. See the SQL Server error log
for more details, backup database is terminating abnormally.
> In the error log;
> Internal I/O request 0x075CB728: op: write, pBuffer: 0x07d3000, size:
65536, position: 11141120, UMS: internal: 0xC0000185, internalhigh: 0x10000,
offset: 0xAA0000, offsethigh: 0x0, m_buf: 0x07d30000, m_len: 65536,
m_actualbytes: 65536, m_errcode: 1117, backupfile: \\.\Tape0
> Any thought would be appreciated.
> Regards,
> Davesql

BACKUP failing! HELP!

I'm trying to backup a SQL 7.0 database to a network server (NT) from
Enterprise Manager and am getting the following error:

Title bar: Microsoft SQL DMO (ODBC SQL State: 42000)
Message: Backup or restore operation terminating abnormally.

The SQL Log has the following message:
BackupDiskFile::RequestDurableMedia: failure on backup device
'\\myserver\bu_sql$\bu_mydb1.bak'. Operating system error 64(The
specified network name is no longer available.).

When I run a scheduled job that backs up mydb1, it fails with the
following message: Processed 50968 pages for database 'mydb1', file
'mydb1_Data' on file 1. [SQLSTATE 01000] (Message 4035) Processed 1
pages for database 'mydb1', file 'mydb1_Log' on file 1. [SQLSTATE
01000] (Message 4035) Backup or restore operation terminating
abnormally. [SQLSTATE 42000] (Error 3013). The step failed.

This appears to a network problem but the transaction log dumps from
the same database to the same network share work fine as does a full
backup of a different database (on the same SQL Server).

The file bu_mydb1.bak is being created on the network drive. The
network drive has plenty of available space. The file is only 423MB
and the share has 9GB free space.

Any ideas?jeff.strange@.lrc.state.ky.us (Jeff) wrote in message news:<7dafc839.0401130705.1dc48e96@.posting.google.com>...
> I'm trying to backup a SQL 7.0 database to a network server (NT) from
> Enterprise Manager and am getting the following error:
> Title bar: Microsoft SQL DMO (ODBC SQL State: 42000)
> Message: Backup or restore operation terminating abnormally.
> The SQL Log has the following message:
> BackupDiskFile::RequestDurableMedia: failure on backup device
> '\\myserver\bu_sql$\bu_mydb1.bak'. Operating system error 64(The
> specified network name is no longer available.).
> When I run a scheduled job that backs up mydb1, it fails with the
> following message: Processed 50968 pages for database 'mydb1', file
> 'mydb1_Data' on file 1. [SQLSTATE 01000] (Message 4035) Processed 1
> pages for database 'mydb1', file 'mydb1_Log' on file 1. [SQLSTATE
> 01000] (Message 4035) Backup or restore operation terminating
> abnormally. [SQLSTATE 42000] (Error 3013). The step failed.

There is an MS document that says your destination/remote server 'is
under stress' and you are getting i.o hits, based on error 3013. You
might look at the scheduling of the backup job.

The 3013 error says your remote disk drive 'is user stress'.
Basically, it is a timing/timeout because of the amount of disk
activity on the remote server.
> This appears to a network problem but the transaction log dumps from
> the same database to the same network share work fine as does a full
> backup of a different database (on the same SQL Server).
> The file bu_mydb1.bak is being created on the network drive. The
> network drive has plenty of available space. The file is only 423MB
> and the share has 9GB free space.
> Any ideas?

Backup Databases

I am running SQL2000 SP4 on a Win2000 server and getting following error when
trying to perform a backup of a database within Enterprise Manager.
"Error 22272: Cannot load the DLL xpstart.dll, or one of the DLL's it
references. Reason 127(The specified procedure could not be found.). I have
looked any references to this error message, but yet to find anything on it.
Wondering if someone can assist me.
thanks,
JayHi
If backing up the datrabase from a different PC works, then I would think
re-installing the client tools may help solve this.
John
"Jay" wrote:
> I am running SQL2000 SP4 on a Win2000 server and getting following error when
> trying to perform a backup of a database within Enterprise Manager.
> "Error 22272: Cannot load the DLL xpstart.dll, or one of the DLL's it
> references. Reason 127(The specified procedure could not be found.). I have
> looked any references to this error message, but yet to find anything on it.
> Wondering if someone can assist me.
> thanks,
> Jay
>|||Jay wrote:
> I am running SQL2000 SP4 on a Win2000 server and getting following error when
> trying to perform a backup of a database within Enterprise Manager.
> "Error 22272: Cannot load the DLL xpstart.dll, or one of the DLL's it
> references. Reason 127(The specified procedure could not be found.). I have
> looked any references to this error message, but yet to find anything on it.
> Wondering if someone can assist me.
> thanks,
> Jay
>
Open up Query Analyzer and use the T-SQL BACKUP command - does it work?
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Backup across the Network

We are using SQL2000
Can I do a database backup onto a file on another server?
In Enterprise Manager, I can't seem to specify a device on another server.
Thanks for any help.Yes. Just type a UNC name.
Note: SQL must be running under a domain-level account with FULL CONTROL
rights to the share and underlying folders. Don't use administrative
(C$,D$, etc) shares.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"dschrier" <anonymous@.discussions.microsoft.com> wrote in message
news:72E05DAF-E254-4B13-926B-D183E9E95EAD@.microsoft.com...
> We are using SQL2000
> Can I do a database backup onto a file on another server?
> In Enterprise Manager, I can't seem to specify a device on another server.
> Thanks for any help.|||First create a backup device that points to a network share on the other
server, than backup to that backup device.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"dschrier" <anonymous@.discussions.microsoft.com> wrote in message
news:72E05DAF-E254-4B13-926B-D183E9E95EAD@.microsoft.com...
> We are using SQL2000
> Can I do a database backup onto a file on another server?
> In Enterprise Manager, I can't seem to specify a device on another server.
> Thanks for any help.|||Hi,
Can I do a database backup onto a file on another server?
Yes , follow the below steps. Enterprise manager will only show the local
disks.
There are Few Pre requisites to do backup remotely;
1. You Should start SQL server using Domain user who got access to remote
machine Share
2. Should have share in the remote machine
3. If you need to schedule this as a job then SQL Agent should use the same
Domain user in which SQL server was started
4. Restart the services
Now you can execute the Backup script with UNC path
BACKUP Database <dbname> to disk='\\computername\sharename\dbname.bak' with
init
Note:
Backup to remote machine will not work if you start SQL server using Local
system account
Thanks
Hari
MCDBA
"dschrier" <anonymous@.discussions.microsoft.com> wrote in message
news:72E05DAF-E254-4B13-926B-D183E9E95EAD@.microsoft.com...
> We are using SQL2000
> Can I do a database backup onto a file on another server?
> In Enterprise Manager, I can't seem to specify a device on another server.
> Thanks for any help.|||Hi ,
Just to add this you can map the remote share on you database server .
The mapped drive can be used to backup on .
Thanks
Ajay
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ObmCswLSEHA.904@.TK2MSFTNGP12.phx.gbl...
> Hi,
>
> Can I do a database backup onto a file on another server?
> Yes , follow the below steps. Enterprise manager will only show the local
> disks.
> There are Few Pre requisites to do backup remotely;
>
> 1. You Should start SQL server using Domain user who got access to remote
> machine Share
> 2. Should have share in the remote machine
> 3. If you need to schedule this as a job then SQL Agent should use the
same
> Domain user in which SQL server was started
> 4. Restart the services
> Now you can execute the Backup script with UNC path
> BACKUP Database <dbname> to disk='\\computername\sharename\dbname.bak'
with
> init
> Note:
> Backup to remote machine will not work if you start SQL server using Local
> system account
> Thanks
> Hari
> MCDBA
> "dschrier" <anonymous@.discussions.microsoft.com> wrote in message
> news:72E05DAF-E254-4B13-926B-D183E9E95EAD@.microsoft.com...
server.[vbcol=seagreen]
>

Backup across the Network

We are using SQL2000
Can I do a database backup onto a file on another server?
In Enterprise Manager, I can't seem to specify a device on another server.
Thanks for any help.
Yes. Just type a UNC name.
Note: SQL must be running under a domain-level account with FULL CONTROL
rights to the share and underlying folders. Don't use administrative
(C$,D$, etc) shares.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"dschrier" <anonymous@.discussions.microsoft.com> wrote in message
news:72E05DAF-E254-4B13-926B-D183E9E95EAD@.microsoft.com...
> We are using SQL2000
> Can I do a database backup onto a file on another server?
> In Enterprise Manager, I can't seem to specify a device on another server.
> Thanks for any help.
|||First create a backup device that points to a network share on the other
server, than backup to that backup device.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"dschrier" <anonymous@.discussions.microsoft.com> wrote in message
news:72E05DAF-E254-4B13-926B-D183E9E95EAD@.microsoft.com...
> We are using SQL2000
> Can I do a database backup onto a file on another server?
> In Enterprise Manager, I can't seem to specify a device on another server.
> Thanks for any help.
|||Hi,
Can I do a database backup onto a file on another server?
Yes , follow the below steps. Enterprise manager will only show the local
disks.
There are Few Pre requisites to do backup remotely;
1. You Should start SQL server using Domain user who got access to remote
machine Share
2. Should have share in the remote machine
3. If you need to schedule this as a job then SQL Agent should use the same
Domain user in which SQL server was started
4. Restart the services
Now you can execute the Backup script with UNC path
BACKUP Database <dbname> to disk='\\computername\sharename\dbname.bak' with
init
Note:
Backup to remote machine will not work if you start SQL server using Local
system account
Thanks
Hari
MCDBA
"dschrier" <anonymous@.discussions.microsoft.com> wrote in message
news:72E05DAF-E254-4B13-926B-D183E9E95EAD@.microsoft.com...
> We are using SQL2000
> Can I do a database backup onto a file on another server?
> In Enterprise Manager, I can't seem to specify a device on another server.
> Thanks for any help.
|||Hi ,
Just to add this you can map the remote share on you database server .
The mapped drive can be used to backup on .
Thanks
Ajay
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ObmCswLSEHA.904@.TK2MSFTNGP12.phx.gbl...
> Hi,
>
> Can I do a database backup onto a file on another server?
> Yes , follow the below steps. Enterprise manager will only show the local
> disks.
> There are Few Pre requisites to do backup remotely;
>
> 1. You Should start SQL server using Domain user who got access to remote
> machine Share
> 2. Should have share in the remote machine
> 3. If you need to schedule this as a job then SQL Agent should use the
same
> Domain user in which SQL server was started
> 4. Restart the services
> Now you can execute the Backup script with UNC path
> BACKUP Database <dbname> to disk='\\computername\sharename\dbname.bak'
with[vbcol=seagreen]
> init
> Note:
> Backup to remote machine will not work if you start SQL server using Local
> system account
> Thanks
> Hari
> MCDBA
> "dschrier" <anonymous@.discussions.microsoft.com> wrote in message
> news:72E05DAF-E254-4B13-926B-D183E9E95EAD@.microsoft.com...
server.
>

Backup / restore question

I had a SQL server with some harddrive problems. So, a full backup was made
(manually using Enterprise Manager) and restored in a new machine
successfully using Enterprise Manager (the option Leave Database
Operational. No Additional Transaction Logs Can Be Restored was selected)
If the only backup available is the last Full backup, is it possible to ever
roll back some of the last changes made in the old machine before the Full
Backup ?
Thanks for your help.If all you have is the full backup and the old db is toast then no. You
might be able to do something with third party tool help such as Lumigent
Log Explorer depending on a few factors.
Ray Higdon MCSE, MCDBA, CCNA
--
<--> wrote in message news:%23xrmzy6AEHA.3788@.TK2MSFTNGP10.phx.gbl...
> I had a SQL server with some harddrive problems. So, a full backup was
made
> (manually using Enterprise Manager) and restored in a new machine
> successfully using Enterprise Manager (the option Leave Database
> Operational. No Additional Transaction Logs Can Be Restored was selected)
> If the only backup available is the last Full backup, is it possible to
ever
> roll back some of the last changes made in the old machine before the Full
> Backup ?
> Thanks for your help.
>|||Hi,
You can do this only if your OLD database is in "FULL" recovery model. Below
steps are under the assumption
that database was set to FULL recovery model and the existing database is
still up.
1. In the new server Load the full database backup with NORECOVERY
2. Perform a transaction log backup in Old Server.
3. Copy the TX log backup file to new server
4. Restore the Transaction log WITH RECOVERY , STOPAT='DATE/TIME (refer
Books online)
This will allow you to go back to old data based on the date and time.
Note:
If it is Simple or Bulk_logged recovery model you cant rollback.
POINT-IN-TIME recovery is not supposed in both.
Thanks
Hari
MCDBA
<--> wrote in message news:#xrmzy6AEHA.3788@.TK2MSFTNGP10.phx.gbl...
> I had a SQL server with some harddrive problems. So, a full backup was
made
> (manually using Enterprise Manager) and restored in a new machine
> successfully using Enterprise Manager (the option Leave Database
> Operational. No Additional Transaction Logs Can Be Restored was selected)
> If the only backup available is the last Full backup, is it possible to
ever
> roll back some of the last changes made in the old machine before the Full
> Backup ?
> Thanks for your help.
>|||Hi Hari,
Unfortunately, my old server's HD is no longer is functioning. And all I
have is the last Full Backup. Looks like I may not be able to rollback any
changes...
Can you confirm?
Thanks.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:u4QLTU$AEHA.1456@.TK2MSFTNGP09.phx.gbl...
> Hi,
> You can do this only if your OLD database is in "FULL" recovery model.
Below
> steps are under the assumption
> that database was set to FULL recovery model and the existing database is
> still up.
> 1. In the new server Load the full database backup with NORECOVERY
> 2. Perform a transaction log backup in Old Server.
> 3. Copy the TX log backup file to new server
> 4. Restore the Transaction log WITH RECOVERY , STOPAT='DATE/TIME (refer
> Books online)
> This will allow you to go back to old data based on the date and time.
> Note:
> If it is Simple or Bulk_logged recovery model you cant rollback.
> POINT-IN-TIME recovery is not supposed in both.
> Thanks
> Hari
> MCDBA
>
>
>
> <--> wrote in message news:#xrmzy6AEHA.3788@.TK2MSFTNGP10.phx.gbl...
> made
selected)
> ever
Full
>|||You will not be able to rollback any changes, as Hari pointed out you can
only do point in time recovery by using the tran log
Ray Higdon MCSE, MCDBA, CCNA
--
<--> wrote in message news:O1pe8EFBEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Hi Hari,
> Unfortunately, my old server's HD is no longer is functioning. And all I
> have is the last Full Backup. Looks like I may not be able to rollback
any
> changes...
> Can you confirm?
> Thanks.
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:u4QLTU$AEHA.1456@.TK2MSFTNGP09.phx.gbl...
> Below
is
was
> selected)
to
> Full
>|||Hi,
If you dont have the old database active, Sorry, you will not be able to
rollback the transactions (POINT-IN-TIME).
Thanks
Hari
MCDBA
"Ray Higdon" <sqlhigdon@.nospam.yahoo.com> wrote in message
news:#vsd8lFBEHA.1600@.tk2msftngp13.phx.gbl...
> You will not be able to rollback any changes, as Hari pointed out you can
> only do point in time recovery by using the tran log
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> <--> wrote in message news:O1pe8EFBEHA.2600@.TK2MSFTNGP09.phx.gbl...
> any
> is
(refer
> was
> to
the
>

Backup - Append vs Overwrite?

Hi,
If backing up a database to a disk file from within Enterprise Manager, it
seems you still get a choice between "Append" and "Overwrite". I don't
understand how these options work with disk files.
Does it mean that if you supply the exact same file name as an earlier
backup, the backup will be appended to the existing file (the file will
double in size but you'll still only have one file?).
Is it the case that if you supply a FileName that's never been used before,
it makes no difference whether you choose Append or Overwrite at this stage?
I've always used Maintenance plans for backup, and it seems you don't get a
choice about Append and Overwrite.
Thanks for any help.
Gerry Hickman
SSRU SysAdminSee inline.....
>If backing up a database to a disk file from within Enterprise Manager, it
>seems you still get a choice between "Append" and "Overwrite". I don't
>understand how these options work with disk files.
>Does it mean that if you supply the exact same file name as an earlier
>backup, the backup will be appended to the existing file (the file will
>double in size but you'll still only have one file?).
Yes it appends the backup to the file so you have one file
and two different backups in the file.
>Is it the case that if you supply a FileName that's never been used before,
>it makes no difference whether you choose Append or Overwrite at this stage?[/vbcol
]
There is nothing to append to as it will be making a new
backup.
[vbcol=seagreen]
>I've always used Maintenance plans for backup, and it seems you don't get a
>choice about Append and Overwrite.
The sqlmaint utility which the database maintenace plan uses
always does an append. You could always just write your own
backup in T-SQL using the with init or noinit options which
controls the append or overwrite behaviors. See BOL Backup
for more details on the options.
-Sue

Backup - Append vs Overwrite?

Hi,
If backing up a database to a disk file from within Enterprise Manager, it
seems you still get a choice between "Append" and "Overwrite". I don't
understand how these options work with disk files.
Does it mean that if you supply the exact same file name as an earlier
backup, the backup will be appended to the existing file (the file will
double in size but you'll still only have one file?).
Is it the case that if you supply a FileName that's never been used before,
it makes no difference whether you choose Append or Overwrite at this stage?
I've always used Maintenance plans for backup, and it seems you don't get a
choice about Append and Overwrite.
Thanks for any help.
Gerry Hickman
SSRU SysAdmin
See inline.....
>If backing up a database to a disk file from within Enterprise Manager, it
>seems you still get a choice between "Append" and "Overwrite". I don't
>understand how these options work with disk files.
>Does it mean that if you supply the exact same file name as an earlier
>backup, the backup will be appended to the existing file (the file will
>double in size but you'll still only have one file?).
Yes it appends the backup to the file so you have one file
and two different backups in the file.
>Is it the case that if you supply a FileName that's never been used before,
>it makes no difference whether you choose Append or Overwrite at this stage?
There is nothing to append to as it will be making a new
backup.

>I've always used Maintenance plans for backup, and it seems you don't get a
>choice about Append and Overwrite.
The sqlmaint utility which the database maintenace plan uses
always does an append. You could always just write your own
backup in T-SQL using the with init or noinit options which
controls the append or overwrite behaviors. See BOL Backup
for more details on the options.
-Sue

Backup - Append vs Overwrite?

Hi,
If backing up a database to a disk file from within Enterprise Manager, it
seems you still get a choice between "Append" and "Overwrite". I don't
understand how these options work with disk files.
Does it mean that if you supply the exact same file name as an earlier
backup, the backup will be appended to the existing file (the file will
double in size but you'll still only have one file?).
Is it the case that if you supply a FileName that's never been used before,
it makes no difference whether you choose Append or Overwrite at this stage?
I've always used Maintenance plans for backup, and it seems you don't get a
choice about Append and Overwrite.
Thanks for any help.
--
Gerry Hickman
SSRU SysAdminSee inline.....
>If backing up a database to a disk file from within Enterprise Manager, it
>seems you still get a choice between "Append" and "Overwrite". I don't
>understand how these options work with disk files.
>Does it mean that if you supply the exact same file name as an earlier
>backup, the backup will be appended to the existing file (the file will
>double in size but you'll still only have one file?).
Yes it appends the backup to the file so you have one file
and two different backups in the file.
>Is it the case that if you supply a FileName that's never been used before,
>it makes no difference whether you choose Append or Overwrite at this stage?
There is nothing to append to as it will be making a new
backup.
>I've always used Maintenance plans for backup, and it seems you don't get a
>choice about Append and Overwrite.
The sqlmaint utility which the database maintenace plan uses
always does an append. You could always just write your own
backup in T-SQL using the with init or noinit options which
controls the append or overwrite behaviors. See BOL Backup
for more details on the options.
-Sue

backup

Can anyone tell me how to backup a SQL 2000 database
using Enterprise Manager? Thanks in advance.Here's one way. Double click the SQL instance to connect
to it. Click on the menu item Tool -> Backup Database ...
Then, pick the database you want to backup and set the
options on the form.
Linchi
>--Original Message--
>Can anyone tell me how to backup a SQL 2000 database
>using Enterprise Manager? Thanks in advance.
>.
>

Backing up to a Remote machine in EM

I need to backup my databases to a remote server. The
problem is Enterprise manager will not recognize a UNC
address. Is there a way I can permanently change this
without just using trace flags.
I am running sql server 2000 with sp3a.
Any suggestions
Make mapped network drive on your machine. For what trace flags are you
talking?
Bojidar Alexandrov
"Kelly" <mavericc@.wepsoft.com> wrote in message
news:830101c431ea$54a0a920$a301280a@.phx.gbl...
> I need to backup my databases to a remote server. The
> problem is Enterprise manager will not recognize a UNC
> address. Is there a way I can permanently change this
> without just using trace flags.
> I am running sql server 2000 with sp3a.
> Any suggestions
|||Mapped drives are not recognized by Enterprise manager either.
I was refering to traceflag 1807.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Have the ID that SQL agent is running under map the drive letter then try
and connect to it.
Jeff Duncan
MCDBA, MCSE+I
"Kelly P" <mavericc@.wepsoft.com> wrote in message
news:%23pCT%23dgMEHA.1468@.TK2MSFTNGP12.phx.gbl...
>
> Mapped drives are not recognized by Enterprise manager either.
> I was refering to traceflag 1807.
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!