backup db

I'm trying to make a backup of a DB with a stored procedure. I call the sp
through an ODBC connection.When the backup is placed on a fixed disk
everything is OK. When a give a removable device as target the backup is
removed at the moment the odbc connection is closed. I need the backup on a
removable device.
How can I fix this?
an option is to make the backup on disk and copy it to the removable device,
but I don't know exactly when the backup is finished. can I add something in
the stored procedure to wait for the completion of the backup.
here is the sp:
CREATE PROCEDURE [dbo].[sp_Backup_DB]
@.path varchar (100)
AS
-- Back up the database.
BACKUP DATABASE PasV2 TO DISK = @.path
GOBert
I'm not sure undestand what are you after, however ,see in the BOL WAITFOR
command
"Bert Okkerse" <bizix@.skynet.be> wrote in message
news:uwpRa$LpGHA.148@.TK2MSFTNGP04.phx.gbl...
> I'm trying to make a backup of a DB with a stored procedure. I call the sp
> through an ODBC connection.When the backup is placed on a fixed disk
> everything is OK. When a give a removable device as target the backup is
> removed at the moment the odbc connection is closed. I need the backup on
> a removable device.
> How can I fix this?
> an option is to make the backup on disk and copy it to the removable
> device, but I don't know exactly when the backup is finished. can I add
> something in the stored procedure to wait for the completion of the
> backup.
> here is the sp:
> CREATE PROCEDURE [dbo].[sp_Backup_DB]
> @.path varchar (100)
> AS
> -- Back up the database.
> BACKUP DATABASE PasV2 TO DISK = @.path
> GO
>|||Hi,
If you want to make a copy of your database on removable media try
sp_create_removable
refer BOL for more info
Amol Lembhe
MCDBA
amol.lembhe@.patni.com
"Bert Okkerse" wrote:

> I'm trying to make a backup of a DB with a stored procedure. I call the sp
> through an ODBC connection.When the backup is placed on a fixed disk
> everything is OK. When a give a removable device as target the backup is
> removed at the moment the odbc connection is closed. I need the backup on
a
> removable device.
> How can I fix this?
> an option is to make the backup on disk and copy it to the removable devic
e,
> but I don't know exactly when the backup is finished. can I add something
in
> the stored procedure to wait for the completion of the backup.
> here is the sp:
> CREATE PROCEDURE [dbo].[sp_Backup_DB]
> @.path varchar (100)
> AS
> -- Back up the database.
> BACKUP DATABASE PasV2 TO DISK = @.path
> GO
>
>

backup db

I'm trying to make a backup of a DB with a stored procedure. I call the sp
through an ODBC connection.When the backup is placed on a fixed disk
everything is OK. When a give a removable device as target the backup is
removed at the moment the odbc connection is closed. I need the backup on a
removable device.
How can I fix this?
an option is to make the backup on disk and copy it to the removable device,
but I don't know exactly when the backup is finished. can I add something in
the stored procedure to wait for the completion of the backup.
here is the sp:
CREATE PROCEDURE [dbo].[sp_Backup_DB]
@.path varchar (100)
AS
-- Back up the database.
BACKUP DATABASE PasV2 TO DISK = @.path
GOBert
I'm not sure undestand what are you after, however ,see in the BOL WAITFOR
command
"Bert Okkerse" <bizix@.skynet.be> wrote in message
news:uwpRa$LpGHA.148@.TK2MSFTNGP04.phx.gbl...
> I'm trying to make a backup of a DB with a stored procedure. I call the sp
> through an ODBC connection.When the backup is placed on a fixed disk
> everything is OK. When a give a removable device as target the backup is
> removed at the moment the odbc connection is closed. I need the backup on
> a removable device.
> How can I fix this?
> an option is to make the backup on disk and copy it to the removable
> device, but I don't know exactly when the backup is finished. can I add
> something in the stored procedure to wait for the completion of the
> backup.
> here is the sp:
> CREATE PROCEDURE [dbo].[sp_Backup_DB]
> @.path varchar (100)
> AS
> -- Back up the database.
> BACKUP DATABASE PasV2 TO DISK = @.path
> GO
>|||Hi,
If you want to make a copy of your database on removable media try
sp_create_removable
refer BOL for more info
Amol Lembhe
MCDBA
amol.lembhe@.patni.com
"Bert Okkerse" wrote:
> I'm trying to make a backup of a DB with a stored procedure. I call the sp
> through an ODBC connection.When the backup is placed on a fixed disk
> everything is OK. When a give a removable device as target the backup is
> removed at the moment the odbc connection is closed. I need the backup on a
> removable device.
> How can I fix this?
> an option is to make the backup on disk and copy it to the removable device,
> but I don't know exactly when the backup is finished. can I add something in
> the stored procedure to wait for the completion of the backup.
> here is the sp:
> CREATE PROCEDURE [dbo].[sp_Backup_DB]
> @.path varchar (100)
> AS
> -- Back up the database.
> BACKUP DATABASE PasV2 TO DISK = @.path
> GO
>
>

Backup

I'm working with a database server placed in a datacenter remotely placed fr
om my work location, and accessing the database through Enterprise Manager a
nd Quesry Analyser connected via Internet.
The backup is scheduled and log-shipping is implemented with another server
in the datacenter. But I want to take backup and store backup files in my lo
cal machine. Can I do this or I have to get the files from the database ser
ver through some FTP or oth
er protocol.
Thanks in advance but plz do help meSunil
BACKUP DATABASE DatabaseName TO DISK =
N'\\Server\backup\databasename.BAK'
"Sunil Dash" <anonymous@.discussions.microsoft.com> wrote in message
news:08D9D28D-E45A-4208-BF2C-6D5E15B9B1B6@.microsoft.com...

quote:

---

> I'm working with a database server placed in a datacenter remotely placed

---

from my work location, and accessing the database through Enterprise Manager
and Quesry Analyser connected via Internet.

quote:

---

> The backup is scheduled and log-shipping is implemented with another

---

server in the datacenter. But I want to take backup and store backup files
in my local machine. Can I do this or I have to get the files from the
database server through some FTP or other protocol.

quote:

---

>
> Thanks in advance but plz do help me

---

|||When I'm accessing the database server through the internet link so how can
I use \\ unc path.|||assumed you have SQL installed on your local machine or a machine on local
network and there is an FTP server at the remote network,
on the remote server you can use winrar (has more compression ratio then
winzip) to compress the backups, use DTS on to schedule an FTP job to
transfer the rar file to you local machine.
"Sunil Dash" <anonymous@.discussions.microsoft.com> wrote in message
news:76683E68-071B-42B1-9AFB-8E598E81FBF2@.microsoft.com...

quote:

---

> When I'm accessing the database server through the internet link so how

---

can I use \\ unc path.

Backup

I'm working with a database server placed in a datacenter remotely placed from my work location, and accessing the database through Enterprise Manager and Quesry Analyser connected via Internet.
The backup is scheduled and log-shipping is implemented with another server in the datacenter. But I want to take backup and store backup files in my local machine. Can I do this or I have to get the files from the database server through some FTP or other protocol.
Thanks in advance but plz do help meSunil
BACKUP DATABASE DatabaseName TO DISK = N'\\Server\backup\databasename.BAK'
"Sunil Dash" <anonymous@.discussions.microsoft.com> wrote in message
news:08D9D28D-E45A-4208-BF2C-6D5E15B9B1B6@.microsoft.com...
> I'm working with a database server placed in a datacenter remotely placed
from my work location, and accessing the database through Enterprise Manager
and Quesry Analyser connected via Internet.
> The backup is scheduled and log-shipping is implemented with another
server in the datacenter. But I want to take backup and store backup files
in my local machine. Can I do this or I have to get the files from the
database server through some FTP or other protocol.
>
> Thanks in advance but plz do help me|||When I'm accessing the database server through the internet link so how can I use \\ unc path.|||assumed you have SQL installed on your local machine or a machine on local
network and there is an FTP server at the remote network,
on the remote server you can use winrar (has more compression ratio then
winzip) to compress the backups, use DTS on to schedule an FTP job to
transfer the rar file to you local machine.
"Sunil Dash" <anonymous@.discussions.microsoft.com> wrote in message
news:76683E68-071B-42B1-9AFB-8E598E81FBF2@.microsoft.com...
> When I'm accessing the database server through the internet link so how
can I use \\ unc path.