Copy file on network

I have a job which call a SP and that SP generates a excel file dump using
bcp. Now form my website i want to access that excel file. Both my webserver
and db server is on different meachine.
How can i achive this?
can BCP generate output on network. Or can i copy generated file to
webserver using some command through SP ?Vikram
If I understood properly , you can create a linked server to EXCEL file.
HOWTO: Use Excel w/ SQL Linked Servers &
Distributed Queries
http://support.microsoft.com/suppor...s/q306/3/97.asp
"Vikram" <aa@.aa> wrote in message
news:uNVc7FPPGHA.1460@.TK2MSFTNGP10.phx.gbl...
>I have a job which call a SP and that SP generates a excel file dump using
> bcp. Now form my website i want to access that excel file. Both my
> webserver
> and db server is on different meachine.
> How can i achive this?
> can BCP generate output on network. Or can i copy generated file to
> webserver using some command through SP ?
>
>|||But in linked server i have to have excel file. But i do not want this, i
want to have excel file generated by bcp...
any other way ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ehRxqMPPGHA.456@.TK2MSFTNGP15.phx.gbl...
> Vikram
> If I understood properly , you can create a linked server to EXCEL file.
> HOWTO: Use Excel w/ SQL Linked Servers &
> Distributed Queries
> http://support.microsoft.com/suppor...s/q306/3/97.asp
>
>
> "Vikram" <aa@.aa> wrote in message
> news:uNVc7FPPGHA.1460@.TK2MSFTNGP10.phx.gbl...
using
>|||DTS?
"Vikram" <aa@.aa> wrote in message
news:%23izbiaPPGHA.3164@.TK2MSFTNGP11.phx.gbl...
> But in linked server i have to have excel file. But i do not want this, i
> want to have excel file generated by bcp...
> any other way ?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ehRxqMPPGHA.456@.TK2MSFTNGP15.phx.gbl...
> using
>|||NO I am suing BCP , calling it from sp using xp_cmdshell
I dont want to use DTS as sp whic return data use temp table and also i have
many sp whose data i have to export to excel
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%2370krlPPGHA.2124@.TK2MSFTNGP14.phx.gbl...
> DTS?
>
> "Vikram" <aa@.aa> wrote in message
> news:%23izbiaPPGHA.3164@.TK2MSFTNGP11.phx.gbl...
i
file.
>|||> How can i achive this?
> can BCP generate output on network. Or can i copy generated file to
> webserver using some command through SP ?
UNC path depending on your permissions.
EXEC master..xp_cmdshell "bcp DB.dbo.Table out
\\SERVER1\Share\test.xls -c -T"
ftp via xp_cmdshell could work.

Copy Database from v8 to v9 SQL Server

Hi dear devs, admins or users!

I have following problem with the "SQL Server 2005 Developer Edition". I am in a small network and try to copy a database from a version 8.0 to a version 9.0 "SQL Server" (2 computers). I use the "Copy Database Wizard" and the process did 4 from 5 actions correctly, the last action with the name "Execute SQL Server Agent Job" fails allways. My "SQL Server Agent" process is started and runs well. In real I don't need the "SQL Server Agent" in any way in my database, so I don't understand why this process generates this error. I try to copy this old "Portal" "ASP.NET 1.1" database to my new "SQL Server 2005". Can someone help me?.

Thanks

Arzu Bazman · «US DEV United Systems»

You can try to detach your database in SQL Server 2000 and go to the folder where your database's .mdf and .ldf are located to copy them. Then paste the copied files to your SQL Server 2005 data file folder (somewhere like: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\). Go to the MS management Studio and retach the database. The database should be ready to go.

Or you can back up your database and restore it in your new server.

HTH.

|||

msbazman:

Hi dear devs, admins or users!

I have following problem with the "SQL Server 2005 Developer Edition". I am in a small network and try to copy a database from a version 8.0 to a version 9.0 "SQL Server" (2 computers). I use the "Copy Database Wizard" and the process did 4 from 5 actions correctly, the last action with the name "Execute SQL Server Agent Job" fails allways. My "SQL Server Agent" process is started and runs well. In real I don't need the "SQL Server Agent" in any way in my database, so I don't understand why this process generates this error. I try to copy this old "Portal" "ASP.NET 1.1" database to my new "SQL Server 2005". Can someone help me?.

Thanks

Arzu Bazman · «US DEV United Systems»

The Agent is not related unless you tried to schedule the move, here is what you do depending on your needs, register the 2000 with the 2005 in Management Studio right click all task then Backup the database in 2000 locally and then restore it in the 2005 in the Backup and Restore wizard choose the restore from device option, SQL Server will ask you if you want to keep 2000 compatibility choose what you need. Hope this helps.

Copy database backup files over the network

Hello!
We are using SQLSafe software to backup/compress our databases. We would
like to copy backup files (could be as big as 400GB compressed) to the
different computer within the same network. I know there are tools like
robocopy,xcopy etc. that are suitable for this job. I was wondering if
anybody can share his/her own experience in copying big backup files.
Ideally, we wouldn't like to saturate our network/cpu resources while
copying these files.
Thanks,
Igor
Hi
I find it best to have the backup software stripe the backup over multiple
files. This enables you to re-start a failed copy without having to re-copy
all 399GB
Also, add a dedicated NIC (Fiber, 1GBit or faster) onto the 2 servers, so
that they do not copy this file over the production network, affecting normal
queries.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"imarchenko" wrote:

> Hello!
> We are using SQLSafe software to backup/compress our databases. We would
> like to copy backup files (could be as big as 400GB compressed) to the
> different computer within the same network. I know there are tools like
> robocopy,xcopy etc. that are suitable for this job. I was wondering if
> anybody can share his/her own experience in copying big backup files.
> Ideally, we wouldn't like to saturate our network/cpu resources while
> copying these files.
> Thanks,
> Igor
>
>
|||Thanks Mike! We are striping backup over multiple files. We just want to
copy backup to the different computer, once it si completed, in the most
efficient way. Thanks for your tip regarding dedicated NIC.
Igor
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:E6EB48F8-4D11-48DD-B2A2-FA1F46334344@.microsoft.com...[vbcol=seagreen]
> Hi
> I find it best to have the backup software stripe the backup over multiple
> files. This enables you to re-start a failed copy without having to
> re-copy
> all 399GB
> Also, add a dedicated NIC (Fiber, 1GBit or faster) onto the 2 servers, so
> that they do not copy this file over the production network, affecting
> normal
> queries.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "imarchenko" wrote:

Copy database backup files over the network

Hello!
We are using SQLSafe software to backup/compress our databases. We would
like to copy backup files (could be as big as 400GB compressed) to the
different computer within the same network. I know there are tools like
robocopy,xcopy etc. that are suitable for this job. I was wondering if
anybody can share his/her own experience in copying big backup files.
Ideally, we wouldn't like to saturate our network/cpu resources while
copying these files.
Thanks,
IgorHi
I find it best to have the backup software stripe the backup over multiple
files. This enables you to re-start a failed copy without having to re-copy
all 399GB
Also, add a dedicated NIC (Fiber, 1GBit or faster) onto the 2 servers, so
that they do not copy this file over the production network, affecting norma
l
queries.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"imarchenko" wrote:

> Hello!
> We are using SQLSafe software to backup/compress our databases. We woul
d
> like to copy backup files (could be as big as 400GB compressed) to the
> different computer within the same network. I know there are tools like
> robocopy,xcopy etc. that are suitable for this job. I was wondering if
> anybody can share his/her own experience in copying big backup files.
> Ideally, we wouldn't like to saturate our network/cpu resources while
> copying these files.
> Thanks,
> Igor
>
>|||Thanks Mike! We are striping backup over multiple files. We just want to
copy backup to the different computer, once it si completed, in the most
efficient way. Thanks for your tip regarding dedicated NIC.
Igor
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:E6EB48F8-4D11-48DD-B2A2-FA1F46334344@.microsoft.com...[vbcol=seagreen]
> Hi
> I find it best to have the backup software stripe the backup over multiple
> files. This enables you to re-start a failed copy without having to
> re-copy
> all 399GB
> Also, add a dedicated NIC (Fiber, 1GBit or faster) onto the 2 servers, so
> that they do not copy this file over the production network, affecting
> normal
> queries.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "imarchenko" wrote:
>

Copy database backup files over the network

Hello!
We are using SQLSafe software to backup/compress our databases. We would
like to copy backup files (could be as big as 400GB compressed) to the
different computer within the same network. I know there are tools like
robocopy,xcopy etc. that are suitable for this job. I was wondering if
anybody can share his/her own experience in copying big backup files.
Ideally, we wouldn't like to saturate our network/cpu resources while
copying these files.
Thanks,
IgorHi
I find it best to have the backup software stripe the backup over multiple
files. This enables you to re-start a failed copy without having to re-copy
all 399GB
Also, add a dedicated NIC (Fiber, 1GBit or faster) onto the 2 servers, so
that they do not copy this file over the production network, affecting normal
queries.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"imarchenko" wrote:
> Hello!
> We are using SQLSafe software to backup/compress our databases. We would
> like to copy backup files (could be as big as 400GB compressed) to the
> different computer within the same network. I know there are tools like
> robocopy,xcopy etc. that are suitable for this job. I was wondering if
> anybody can share his/her own experience in copying big backup files.
> Ideally, we wouldn't like to saturate our network/cpu resources while
> copying these files.
> Thanks,
> Igor
>
>|||Thanks Mike! We are striping backup over multiple files. We just want to
copy backup to the different computer, once it si completed, in the most
efficient way. Thanks for your tip regarding dedicated NIC.
Igor
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:E6EB48F8-4D11-48DD-B2A2-FA1F46334344@.microsoft.com...
> Hi
> I find it best to have the backup software stripe the backup over multiple
> files. This enables you to re-start a failed copy without having to
> re-copy
> all 399GB
> Also, add a dedicated NIC (Fiber, 1GBit or faster) onto the 2 servers, so
> that they do not copy this file over the production network, affecting
> normal
> queries.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "imarchenko" wrote:
>> Hello!
>> We are using SQLSafe software to backup/compress our databases. We
>> would
>> like to copy backup files (could be as big as 400GB compressed) to the
>> different computer within the same network. I know there are tools like
>> robocopy,xcopy etc. that are suitable for this job. I was wondering if
>> anybody can share his/her own experience in copying big backup files.
>> Ideally, we wouldn't like to saturate our network/cpu resources while
>> copying these files.
>> Thanks,
>> Igor
>>

Copy Backup file

hi,
I have a problem copying 12 Gb database backup files (2) for network backup
copy from the SAN. I used xp_cmdshell ' copy ...' to copy the backup files
every day night. Sometimes, the files are not copied over the network. I have
full backup every day night and log backup every hour. Can any one suggest a
good solution for copying the backup files out of SAN, (cost effective
solution, without buying software. I dont have a differential backups right
now because of storage space. )
thanks
kris
"kpxus" <kpxus@.discussions.microsoft.com> wrote in message
news:8EA2A0EA-61CB-446D-906D-8C9D7BCD96B9@.microsoft.com...
> hi,
> I have a problem copying 12 Gb database backup files (2) for network
backup
> copy from the SAN. I used xp_cmdshell ' copy ...' to copy the backup
files
> every day night. Sometimes, the files are not copied over the network. I
have
> full backup every day night and log backup every hour. Can any one suggest
a
> good solution for copying the backup files out of SAN, (cost effective
> solution, without buying software. I dont have a differential backups
right
> now because of storage space. )
>
> thanks
> kris
>
Kris,
Several things come to mind. You could make smaller backups by creating
filegroups and doing filegroup backups on a rotational schedule. Check them
out in the BOL. Faster backups, smaller backups, quicker recovery and
fairly straightforward to use.
You could use the Windows scheduler to copy the files around.
There are shareware/freeware .NET Windows Service apps that can copy files
from just about any location to any other location and include encryption
etc.
Rick Sawtell
MCT, MCSD, MCDBA
|||Hi,
You could write a small DOS script (batch file) to copy files from one
location to other and schedule the batch file via windows schedular. For
example:
On the destination server create a batch like:
copy \\server_name\Share_Name\directory_or_filenames
destination_path(E:\sqlbackups\
Test this out. It will work properly.
hth
DeeJay Puar
"kpxus" wrote:

> hi,
> I have a problem copying 12 Gb database backup files (2) for network backup
> copy from the SAN. I used xp_cmdshell ' copy ...' to copy the backup files
> every day night. Sometimes, the files are not copied over the network. I have
> full backup every day night and log backup every hour. Can any one suggest a
> good solution for copying the backup files out of SAN, (cost effective
> solution, without buying software. I dont have a differential backups right
> now because of storage space. )
>
> thanks
> kris
>
|||Thanks
"DeeJay Puar" <DeeJayPuar@.discussions.microsoft.com> wrote in message
news:30CD919E-39BD-408F-9A9E-239FA9F62BA7@.microsoft.com...[vbcol=seagreen]
> Hi,
> You could write a small DOS script (batch file) to copy files from one
> location to other and schedule the batch file via windows schedular. For
> example:
> On the destination server create a batch like:
> copy \\server_name\Share_Name\directory_or_filenames
> destination_path(E:\sqlbackups\
> Test this out. It will work properly.
> hth
> DeeJay Puar
>
> "kpxus" wrote:
backup[vbcol=seagreen]
files[vbcol=seagreen]
have[vbcol=seagreen]
suggest a[vbcol=seagreen]
right[vbcol=seagreen]

Copy Backup file

hi,
I have a problem copying 12 Gb database backup files (2) for network backup
copy from the SAN. I used xp_cmdshell ' copy ...' to copy the backup files
every day night. Sometimes, the files are not copied over the network. I have
full backup every day night and log backup every hour. Can any one suggest a
good solution for copying the backup files out of SAN, (cost effective
solution, without buying software. I dont have a differential backups right
now because of storage space. )
thanks
kris"kpxus" <kpxus@.discussions.microsoft.com> wrote in message
news:8EA2A0EA-61CB-446D-906D-8C9D7BCD96B9@.microsoft.com...
> hi,
> I have a problem copying 12 Gb database backup files (2) for network
backup
> copy from the SAN. I used xp_cmdshell ' copy ...' to copy the backup
files
> every day night. Sometimes, the files are not copied over the network. I
have
> full backup every day night and log backup every hour. Can any one suggest
a
> good solution for copying the backup files out of SAN, (cost effective
> solution, without buying software. I dont have a differential backups
right
> now because of storage space. )
>
> thanks
> kris
>
Kris,
Several things come to mind. You could make smaller backups by creating
filegroups and doing filegroup backups on a rotational schedule. Check them
out in the BOL. Faster backups, smaller backups, quicker recovery and
fairly straightforward to use.
You could use the Windows scheduler to copy the files around.
There are shareware/freeware .NET Windows Service apps that can copy files
from just about any location to any other location and include encryption
etc.
Rick Sawtell
MCT, MCSD, MCDBA|||Hi,
You could write a small DOS script (batch file) to copy files from one
location to other and schedule the batch file via windows schedular. For
example:
On the destination server create a batch like:
copy \\server_name\Share_Name\directory_or_filenames
destination_path(E:\sqlbackups\
Test this out. It will work properly.
hth
DeeJay Puar
"kpxus" wrote:
> hi,
> I have a problem copying 12 Gb database backup files (2) for network backup
> copy from the SAN. I used xp_cmdshell ' copy ...' to copy the backup files
> every day night. Sometimes, the files are not copied over the network. I have
> full backup every day night and log backup every hour. Can any one suggest a
> good solution for copying the backup files out of SAN, (cost effective
> solution, without buying software. I dont have a differential backups right
> now because of storage space. )
>
> thanks
> kris
>|||Thanks
"DeeJay Puar" <DeeJayPuar@.discussions.microsoft.com> wrote in message
news:30CD919E-39BD-408F-9A9E-239FA9F62BA7@.microsoft.com...
> Hi,
> You could write a small DOS script (batch file) to copy files from one
> location to other and schedule the batch file via windows schedular. For
> example:
> On the destination server create a batch like:
> copy \\server_name\Share_Name\directory_or_filenames
> destination_path(E:\sqlbackups\
> Test this out. It will work properly.
> hth
> DeeJay Puar
>
> "kpxus" wrote:
> > hi,
> >
> > I have a problem copying 12 Gb database backup files (2) for network
backup
> > copy from the SAN. I used xp_cmdshell ' copy ...' to copy the backup
files
> > every day night. Sometimes, the files are not copied over the network. I
have
> > full backup every day night and log backup every hour. Can any one
suggest a
> > good solution for copying the backup files out of SAN, (cost effective
> > solution, without buying software. I dont have a differential backups
right
> > now because of storage space. )
> >
> >
> > thanks
> > kris
> >

Copy Backup file

hi,
I have a problem copying 12 Gb database backup files (2) for network backup
copy from the SAN. I used xp_cmdshell ' copy ...' to copy the backup files
every day night. Sometimes, the files are not copied over the network. I hav
e
full backup every day night and log backup every hour. Can any one suggest a
good solution for copying the backup files out of SAN, (cost effective
solution, without buying software. I dont have a differential backups right
now because of storage space. )
thanks
kris"kpxus" <kpxus@.discussions.microsoft.com> wrote in message
news:8EA2A0EA-61CB-446D-906D-8C9D7BCD96B9@.microsoft.com...
> hi,
> I have a problem copying 12 Gb database backup files (2) for network
backup
> copy from the SAN. I used xp_cmdshell ' copy ...' to copy the backup
files
> every day night. Sometimes, the files are not copied over the network. I
have
> full backup every day night and log backup every hour. Can any one suggest
a
> good solution for copying the backup files out of SAN, (cost effective
> solution, without buying software. I dont have a differential backups
right
> now because of storage space. )
>
> thanks
> kris
>
Kris,
Several things come to mind. You could make smaller backups by creating
filegroups and doing filegroup backups on a rotational schedule. Check them
out in the BOL. Faster backups, smaller backups, quicker recovery and
fairly straightforward to use.
You could use the Windows scheduler to copy the files around.
There are shareware/freeware .NET Windows Service apps that can copy files
from just about any location to any other location and include encryption
etc.
Rick Sawtell
MCT, MCSD, MCDBA|||Hi,
You could write a small DOS script (batch file) to copy files from one
location to other and schedule the batch file via windows schedular. For
example:
On the destination server create a batch like:
copy \\server_name\Share_Name\directory_or_fi
lenames
destination_path(E:\sqlbackups\
Test this out. It will work properly.
hth
DeeJay Puar
"kpxus" wrote:

> hi,
> I have a problem copying 12 Gb database backup files (2) for network back
up
> copy from the SAN. I used xp_cmdshell ' copy ...' to copy the backup file
s
> every day night. Sometimes, the files are not copied over the network. I h
ave
> full backup every day night and log backup every hour. Can any one suggest
a
> good solution for copying the backup files out of SAN, (cost effective
> solution, without buying software. I dont have a differential backups rig
ht
> now because of storage space. )
>
> thanks
> kris
>|||Thanks
"DeeJay Puar" <DeeJayPuar@.discussions.microsoft.com> wrote in message
news:30CD919E-39BD-408F-9A9E-239FA9F62BA7@.microsoft.com...[vbcol=seagreen]
> Hi,
> You could write a small DOS script (batch file) to copy files from one
> location to other and schedule the batch file via windows schedular. For
> example:
> On the destination server create a batch like:
> copy \\server_name\Share_Name\directory_or_fi
lenames
> destination_path(E:\sqlbackups\
> Test this out. It will work properly.
> hth
> DeeJay Puar
>
> "kpxus" wrote:
>
backup[vbcol=seagreen]
files[vbcol=seagreen]
have[vbcol=seagreen]
suggest a[vbcol=seagreen]
right[vbcol=seagreen]