Well how else do you expect to do remote backups, from a server to your local machine?
On 10/1/07, Scott Barnes <[EMAIL PROTECTED]> wrote: > > You didn't mention TCP/IP until now.. so umm.. back off man, and like > always - you need to disclose information at the start of a thread, not 9 > tiers deep. > > Secondly, TCP/IP open to the world? hmm... > > > On 10/1/07, Andrew Scott <[EMAIL PROTECTED]> wrote: > > > Scott, > > > > > > > > It's not a rebuttle. > > > > > > > > Option 1, is provided you are connected to a network and not if you are > > connected via an TCP/IP connection and that is the problem because all > > connections have to be from the server. Currently M$ do not allow for any > > backup to be done over a TCP/IP connection to the computer that is making > > the connection and Scott you keep proving this over and over. Why I don't > > know. > > > > > > > > Option 2, is for publishing I do not have any problems with publishing > > so why you put that in the mix I am not sure. > > > > > > > > > > > > Anyway, as much as I like M$ SQL 2000/2005 the tools do not allow for > > TCP/IP backups to the connecting machine period and is a request I would > > like to see sometime soon implemented. > > > > > > > > > > > > Andrew Scott > > Senior Coldfusion Developer > > Aegeon Pty. Ltd. > > www.aegeon.com.au > > Phone: +613 8676 4223 > > Mobile: 0404 998 273 > > > > > > > > > > > > *From:* cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] *On > > Behalf Of *Scott Barnes > > *Sent:* Saturday, 29 September 2007 12:17 PM > > *To:* cfaussie@googlegroups.com > > *Subject:* [cfaussie] Re: MSSQL 2005 Developer Edition > > > > > > > > I flicked this to Peter Ward, one of our MVP SQL guys. Extremly gifted > > when it comes to SQL and hopefully can answer some of your queries should > > they arise (obviously don't bombard him with "how do i do a SELECT > > statement?") > > > > > > > > Anyway, Andrew... here ya go.. i'm confident that you'll have a rebuttle > > but none the less :P > > > > > > > > > > > > -- > > > > Hi Scott > > > > > > > > The following articles should help set them straight. > > > > > > > > The following article details the various backup devices that can be > > used for SQL Server including a UNC path ie. \\computername\share . You > > can backup or restore directly to a UNC path which could be on the > > workstation or elsewhere on the network. > > > > *SQL Server Backup Devices** * > > http://msdn2.microsoft.com/en-us/library/ms179313.aspx > > > > > > > > The Database Publishing Wizard is designed for the scenario described > > where a third-party tool was used to generate inserts. This tool is > > designed for hosted environments where you may not have full control over > > the instance so that you can easily deploy data and schema changes. > > *SQL Server Database Publishing Wizard* > > http://www.microsoft.com/downloads/details.aspx?FamilyID=56e5b1c5-bf17-42e0-a410-371a838e570a&DisplayLang=en > > > > > > > > > > If you require any further information then do not hesitate to contact > > me. > > > > > > > > Regards > > > > > > > > Peter Ward > > > > WARDY IT Solutions Chief Technical Architect and MVP Windows Server > > System - SQL Server > > > > Phone: +61 7 3856 5411 Mobile: +61 403 177 761 > > > > *WARDY IT Solutions - *Specialising in building Microsoft SQL Server > > Solutions > > > > > > - You've got questions...we've got answers AskaSQLGURU.com > > <http://www.askasqlguru.com/> > > > > > > > > > > > > > > -- Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
