Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How to transfer backup from client to server machine (SQL ..

  
   Database Help (Home) -> Programming RSS
Next:  Group By question  
Author Message
Oz

External


Since: Jan 11, 2007
Posts: 2



(Msg. 1) Posted: Thu Jan 11, 2007 11:20 am
Post subject: How to transfer backup from client to server machine (SQL Server 2005)
Archived from groups: microsoft>public>sqlserver>programming (more info?)
In my line of bussiness it is not possible to help every client on this
issue (several thousand users) What I need to achieve is transferring
backup to the server by using SQL Server to do it and restoring it with
SQL Server. A solution for SQL 2005 would be perfect (it is not
necessary to solve this in SQL Server 2000). Using Named pipes is not
an option because it is no longer supported in SQL2005

 >> Stay informed about: How to transfer backup from client to server machine (SQL .. 
Back to top
Login to vote
Dejan Sarka

External


Since: Mar 18, 2004
Posts: 103



(Msg. 2) Posted: Fri Jan 12, 2007 7:54 am
Post subject: Re: How to transfer backup from client to server machine (SQL Server 2005) [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
> In my line of bussiness it is not possible to help every client on this
> issue (several thousand users) What I need to achieve is transferring
> backup to the server by using SQL Server to do it and restoring it with
> SQL Server. A solution for SQL 2005 would be perfect (it is not
> necessary to solve this in SQL Server 2000). Using Named pipes is not
> an option because it is no longer supported in SQL2005

Named Pipes are supported in SQL 2005.
What exactly is your problem? Do clients do their backups to files on their
local disk? If yes, you could use scheduled jobs with SSIS packages or
simply with command promt commands for copying files.

--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/

 >> Stay informed about: How to transfer backup from client to server machine (SQL .. 
Back to top
Login to vote
Oz

External


Since: Jan 11, 2007
Posts: 2



(Msg. 3) Posted: Thu Jan 18, 2007 12:31 pm
Post subject: Re: How to transfer backup from client to server machine (SQL Server 2005) [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hi,

See the article on
http://msdn2.microsoft.com/en-us/library/ms144262.aspx about
'Discontinued Database Engine Functionality in SQL Server 2005'. So
this is not an option to use with SQL2005. If it was available, it
would have been the solution to my problem.

Oz.

Dejan Sarka schreef:
> > In my line of bussiness it is not possible to help every client on this
> > issue (several thousand users) What I need to achieve is transferring
> > backup to the server by using SQL Server to do it and restoring it with
> > SQL Server. A solution for SQL 2005 would be perfect (it is not
> > necessary to solve this in SQL Server 2000). Using Named pipes is not
> > an option because it is no longer supported in SQL2005
>
> Named Pipes are supported in SQL 2005.
> What exactly is your problem? Do clients do their backups to files on their
> local disk? If yes, you could use scheduled jobs with SSIS packages or
> simply with command promt commands for copying files.
>
> --
> Dejan Sarka
> http://www.solidqualitylearning.com/blogs/
 >> Stay informed about: How to transfer backup from client to server machine (SQL .. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Specs for SQL Server client machine - Hi, I'm getting a new desktop machine at work, and I've been asked to provide the kind of specs I need. Most of my stuff is SQL Server work (mainly using remote data, but occasionally on my machine). I also do a lot of VS.NET development locally. Could...

transfer logins and roles to another server - Can anyone give me some ideas of how to transfer all the logins and roles from one server to another? I tried running the sql script but doesn't work properly and gives me errors and doesn't show up in enterprise manager tree. now when i try to..

Login failed for user 'NT AUTHORITYSYSTEM'. [CLIENT: 192.1.. - It's been suggested that I post here rather than in the windows.server.sbs WIN2003SBS Premium R2 Help! This error is appearing every one minute when SQL Server and SQL Server Agent are running (but not when not): Event Type: Failure Audit Event..

keep alive option for the server or client - I have a client in the DMZ and a server on the internal network. The firewall is killing the connection between them after a period of inactivity. Is there a connection string for the client or a server option that will do "keep-alives" so ...

Client tool for SQL Server 2005 - Client tool for SQL Server 2005 What client tool should I use to control my SQL Server 2005? I don't have SQL Server 2005 installed on my server and therefore not the client tool, but I need it to control the database at my ISP. TIRislaa
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]