Backup database to CSV files

Hi

What is the easiest option for Exporting ALL of my SQL Server tables into a CSV file (either separate CSV files for each table or one big file with all the table columns and data) ?

I just want to Backup my SQL Server database like we backup MySQL database using phpMyAdmin. Unfortunately, my SQL hosting company does not allow backups for free.

Thanks for help

Do you have a remote access via the SQL Management Studio?

Also, FREE backup can be provided by any hosting company nowadays.

Regards

Backup Database and Backup Log concurrently

Hi
Silly question - can I just confirm that it is not possible to do
backup database and backup log concurrently (on 2 separate
connections), even if the backup db doesn't truncate log.
If backup kicked off after the DB backup, the log seems to block
waiting for the backup db (to tape) to complete before the Backup Log
even starts.
Thanks in Advance
StuartNo, it is not possible to do database backup and log backup concurrently in
SQL Server 2000. Here is the supporting statement from BOL (BACKUP LOG):
'The transaction log cannot be backed up during a full database backup or a
differential database backup. However, the transaction log can be backed up
while a file backup is running.'
"NonNB" wrote:
> Hi
> Silly question - can I just confirm that it is not possible to do
> backup database and backup log concurrently (on 2 separate
> connections), even if the backup db doesn't truncate log.
> If backup kicked off after the DB backup, the log seems to block
> waiting for the backup db (to tape) to complete before the Backup Log
> even starts.
> Thanks in Advance
> Stuart
>|||Thanks. Any idea whether file backup implies a local SQL backup to DUMP
to a disk or meaning OS backup of files. Reason I ask is that a remote
(Veritas) tape SQL backup seems to be preventing our log shipping
working (which has otherwise worked for 3 years). It seemed to be more
"I/O" efficient going direct SQL -> tape, instead of SQL -> Dump ->
Tape but direct to tape is taking much longer than anticipated. The
DUMP usually finished quickly, so never really had a problem with LOG
and DB backups overlapping before.
Stuart|||The term 'file backup' in my previous reply means backup of database files in
sql server. It is just another type of backup for databases in sql server.
For example, if a particular database has 2 database files, they can be
backed up separately. Generally, we use only following backups in sql server:
Database Backup (also called Full Backup), Differential Backup and Log
Backup.
Now a bit about your backup to tape. I understand that you have been backing
up the database directly to tape, and it is now taking more time. Perhaps,
the database size has increased over the time and hence it is taking more
time. What is the size of your database? When do you take the Full Backup?
How much time the Full Backup takes? Is lots of user activities going on in
your database all the time, or there is less user activity during the night
time?
"NonNB" wrote:
> Thanks. Any idea whether file backup implies a local SQL backup to DUMP
> to a disk or meaning OS backup of files. Reason I ask is that a remote
> (Veritas) tape SQL backup seems to be preventing our log shipping
> working (which has otherwise worked for 3 years). It seemed to be more
> "I/O" efficient going direct SQL -> tape, instead of SQL -> Dump ->
> Tape but direct to tape is taking much longer than anticipated. The
> DUMP usually finished quickly, so never really had a problem with LOG
> and DB backups overlapping before.
> Stuart|||Found the issue - some clot plugged the 1 Ghz NIC into a PCI 100 slot
on the remote box with the tape drive - this geared the NIC down to
100Mbps and limited throughput to about 4MBps instead of 15-20MBps
Have confirmed that backup log is blocked (but does not fail) until the
tape BACKUP DATABASE has completed..
Thx again

backup and restore

On a production server, I do a full backup monthly and then delete data
from the tables that is older than the current date. On a separate
non-production server I restored the initial full backup. My question
is how can I add/restore the subsequent backups to the non-production
server with out stepping on the data that was initially restored?
Thanks,
Daniel<danielsmith611@.gmail.com> wrote in message
news:1155141011.175566.161350@.m73g2000cwd.googlegroups.com...
> On a production server, I do a full backup monthly and then delete data
> from the tables that is older than the current date. On a separate
> non-production server I restored the initial full backup. My question
> is how can I add/restore the subsequent backups to the non-production
> server with out stepping on the data that was initially restored?
>
RESTORE WITH MOVE, followed perhaps by merging the data.
EG
BACKUP DATABASE AdventureWorks
TO AdventureWorksBackups ;
RESTORE DATABASE AdventureWorks_200608
FROM AdventureWorksBackups
WITH MOVE 'AdventureWorks_Data' TO
'C:\MySQLServer\AdventureWorks_200608.mdf',
MOVE 'AdventureWorks_Log' TO 'C:\MySQLServer\AdventureWorks_200608.ldf';
David|||Do you have an example of the merge?
David Browne wrote:
> <danielsmith611@.gmail.com> wrote in message
> news:1155141011.175566.161350@.m73g2000cwd.googlegroups.com...
> > On a production server, I do a full backup monthly and then delete data
> > from the tables that is older than the current date. On a separate
> > non-production server I restored the initial full backup. My question
> > is how can I add/restore the subsequent backups to the non-production
> > server with out stepping on the data that was initially restored?
> >
>
> RESTORE WITH MOVE, followed perhaps by merging the data.
>
> EG
> BACKUP DATABASE AdventureWorks
> TO AdventureWorksBackups ;
>
> RESTORE DATABASE AdventureWorks_200608
> FROM AdventureWorksBackups
> WITH MOVE 'AdventureWorks_Data' TO
> 'C:\MySQLServer\AdventureWorks_200608.mdf',
> MOVE 'AdventureWorks_Log' TO 'C:\MySQLServer\AdventureWorks_200608.ldf';
>
> David|||Or would log shipping work?
danielp wrote:
> Do you have an example of the merge?
> David Browne wrote:
> > <danielsmith611@.gmail.com> wrote in message
> > news:1155141011.175566.161350@.m73g2000cwd.googlegroups.com...
> > > On a production server, I do a full backup monthly and then delete data
> > > from the tables that is older than the current date. On a separate
> > > non-production server I restored the initial full backup. My question
> > > is how can I add/restore the subsequent backups to the non-production
> > > server with out stepping on the data that was initially restored?
> > >
> >
> >
> > RESTORE WITH MOVE, followed perhaps by merging the data.
> >
> >
> > EG
> >
> > BACKUP DATABASE AdventureWorks
> > TO AdventureWorksBackups ;
> >
> >
> > RESTORE DATABASE AdventureWorks_200608
> > FROM AdventureWorksBackups
> > WITH MOVE 'AdventureWorks_Data' TO
> > 'C:\MySQLServer\AdventureWorks_200608.mdf',
> > MOVE 'AdventureWorks_Log' TO 'C:\MySQLServer\AdventureWorks_200608.ldf';
> >
> >
> > David|||"danielp" <danielsmith611@.gmail.com> wrote in message
news:1155158638.423828.3310@.h48g2000cwc.googlegroups.com...
> Or would log shipping work?
No. Your deletes would get shipped.
David|||"danielp" <danielsmith611@.gmail.com> wrote in message
news:1155149678.373420.184490@.i3g2000cwc.googlegroups.com...
> Do you have an example of the merge?
It's just SQL, or perhaps an SSIS package. What do the tables look like?
David