Re: Back up on remote computer.
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 09/22/04
- Next message: Quentin Ran: "Re: Unexpected deadlock"
- Previous message: Tibor Karaszi: "Re: Bug Creating UDF in MSSQL2000"
- In reply to: anonymous_at_discussions.microsoft.com: "Re: Back up on remote computer."
- Next in thread: David Portas: "Re: Back up on remote computer."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 22 Sep 2004 18:16:26 +0200
That is strange. I just did exactly that. I have a workgroup, and SQL Server is running under a
service account that also exists on the other machine, having the same password on both machines. I
executed below command, and it worked perfectly:
BACKUP DATABASE pubs TO DISK = '\\TibMedia\C\pubs.bak'
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ <anonymous@discussions.microsoft.com> wrote in message news:3b8001c4a0ad$30389f20$a501280a@phx.gbl... >I am using UNC path. > >>-----Original Message----- >>Are you using an UNC path or a mapped drive? >> >>-- >>Tibor Karaszi, SQL Server MVP >>http://www.karaszi.com/sqlserver/default.asp >>http://www.solidqualitylearning.com/ >> >> >><anonymous@discussions.microsoft.com> wrote in message >>news:12fb01c4a074$c5073190$a601280a@phx.gbl... >>> Yes. >>> >>> >-----Original Message----- >>> >Do the Administrator account have the same password on >>> the two machines? >>> > >>> >-- >>> >Tibor Karaszi, SQL Server MVP >>> >http://www.karaszi.com/sqlserver/default.asp >>> >http://www.solidqualitylearning.com/ >>> > >>> > >>> ><anonymous@discussions.microsoft.com> wrote in message >>> >news:36e801c4a05b$6dd83310$a501280a@phx.gbl... >>> >> On Windows 2000 Server Machine the SQLServer > Services >>> are >>> >> running under Administrator. Also on the other > computer >>> >> (windows 2000 professional) login is administrator > (and >>> >> obviously has all rights on the shared folder). >>> >> >>> >> This doesn't work when I try to backup on that > shared >>> >> folder. The error says that location of the (backup) >>> file >>> >> cannot be verified..do u want to continue...and > when I >>> >> say YES then after a couple of seconds the backup >>> process >>> >> stops." >>> >> >>> >> SO does this CONCLUDE that this is not possible in >>> >> Workgroup scenario? >>> >> >>> >> Thank you. >>> >> >>> >> >-----Original Message----- >>> >> >OK. Create a login on the SQL host computer. Put > it >>> in >>> >> the local >>> >> >administrators group on that machine. Change the > SQL >>> >> Service to run under >>> >> >that login. Create a login on the backup target >>> machine >>> >> with the exact same >>> >> >username and password. Grant that login full > control >>> >> over the file share >>> >> >and the NTFS folder you want to back up to. No >>> >> guarantees, but this may >>> >> >work in a workgroup. >>> >> > >>> >> >-- >>> >> >Geoff N. Hiten >>> >> >Microsoft SQL Server MVP >>> >> >Senior Database Administrator >>> >> >Careerbuilder.com >>> >> > >>> >> >I support the Professional Association for SQL > Server >>> >> >www.sqlpass.org >>> >> > >>> >> ><anonymous@discussions.microsoft.com> wrote in > message >>> >> >news:426701c4a023$dc891f50$a301280a@phx.gbl... >>> >> >> We have 5 machines. First machine Windows 2000 >>> Server >>> >> (SQL >>> >> >> Server 2000 Standard is installed here). Rest of > the >>> >> >> machines have Windows 2000 Pro. >>> >> >> >>> >> >> Keep the above scenario in mind, could you > explain >>> me >>> >> what >>> >> >> you wrote earlier: >>> >> >> >>> >> >> >It might work if you have a login and password >>> that is >>> >> >> > the same on both servers that you run the SQL >>> service >>> >> >> >under. The other option is to create a domain. >>> >> >> >>> >> > >>> >> > >>> >> >. >>> >> > >>> > >>> > >>> >. >>> > >> >> >>. >>
- Next message: Quentin Ran: "Re: Unexpected deadlock"
- Previous message: Tibor Karaszi: "Re: Bug Creating UDF in MSSQL2000"
- In reply to: anonymous_at_discussions.microsoft.com: "Re: Back up on remote computer."
- Next in thread: David Portas: "Re: Back up on remote computer."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
