Backup SQL Tables

Good morning :)

i have a remote SQL Server tables and a remote Access.mdb file with the same tables in it.
i need to find a way to transfer the data from the SQL tables to the Access tables, with SQL commands, without being dependent in the SQL enterprise manager.

does anybody have a good idea?

thanks a lot,Why do you want to transfer the data from MS SQL to Access ?

Backup on remote disk

hi gurus,

can any bdy tell me the procedure to create the Backup Device which is a DISK OF REMOTE PC..

i want to take database backup on remote pc's disk not on local disk or tape

i am using sql server 2005

thanks

in advance

I believe you want to backup your db to a remote pcs hard disk.....just perform the following,

1.ensure you run the the sql server using service account instead of local system account

2.ensure that your sql service account has modify privileges in the remote pcs shared folder......

http://msdn2.microsoft.com/en-us/library/ms179313.aspx

refer this command

USE master;
GO
EXEC sp_addumpdevice 'disk', 'networkdevice',
'\\<servername>\<sharename>\<path>\<filename>.bak'

http://msdn2.microsoft.com/en-us/library/ms188409.aspx fyi

just check if those links are useful......

thanks

|||

actually, you do not need to add a dump device, simply execute:

Code Snippet

backup database MyDB to disk = '\\Server\Share\BackupFilename.BAK'

backup on remote computer

Hi

How can i make backup on the other computer.

1. SQL computer is express edition, and computers are in workgroup?

2. SQL computer is express edition and is not on domain, and backup computer is on domain.

thanks

alex

Hi,

you can simply make a backup by connecting to the server and issue a backup command LIEK BACKUP DATABASE (...) the exact syntax can be found in the BOL. if you want to store the backup file on a network share you have to priviledge the user connecting to the SQL Server for writing to the backup directory. The easiest way would be to allow guest or everyone access, the more proficient way would be to privilege the connecting user for accessing the folder.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

You can always use the SMO System in .Net and code a solution, here is a small example, I have not tested it yet but you should be able to see the code needed.

try
{

Server server = new Server(Environment.MachineName + "\SQLExpress");
BackupDeviceItem bdi = new BackupDeviceItem(@."C:\test.bak", DeviceType.File);
Backup backup = new Backup();
backup.Database = "Test";
backup.Devices.Add(bdi);
backup.Action = BackupActionType.Database;
backup.SqlBackup(server);

}
catch(SqlException ex)
{

}

I just saw that you wanted to then Restore it on another computer. You can also do this with the SMO Objects, this way you could have the one solution that could create the replicated database.

There are other options that you could use like replication and standby servers but I do not know about the fuctions in the express products I will have to have a look and see what can be done.

Backup on a remote server

I'm using SQL 7.0 in win2k. I'm using 2 harddisks partitioned into 2 and bo
th partitions are mirrored. One is for system and the other one I'm using f
or database. I'm doing a comlete daily backup of 2 critical databses which
eats up 500MB per database.
My question is, is it possible to use a remote server or storage and configu
re SQL to automatically backup those databases there? Because when I tried
to map a storage that I want to use forthe backups, I didn't see it in the "
choose backup destination
". What I'm basically doing now is to backup the databases in the system pa
rtition on the SQL server and move it to the remote storage manually from ti
me to time. Do you know of any simpler method?
Thank you.You can use a network share, it is just Enterprise Manager that is limited
to local disks, if I remember correctly. With Backup T-SQL statement you can
use remote shares as well. And you can use a scheduled to execute this
command regularly. Do please read about the Backup command and scheduled
jobs in Books OnLine if this is what you need.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jun Soriano" <anonymous@.discussions.microsoft.com> wrote in message
news:4C041E6F-D81D-471A-A27F-C8E501674E41@.microsoft.com...
> I'm using SQL 7.0 in win2k. I'm using 2 harddisks partitioned into 2 and
both partitions are mirrored. One is for system and the other one I'm using
for database. I'm doing a comlete daily backup of 2 critical databses which
eats up 500MB per database. My question is, is it possible to use a remote
server or storage and configure SQL to automatically backup those databases
there? Because when I tried to map a storage that I want to use forthe
backups, I didn't see it in the "choose backup destination". What I'm
basically doing now is to backup the databases in the system partition on
the SQL server and move it to the remote storage manually from time to time.
Do you know of any simpler method?
> Thank you.
>|||Hi,
Enterprise manager will not show the network drives, Steps to perfom a
backup across network and schedule to run,
1. Create a backup device using sp_addumpdevice command (Sp_addumpdevice
'disk','dbname_bak','\\networkservername
\sharename\dbname.bak'
2. Create a batch file (backup.bat)
3. Inside the batch file
net use k: \\networkmachine\sharename /user:OS_username password
isql -Uuser -Ppassword -S server -Q'backup database dbname to
backupdevice with init" (use the device name create in step1)
net use k: /d
4. Save this contents in Backup.bat
5. Schedule this batch file using SQL Agent , In the Job step select the
type as "Operating system command"
Thanks
Hari
MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OMK5poS9DHA.2472@.TK2MSFTNGP10.phx.gbl...
> You can use a network share, it is just Enterprise Manager that is limited
> to local disks, if I remember correctly. With Backup T-SQL statement you
can
> use remote shares as well. And you can use a scheduled to execute this
> command regularly. Do please read about the Backup command and scheduled
> jobs in Books OnLine if this is what you need.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Jun Soriano" <anonymous@.discussions.microsoft.com> wrote in message
> news:4C041E6F-D81D-471A-A27F-C8E501674E41@.microsoft.com...
and
> both partitions are mirrored. One is for system and the other one I'm
using
> for database. I'm doing a comlete daily backup of 2 critical databses
which
> eats up 500MB per database. My question is, is it possible to use a
remote
> server or storage and configure SQL to automatically backup those
databases
> there? Because when I tried to map a storage that I want to use forthe
> backups, I didn't see it in the "choose backup destination". What I'm
> basically doing now is to backup the databases in the system partition on
> the SQL server and move it to the remote storage manually from time to
time.
> Do you know of any simpler method?
>|||Hi,
It works fine to backup to a remote server with a maintenance plan! Just map
a network drive to the remote server share and manually type (browsing won't
work) this drive letter in the "Use this directory" field on the maintenance
plan property page. Don't forget to make the sql server service use an
account with sufficient permissions on the remote server though.
/Roger
"Jun Soriano" <anonymous@.discussions.microsoft.com> wrote in message
news:4C041E6F-D81D-471A-A27F-C8E501674E41@.microsoft.com...
> I'm using SQL 7.0 in win2k. I'm using 2 harddisks partitioned into 2 and
both partitions are mirrored. One is for system and the other one I'm using
for database. I'm doing a comlete daily backup of 2 critical databses which
eats up 500MB per database. My question is, is it possible to use a remote
server or storage and configure SQL to automatically backup those databases
there? Because when I tried to map a storage that I want to use forthe
backups, I didn't see it in the "choose backup destination". What I'm
basically doing now is to backup the databases in the system partition on
the SQL server and move it to the remote storage manually from time to time.
Do you know of any simpler method?
> Thank you.
>

Backup on a remote server

I'm using SQL 7.0 in win2k. I'm using 2 harddisks partitioned into 2 and both partitions are mirrored. One is for system and the other one I'm using for database. I'm doing a comlete daily backup of 2 critical databses which eats up 500MB per database. My question is, is it possible to use a remote server or storage and configure SQL to automatically backup those databases there? Because when I tried to map a storage that I want to use forthe backups, I didn't see it in the "choose backup destination". What I'm basically doing now is to backup the databases in the system partition on the SQL server and move it to the remote storage manually from time to time. Do you know of any simpler method
Thank youYou can use a network share, it is just Enterprise Manager that is limited
to local disks, if I remember correctly. With Backup T-SQL statement you can
use remote shares as well. And you can use a scheduled to execute this
command regularly. Do please read about the Backup command and scheduled
jobs in Books OnLine if this is what you need.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jun Soriano" <anonymous@.discussions.microsoft.com> wrote in message
news:4C041E6F-D81D-471A-A27F-C8E501674E41@.microsoft.com...
> I'm using SQL 7.0 in win2k. I'm using 2 harddisks partitioned into 2 and
both partitions are mirrored. One is for system and the other one I'm using
for database. I'm doing a comlete daily backup of 2 critical databses which
eats up 500MB per database. My question is, is it possible to use a remote
server or storage and configure SQL to automatically backup those databases
there? Because when I tried to map a storage that I want to use forthe
backups, I didn't see it in the "choose backup destination". What I'm
basically doing now is to backup the databases in the system partition on
the SQL server and move it to the remote storage manually from time to time.
Do you know of any simpler method?
> Thank you.
>|||Hi,
Enterprise manager will not show the network drives, Steps to perfom a
backup across network and schedule to run,
1. Create a backup device using sp_addumpdevice command (Sp_addumpdevice
'disk','dbname_bak','\\networkservername\sharename\dbname.bak'
2. Create a batch file (backup.bat)
3. Inside the batch file
net use k: \\networkmachine\sharename /user:OS_username password
isql -Uuser -Ppassword -S server -Q'backup database dbname to
backupdevice with init" (use the device name create in step1)
net use k: /d
4. Save this contents in Backup.bat
5. Schedule this batch file using SQL Agent , In the Job step select the
type as "Operating system command"
Thanks
Hari
MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OMK5poS9DHA.2472@.TK2MSFTNGP10.phx.gbl...
> You can use a network share, it is just Enterprise Manager that is limited
> to local disks, if I remember correctly. With Backup T-SQL statement you
can
> use remote shares as well. And you can use a scheduled to execute this
> command regularly. Do please read about the Backup command and scheduled
> jobs in Books OnLine if this is what you need.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Jun Soriano" <anonymous@.discussions.microsoft.com> wrote in message
> news:4C041E6F-D81D-471A-A27F-C8E501674E41@.microsoft.com...
> > I'm using SQL 7.0 in win2k. I'm using 2 harddisks partitioned into 2
and
> both partitions are mirrored. One is for system and the other one I'm
using
> for database. I'm doing a comlete daily backup of 2 critical databses
which
> eats up 500MB per database. My question is, is it possible to use a
remote
> server or storage and configure SQL to automatically backup those
databases
> there? Because when I tried to map a storage that I want to use forthe
> backups, I didn't see it in the "choose backup destination". What I'm
> basically doing now is to backup the databases in the system partition on
> the SQL server and move it to the remote storage manually from time to
time.
> Do you know of any simpler method?
> >
> > Thank you.
> >
>|||Hi,
It works fine to backup to a remote server with a maintenance plan! Just map
a network drive to the remote server share and manually type (browsing won't
work) this drive letter in the "Use this directory" field on the maintenance
plan property page. Don't forget to make the sql server service use an
account with sufficient permissions on the remote server though.
/Roger
"Jun Soriano" <anonymous@.discussions.microsoft.com> wrote in message
news:4C041E6F-D81D-471A-A27F-C8E501674E41@.microsoft.com...
> I'm using SQL 7.0 in win2k. I'm using 2 harddisks partitioned into 2 and
both partitions are mirrored. One is for system and the other one I'm using
for database. I'm doing a comlete daily backup of 2 critical databses which
eats up 500MB per database. My question is, is it possible to use a remote
server or storage and configure SQL to automatically backup those databases
there? Because when I tried to map a storage that I want to use forthe
backups, I didn't see it in the "choose backup destination". What I'm
basically doing now is to backup the databases in the system partition on
the SQL server and move it to the remote storage manually from time to time.
Do you know of any simpler method?
> Thank you.
>

Backup of SQL DB with Veritas Agents

Help!
We just upgraded to version 10d of the Veritas/Symantec software - part of
upgrade was to update the remote backup exec agent that is used to backup SQ
L
db's.
This is the event log entries for the job that fails.
Source MSSQL Server
Event ID 17055
18210 :
BackupVirtualDeviceSet::Initialize: Open failure on backup device
'master_00__96b4386f_92d9_42ae_8cd2_0063
0edf161d_'. Operating system error
-2147024891(Access is denied.).
---
Source Backup Exec
Event ID 57859
An error occurred while executing the following query: "BACKUP DATABASE
[master] TO virtual_device =
'master_00__96b4386f_92d9_42ae_8cd2_0063
0edf161d_'".
On server: "CD_PA".
SQL error number: "0BC5".
SQL error message: "Backup or restore operation terminating abnormally.
".
For more information, click the following link:
http://eventlookup.veritas.com/even...entLookup.jhtml
The jobs worked until we upgraded... Veritas wants me to make all these
changes... we are only running SQL7.0 no SQL 2000
Anybody have this issue...and had any luck getting it resolved withou
upgrading SQL?
Please advise.
Thanks.
-John
Citigate Cunningham HelpdeskHi
Have you checked account which is running veritas to see whether it has
privileges?
John
"Citigate Cunningham Helpdesk" wrote:

> Help!
> We just upgraded to version 10d of the Veritas/Symantec software - part of
> upgrade was to update the remote backup exec agent that is used to backup
SQL
> db's.
> This is the event log entries for the job that fails.
> Source MSSQL Server
> Event ID 17055
> 18210 :
> BackupVirtualDeviceSet::Initialize: Open failure on backup device
> 'master_00__96b4386f_92d9_42ae_8cd2_0063
0edf161d_'. Operating system error
> -2147024891(Access is denied.).
>
> ---
> Source Backup Exec
> Event ID 57859
> An error occurred while executing the following query: "BACKUP DATABASE
> [master] TO virtual_device =
> 'master_00__96b4386f_92d9_42ae_8cd2_0063
0edf161d_'".
> On server: "CD_PA".
> SQL error number: "0BC5".
> SQL error message: "Backup or restore operation terminating abnormally.
> ".
> For more information, click the following link:
> http://eventlookup.veritas.com/even...entLookup.jhtml
> The jobs worked until we upgraded... Veritas wants me to make all these
> changes... we are only running SQL7.0 no SQL 2000
> Anybody have this issue...and had any luck getting it resolved withou
> upgrading SQL?
> Please advise.
> Thanks.
> -John
> Citigate Cunningham Helpdesk
>|||John,
http://support.microsoft.com/defaul...kb;en-us;280759
Veritas has me trying renaming some of the dll's ... I did update the
Sqlvdi.dll to the 2000 version.. it worked on one server a W2K server but
did not work on the NT40 box.
There were some additonal dlls that it recommended that also get copied
over... this is our finance server... and I don't want to mess it up.
Prior to the upgrade.... from 9.x to 10d it worked fine.
-John
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Have you checked account which is running veritas to see whether it has
> privileges?
> John
> "Citigate Cunningham Helpdesk" wrote:
>|||Hi
If you have the disc space you may want to do away with the agent and just
back up to disc. Then you can schedule the normal file backup to put this
onto tape. Unless absolutly necessary I try an avoid using the agents as the
y
can cause so many issues like yours!
John
"Citigate Cunningham Helpdesk" wrote:
[vbcol=seagreen]
> John,
> http://support.microsoft.com/defaul...kb;en-us;280759
> Veritas has me trying renaming some of the dll's ... I did update the
> Sqlvdi.dll to the 2000 version.. it worked on one server a W2K server but
> did not work on the NT40 box.
> There were some additonal dlls that it recommended that also get copied
> over... this is our finance server... and I don't want to mess it up.
> Prior to the upgrade.... from 9.x to 10d it worked fine.
> -John
> "John Bell" wrote:
>

Backup of SQL DB with Veritas Agents

Help!
We just upgraded to version 10d of the Veritas/Symantec software - part of
upgrade was to update the remote backup exec agent that is used to backup SQL
db's.
This is the event log entries for the job that fails.
Source MSSQL Server
Event ID 17055
18210 :
BackupVirtualDeviceSet::Initialize: Open failure on backup device
'master_00__96b4386f_92d9_42ae_8cd2_00630edf161d_'. Operating system error
-2147024891(Access is denied.).
---
Source Backup Exec
Event ID 57859
An error occurred while executing the following query: "BACKUP DATABASE
[master] TO virtual_device = 'master_00__96b4386f_92d9_42ae_8cd2_00630edf161d_'".
On server: "CD_PA".
SQL error number: "0BC5".
SQL error message: "Backup or restore operation terminating abnormally.
".
For more information, click the following link:
http://eventlookup.veritas.com/eventlookup/EventLookup.jhtml
The jobs worked until we upgraded... Veritas wants me to make all these
changes... we are only running SQL7.0 no SQL 2000
Anybody have this issue...and had any luck getting it resolved withou
upgrading SQL?
Please advise.
Thanks.
-John
Citigate Cunningham HelpdeskHi
Have you checked account which is running veritas to see whether it has
privileges?
John
"Citigate Cunningham Helpdesk" wrote:
> Help!
> We just upgraded to version 10d of the Veritas/Symantec software - part of
> upgrade was to update the remote backup exec agent that is used to backup SQL
> db's.
> This is the event log entries for the job that fails.
> Source MSSQL Server
> Event ID 17055
> 18210 :
> BackupVirtualDeviceSet::Initialize: Open failure on backup device
> 'master_00__96b4386f_92d9_42ae_8cd2_00630edf161d_'. Operating system error
> -2147024891(Access is denied.).
>
> ---
> Source Backup Exec
> Event ID 57859
> An error occurred while executing the following query: "BACKUP DATABASE
> [master] TO virtual_device => 'master_00__96b4386f_92d9_42ae_8cd2_00630edf161d_'".
> On server: "CD_PA".
> SQL error number: "0BC5".
> SQL error message: "Backup or restore operation terminating abnormally.
> ".
> For more information, click the following link:
> http://eventlookup.veritas.com/eventlookup/EventLookup.jhtml
> The jobs worked until we upgraded... Veritas wants me to make all these
> changes... we are only running SQL7.0 no SQL 2000
> Anybody have this issue...and had any luck getting it resolved withou
> upgrading SQL?
> Please advise.
> Thanks.
> -John
> Citigate Cunningham Helpdesk
>|||John,
http://support.microsoft.com/default.aspx?scid=kb;en-us;280759
Veritas has me trying renaming some of the dll's ... I did update the
Sqlvdi.dll to the 2000 version.. it worked on one server a W2K server but
did not work on the NT40 box.
There were some additonal dlls that it recommended that also get copied
over... this is our finance server... and I don't want to mess it up.
Prior to the upgrade.... from 9.x to 10d it worked fine.
-John
"John Bell" wrote:
> Hi
> Have you checked account which is running veritas to see whether it has
> privileges?
> John
> "Citigate Cunningham Helpdesk" wrote:
> > Help!
> >
> > We just upgraded to version 10d of the Veritas/Symantec software - part of
> > upgrade was to update the remote backup exec agent that is used to backup SQL
> > db's.
> >
> > This is the event log entries for the job that fails.
> >
> > Source MSSQL Server
> > Event ID 17055
> > 18210 :
> > BackupVirtualDeviceSet::Initialize: Open failure on backup device
> > 'master_00__96b4386f_92d9_42ae_8cd2_00630edf161d_'. Operating system error
> > -2147024891(Access is denied.).
> >
> >
> > ---
> >
> > Source Backup Exec
> > Event ID 57859
> >
> > An error occurred while executing the following query: "BACKUP DATABASE
> > [master] TO virtual_device => > 'master_00__96b4386f_92d9_42ae_8cd2_00630edf161d_'".
> > On server: "CD_PA".
> > SQL error number: "0BC5".
> > SQL error message: "Backup or restore operation terminating abnormally.
> > ".
> >
> > For more information, click the following link:
> > http://eventlookup.veritas.com/eventlookup/EventLookup.jhtml
> >
> > The jobs worked until we upgraded... Veritas wants me to make all these
> > changes... we are only running SQL7.0 no SQL 2000
> >
> > Anybody have this issue...and had any luck getting it resolved withou
> > upgrading SQL?
> >
> > Please advise.
> >
> > Thanks.
> >
> > -John
> > Citigate Cunningham Helpdesk
> >|||Hi
If you have the disc space you may want to do away with the agent and just
back up to disc. Then you can schedule the normal file backup to put this
onto tape. Unless absolutly necessary I try an avoid using the agents as they
can cause so many issues like yours!
John
"Citigate Cunningham Helpdesk" wrote:
> John,
> http://support.microsoft.com/default.aspx?scid=kb;en-us;280759
> Veritas has me trying renaming some of the dll's ... I did update the
> Sqlvdi.dll to the 2000 version.. it worked on one server a W2K server but
> did not work on the NT40 box.
> There were some additonal dlls that it recommended that also get copied
> over... this is our finance server... and I don't want to mess it up.
> Prior to the upgrade.... from 9.x to 10d it worked fine.
> -John
> "John Bell" wrote:
> > Hi
> >
> > Have you checked account which is running veritas to see whether it has
> > privileges?
> >
> > John
> >
> > "Citigate Cunningham Helpdesk" wrote:
> >
> > > Help!
> > >
> > > We just upgraded to version 10d of the Veritas/Symantec software - part of
> > > upgrade was to update the remote backup exec agent that is used to backup SQL
> > > db's.
> > >
> > > This is the event log entries for the job that fails.
> > >
> > > Source MSSQL Server
> > > Event ID 17055
> > > 18210 :
> > > BackupVirtualDeviceSet::Initialize: Open failure on backup device
> > > 'master_00__96b4386f_92d9_42ae_8cd2_00630edf161d_'. Operating system error
> > > -2147024891(Access is denied.).
> > >
> > >
> > > ---
> > >
> > > Source Backup Exec
> > > Event ID 57859
> > >
> > > An error occurred while executing the following query: "BACKUP DATABASE
> > > [master] TO virtual_device => > > 'master_00__96b4386f_92d9_42ae_8cd2_00630edf161d_'".
> > > On server: "CD_PA".
> > > SQL error number: "0BC5".
> > > SQL error message: "Backup or restore operation terminating abnormally.
> > > ".
> > >
> > > For more information, click the following link:
> > > http://eventlookup.veritas.com/eventlookup/EventLookup.jhtml
> > >
> > > The jobs worked until we upgraded... Veritas wants me to make all these
> > > changes... we are only running SQL7.0 no SQL 2000
> > >
> > > Anybody have this issue...and had any luck getting it resolved withou
> > > upgrading SQL?
> > >
> > > Please advise.
> > >
> > > Thanks.
> > >
> > > -John
> > > Citigate Cunningham Helpdesk
> > >

Backup of Remote SQL 2005 Server

Hello Friends:

My problem relates to backing up my MS SQL 2005 database which is sitting on a shared server at a hosting company.

OVERVIEW:
- Hosting company is using MS SQL 2005
- I am using the SQL Server Management Studio that comes with SQL Server 2005 Standard (NOT Express), which is installed on MY PC.
- So, I am connecting to the SQL server over the internet

WHAT I WANT TO ACHIEVE:
- I would like to backup the data sitting on the Hosting company's MS SQL Server. I only have one database on this SQL Server. There are of course 100s of other databases on the same server which belong to other customers of the hosting company.

- I want to bring the backup to MY PC, from the SQL Server.

- As far as I can tell the following options within SQL Server Management Studio may be of help to me. I do not know which one I should use or which one is best or what is the proper method. 1) Select Backup option from the Tasks menu (but it only shows me drives/devices on the Hosting SQL Server, not my PC, so I cant backup to my PC) 2) Export Data (it does not work, showing errors not a trusted connection I have no clue what a trusted connection is. 3) Copy Database (which is supposed to copy the remote database on the Hosting company SQL server, to my local SQL Server running on my PC). I go through the wizard, on the last screen it just hangs i.e. shows- not responding)

MY QUESTION TO THE COMMUNITY:
How do I backup the database sitting on the hosting company SQL server? I of course need to bring the backup to my PC.What you'll need to check is whether you have access to a folder from SSMS which also can be accessed by other means, eg FTP. If so, you can run a backup to that folder, and then download the backup file. SSMS itself does NOT give access to your local disk drives.

But, why do you want to backup the database yourself, does not the hosting company take backups for you?|||Management studio does not support the UNC path, generally it will show you the local disk to the server. To perform network back up you need to write the TSQL command.
The username by which you login into CMS, requires permission to perform back up and restore. Basically the Admin of hosting company will assign permissions to each and every user. Speak to hosting company Administrator for help.|||Thank you all for your quick reply. My ISP does perform a backup. Then why do I want to do a backup to my local PC?

Well, I am planning to move to a new ISP. And so I need to move my database also. I first need to backup the SQL database (or extract the data) from my existing provider. Then I need to somehow upload the database to the new provider.

I am sure this is a very common issue. People must on occasions move from one hosting provider to another, and if they have a database they will not want to lose all the data.

Since I posted my first message, I signed-up with 3 ISPs. It did not work with 2 of them, and tech support could not tell me what to do. Then I signed up with Network Solutions, and I can now at least Export the data.

Copy Database still does not work. But I think I know why. Since there are 100s of other databases on the same server (and I do not have access to them) the Copy Database wizard probably tries to access them while displaying the list (which it does when it asks you for the Source Database).

I think a user with Sysadmin rights would be able to run Copy Database, but getting those rights of course would not be possible in a shared hosting environment.

Over the last several days, I have called the Tech Support of most major hosting companies in US, UK, CA, and some countries in Europe. I was able to speak to 'real tech humans' in each company. But surprisingly NOT EVEN ONE could answer my questions, or even shed some light on the issue. They were completely clueless!!

It seems either no one changes hosting companies or no one has any important data to backup or everyone who knows about these issues uses only dedicated servers (which cost lot more money). Either way, the tech support in these hosting companies (most of whom have at least 200 employees and $4million+ turnover) had little idea about what I was talking about. Network Solutions seems to be the best and has techs available 24X7, and atleast they all speak clearly and try to help.

By the way I have been in IT for 20 years, I did make sure I was asking the questions clearly.|||why not create a share from the host to your machine, open a query session and use t-sql to backup the database to your machine?

Why does it have to be GUi based?|||This might be an easy answer to a complicated question/issue-- but I've used a free tool for backup that has proved to be actually high-performance stuff... can be downloaded free at: www.idera.com/freetools, and its called SQLsafe Freeware Edition.

Hope that can do the trick, why not, its the right price... free. ha!

Enjoy, and let me know how it works for you.

Backup of databases

Hi
I would like to know if is possible to do a traditional backup to tape
every day as full database and also remote backup. The remote backup as the
comunications are not very good should be the first time full but the other
days should be differential. Is possible to have both backups mode as I
explain ?. Or only will I have one method to do a backup?. I never work with
SQL and I don't know if this configuration could be done.
Thanks in advance
> I would like to know if is possible to do a traditional backup to tape
> every day as full database and also remote backup.
Yes. You do two backups, one to tape, the other to disk on a share on another machine (or locally
and then copying the file).

>The remote backup as the
> comunications are not very good should be the first time full but the other
> days should be differential. Is possible to have both backups mode as I
> explain ?
YEs, but there's no automation that does it for you. You have to create your own scripts/jobs to
handle this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Juanchu" <Juanchu@.discussions.microsoft.com> wrote in message
news:6B96D8B2-83C5-415B-830C-C85B043FD4E4@.microsoft.com...
> Hi
> I would like to know if is possible to do a traditional backup to tape
> every day as full database and also remote backup. The remote backup as the
> comunications are not very good should be the first time full but the other
> days should be differential. Is possible to have both backups mode as I
> explain ?. Or only will I have one method to do a backup?. I never work with
> SQL and I don't know if this configuration could be done.
> Thanks in advance

Backup of databases

Hi
I would like to know if is possible to do a traditional backup to tape
every day as full database and also remote backup. The remote backup as the
comunications are not very good should be the first time full but the other
days should be differential. Is possible to have both backups mode as I
explain ?. Or only will I have one method to do a backup?. I never work with
SQL and I don't know if this configuration could be done.
Thanks in advance> I would like to know if is possible to do a traditional backup to tape
> every day as full database and also remote backup.
Yes. You do two backups, one to tape, the other to disk on a share on anothe
r machine (or locally
and then copying the file).

>The remote backup as the
> comunications are not very good should be the first time full but the othe
r
> days should be differential. Is possible to have both backups mode as I
> explain ?
YEs, but there's no automation that does it for you. You have to create your
own scripts/jobs to
handle this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Juanchu" <Juanchu@.discussions.microsoft.com> wrote in message
news:6B96D8B2-83C5-415B-830C-C85B043FD4E4@.microsoft.com...
> Hi
> I would like to know if is possible to do a traditional backup to tape
> every day as full database and also remote backup. The remote backup as th
e
> comunications are not very good should be the first time full but the othe
r
> days should be differential. Is possible to have both backups mode as I
> explain ?. Or only will I have one method to do a backup?. I never work wi
th
> SQL and I don't know if this configuration could be done.
> Thanks in advance

Backup of databases

Hi
I would like to know if is possible to do a traditional backup to tape
every day as full database and also remote backup. The remote backup as the
comunications are not very good should be the first time full but the other
days should be differential. Is possible to have both backups mode as I
explain ?. Or only will I have one method to do a backup?. I never work with
SQL and I don't know if this configuration could be done.
Thanks in advance> I would like to know if is possible to do a traditional backup to tape
> every day as full database and also remote backup.
Yes. You do two backups, one to tape, the other to disk on a share on another machine (or locally
and then copying the file).
>The remote backup as the
> comunications are not very good should be the first time full but the other
> days should be differential. Is possible to have both backups mode as I
> explain ?
YEs, but there's no automation that does it for you. You have to create your own scripts/jobs to
handle this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Juanchu" <Juanchu@.discussions.microsoft.com> wrote in message
news:6B96D8B2-83C5-415B-830C-C85B043FD4E4@.microsoft.com...
> Hi
> I would like to know if is possible to do a traditional backup to tape
> every day as full database and also remote backup. The remote backup as the
> comunications are not very good should be the first time full but the other
> days should be differential. Is possible to have both backups mode as I
> explain ?. Or only will I have one method to do a backup?. I never work with
> SQL and I don't know if this configuration could be done.
> Thanks in advance

backup job step from remote server

I want to run a backup of a database against a remote server through a SQL
Agent job.
So I have the following TSQL Command in my job step. I know it works, but is
there something better ?
xp_cmdshell 'sqlcmd -S ServerA -Q "backup database test to disk =
''M:\backups\test.bak'' with init "'
You could just do an OS cmd step and skip the xp_cmdshell. Or a linked
server with the proper permissions. I am not sure if those are much better
though...
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"Hassan" <hassan@.test.com> wrote in message
news:epMGCADRIHA.4684@.TK2MSFTNGP02.phx.gbl...
>I want to run a backup of a database against a remote server through a SQL
>Agent job.
> So I have the following TSQL Command in my job step. I know it works, but
> is there something better ?
> xp_cmdshell 'sqlcmd -S ServerA -Q "backup database test to disk =
> ''M:\backups\test.bak'' with init "'

backup job step from remote server

I want to run a backup of a database against a remote server through a SQL
Agent job.
So I have the following TSQL Command in my job step. I know it works, but is
there something better ?
xp_cmdshell 'sqlcmd -S ServerA -Q "backup database test to disk =
''M:\backups\test.bak'' with init "'You could just do an OS cmd step and skip the xp_cmdshell. Or a linked
server with the proper permissions. I am not sure if those are much better
though...
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"Hassan" <hassan@.test.com> wrote in message
news:epMGCADRIHA.4684@.TK2MSFTNGP02.phx.gbl...
>I want to run a backup of a database against a remote server through a SQL
>Agent job.
> So I have the following TSQL Command in my job step. I know it works, but
> is there something better ?
> xp_cmdshell 'sqlcmd -S ServerA -Q "backup database test to disk =
> ''M:\backups\test.bak'' with init "'

backup job step from remote server

I want to run a backup of a database against a remote server through a SQL
Agent job.
So I have the following TSQL Command in my job step. I know it works, but is
there something better ?
xp_cmdshell 'sqlcmd -S ServerA -Q "backup database test to disk = ''M:\backups\test.bak'' with init "'You could just do an OS cmd step and skip the xp_cmdshell. Or a linked
server with the proper permissions. I am not sure if those are much better
though...
--
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"Hassan" <hassan@.test.com> wrote in message
news:epMGCADRIHA.4684@.TK2MSFTNGP02.phx.gbl...
>I want to run a backup of a database against a remote server through a SQL
>Agent job.
> So I have the following TSQL Command in my job step. I know it works, but
> is there something better ?
> xp_cmdshell 'sqlcmd -S ServerA -Q "backup database test to disk => ''M:\backups\test.bak'' with init "'

Backup from Remote DB and Restore to Local DB in a job

I am trying to create a job that will backup from one system and then
restore it to second system. However I am having trouble will the
commands. I know I can do it using OSQL but I would like to place it
into a job for reuse, and logging, and that is where I am having the
problem. I know I can simply state in the job
BACKUP DATABASE DB TO DISK = '\\server2\f$\DB_full.bak'
But this will only do it for the local system. If I try to run it as an
OSQL command inside the Job, and point it to a second system,
osql -S server1 -E -Q "BACKUP DATABASE DB TO DISK =
'\\server2\f$\DB_full.bak'"
I get the error "Incorrect syntax near 'S'."
I know that you can backup from one server to another using the wizard,
but what is the command line?
Thanks
-Matt-
You have to run this as a command file not as sql from within the job. Try
stuffing into a variable and running an execute sql process shelling out
using xp_cmdshell.
"Matthew" wrote:

> I am trying to create a job that will backup from one system and then
> restore it to second system. However I am having trouble will the
> commands. I know I can do it using OSQL but I would like to place it
> into a job for reuse, and logging, and that is where I am having the
> problem. I know I can simply state in the job
> BACKUP DATABASE DB TO DISK = '\\server2\f$\DB_full.bak'
> But this will only do it for the local system. If I try to run it as an
> OSQL command inside the Job, and point it to a second system,
> osql -S server1 -E -Q "BACKUP DATABASE DB TO DISK =
> '\\server2\f$\DB_full.bak'"
> I get the error "Incorrect syntax near 'S'."
> I know that you can backup from one server to another using the wizard,
> but what is the command line?
> Thanks
> -Matt-
>

Backup from Remote DB and Restore to Local DB in a job

I am trying to create a job that will backup from one system and then
restore it to second system. However I am having trouble will the
commands. I know I can do it using OSQL but I would like to place it
into a job for reuse, and logging, and that is where I am having the
problem. I know I can simply state in the job
BACKUP DATABASE DB TO DISK = '\\server2\f$\DB_full.bak'
But this will only do it for the local system. If I try to run it as an
OSQL command inside the Job, and point it to a second system,
osql -S server1 -E -Q "BACKUP DATABASE DB TO DISK =
'\\server2\f$\DB_full.bak'"
I get the error "Incorrect syntax near 'S'."
I know that you can backup from one server to another using the wizard,
but what is the command line?
Thanks
-Matt-You have to run this as a command file not as sql from within the job. Try
stuffing into a variable and running an execute sql process shelling out
using xp_cmdshell.
"Matthew" wrote:

> I am trying to create a job that will backup from one system and then
> restore it to second system. However I am having trouble will the
> commands. I know I can do it using OSQL but I would like to place it
> into a job for reuse, and logging, and that is where I am having the
> problem. I know I can simply state in the job
> BACKUP DATABASE DB TO DISK = '\\server2\f$\DB_full.bak'
> But this will only do it for the local system. If I try to run it as an
> OSQL command inside the Job, and point it to a second system,
> osql -S server1 -E -Q "BACKUP DATABASE DB TO DISK =
> '\\server2\f$\DB_full.bak'"
> I get the error "Incorrect syntax near 'S'."
> I know that you can backup from one server to another using the wizard,
> but what is the command line?
> Thanks
> -Matt-
>

Backup from Remote DB and Restore to Local DB in a job

I am trying to create a job that will backup from one system and then
restore it to second system. However I am having trouble will the
commands. I know I can do it using OSQL but I would like to place it
into a job for reuse, and logging, and that is where I am having the
problem. I know I can simply state in the job
BACKUP DATABASE DB TO DISK = '\\server2\f$\DB_full.bak'
But this will only do it for the local system. If I try to run it as an
OSQL command inside the Job, and point it to a second system,
osql -S server1 -E -Q "BACKUP DATABASE DB TO DISK = '\\server2\f$\DB_full.bak'"
I get the error "Incorrect syntax near 'S'."
I know that you can backup from one server to another using the wizard,
but what is the command line?
Thanks
-Matt-You have to run this as a command file not as sql from within the job. Try
stuffing into a variable and running an execute sql process shelling out
using xp_cmdshell.
"Matthew" wrote:
> I am trying to create a job that will backup from one system and then
> restore it to second system. However I am having trouble will the
> commands. I know I can do it using OSQL but I would like to place it
> into a job for reuse, and logging, and that is where I am having the
> problem. I know I can simply state in the job
> BACKUP DATABASE DB TO DISK = '\\server2\f$\DB_full.bak'
> But this will only do it for the local system. If I try to run it as an
> OSQL command inside the Job, and point it to a second system,
> osql -S server1 -E -Q "BACKUP DATABASE DB TO DISK => '\\server2\f$\DB_full.bak'"
> I get the error "Incorrect syntax near 'S'."
> I know that you can backup from one server to another using the wizard,
> but what is the command line?
> Thanks
> -Matt-
>