Database Backup

I am new to SQL Server, is it possible to back-up a database or even
individual tables to a server that does not have SQL Server installed? I
want this to be an automated process so that daily updates to the database
can be pickup by our back-up system that runs on a seperate server.
Thanks
Alex
If I understand your question, "tes". You can backup you SQL DB's to another
box that doesnt have SQL installed.
TIA,
ChrisR
"Alex" wrote:

> I am new to SQL Server, is it possible to back-up a database or even
> individual tables to a server that does not have SQL Server installed? I
> want this to be an automated process so that daily updates to the database
> can be pickup by our back-up system that runs on a seperate server.
> Thanks
> Alex
|||You can not backup tables directly but any SQL Server backup can be sent to
a remote share or network location as long as the account SQL Server is
using has the permissions to access that share. Always use UNC notion and
not mapped drives.
Andrew J. Kelly SQL MVP
"Alex" <Alex@.discussions.microsoft.com> wrote in message
news:3582FBB0-D1C7-42BE-902D-494B35328BCB@.microsoft.com...
>I am new to SQL Server, is it possible to back-up a database or even
> individual tables to a server that does not have SQL Server installed? I
> want this to be an automated process so that daily updates to the database
> can be pickup by our back-up system that runs on a seperate server.
> Thanks
> Alex
|||Alex,
Use DTS or BCP (OUT) to copy the data out to a file.
HTH
Jerry
"Alex" <Alex@.discussions.microsoft.com> wrote in message
news:3582FBB0-D1C7-42BE-902D-494B35328BCB@.microsoft.com...
>I am new to SQL Server, is it possible to back-up a database or even
> individual tables to a server that does not have SQL Server installed? I
> want this to be an automated process so that daily updates to the database
> can be pickup by our back-up system that runs on a seperate server.
> Thanks
> Alex
|||Hi,
You can backup the database using UNC names in the Backup database command.
Prerequsites to do a backup remotely
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
For table wise backup use:- DTS or BCP OUT.
Thanks
Hari
SQL Server MVP
"Alex" <Alex@.discussions.microsoft.com> wrote in message
news:3582FBB0-D1C7-42BE-902D-494B35328BCB@.microsoft.com...
>I am new to SQL Server, is it possible to back-up a database or even
> individual tables to a server that does not have SQL Server installed? I
> want this to be an automated process so that daily updates to the database
> can be pickup by our back-up system that runs on a seperate server.
> Thanks
> Alex