|
Home > Archive > microsoft.public.sqlserver.server > December 2002 > backup fails over netwrok??!??! pls help.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
backup fails over netwrok??!??! pls help.
|
|
| Stephane Viau 2002-12-19, 11:23 pm |
| im running this command as a batch file on server1,
isql /U sa /P /d mls /s server2 /Q "DUMP database mls TO
DISK='\\server3\dbbackup\goldi
e\mls.dat' WITH INIT" >> dbsynch.log
which gives the error sepcified in this article:
http://support.microsoft.com/defaul...B;en-us;q207187
actually even i backup servr2 to server 1, it still gives me the same error
server 1 is sql server 2000 (win2000)
server 2 is sql server 65 (nt4)
on all three servers, im loged in as adminsistrator (same password), and the
sql server on server 1 and server 2 both have the same user account
what am i missing here?
thanks
stephane
| |
| Oleg Deshin 2002-12-20, 12:23 am |
| Hi
> what am i missing here?
Server (MSSQLServer service) should run under _domain_ account.
In other words, the account you use to start-up SQL server should have
rights on the shared folder.
Oleg
| |
| Stephane Viau 2002-12-20, 5:23 am |
|
sqlserver srvice og the 65 or tehe 2000 server? although im runnin the
commend from the sql2000 servers, it the isql actually running on the 65
server, therefore running unde its context?
if i run the script on the 65 server it runs ok, so why not from the sql
server 200o server?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
| |
| Jyothi Pai [MS] 2002-12-20, 7:23 pm |
| Hi Stephane,
I tested this scenario myself and works perfectly fine when I run a batch
file from the SQL Server 2000 machine by connecting to the 6.5 Server using
isql.
Servers
=======
SQL Server 2000 - ServerA
SQL Server 6.5 - ServerB
Backup Server - ServerC
I run this batch file from ServerA.
Contents of batch file: c:\sqlrun.bat on ServerA.
isql -SServerB -Usa -P<password> -Q"DUMP database pubs to disk =
'\\ServerC\<share_name>\<backup_file>'" >> dbsynch.log
By running the above batch file from the 2000 Server (ServerA), it connects
to SQL Server 6.5 (ServerB) and runs the DUMP command to backup the pubs
database on the 6.5 Server to a share on the Backup Server (ServerC) and
the SQL Server 6.5 Service (MSSQLServer) startup account is a domain
account with permissions on the share on the Backup Server. The output file
dbsynch.log is created on the SQL Server 2000 machine (ServerA in the above
example) in the same directory as the "batch" file.
Regarding your questions:
>> if i run the script on the 65 server it runs ok, so why not from the sql
server 200o server?
Do you mean if you run the script locally on the 6.5 Server machine (from
the console) it works fine and not when you run it via a batch file from
the 2000 Server?
You could run SQL Trace against the 6.5 server to see if the DUMP command
is actually running on the 6.5 Server and that'll tell you if this is going
against the 6.5 Server indeed.
>> although im runnin the commend from the sql2000 servers, it the isql
actually running on the 65 server, therefore running unde its context?
Correct as demonstrated above, you need to be running the above command in
isqlw session or using isql command line utility (from within a batch file)
and connect to the 6.5 Server to run the DUMP command.
HTH,
Regards,
Jyothi Pai
Microsoft Online Support Engineer
Get Secure! – www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| From: Stephane Viau <sviau@crea.ca>
| References: <uMJn7t#pCHA.1616@TK2MSFTNGP10>
| X-Newsreader: AspNNTP 1.50 (ActionJackson.com)
| Subject: Re: backup fails over netwrok??!??! pls help.
| Mime-Version: 1.0
| Content-Type: text/plain; charset="us-ascii"
| Content-Transfer-Encoding: 7bit
| Message-ID: <OWPXLPBqCHA.1376@TK2MSFTNGP12>
| Newsgroups: microsoft.public.sqlServer.server
| Date: Fri, 20 Dec 2002 02:37:27 -0800
| NNTP-Posting-Host: actionjackson37.dsl.frii.net 216.17.146.37
| Lines: 1
| Path: cpmsftngxa09!TK2MSFTNGP08!TK2M
SFTNGP12
| Xref: cpmsftngxa09 microsoft.public.sqlserver.server:247094
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
|
|
| sqlserver srvice og the 65 or tehe 2000 server? although im runnin the
| commend from the sql2000 servers, it the isql actually running on the 65
| server, therefore running unde its context?
|
| if i run the script on the 65 server it runs ok, so why not from the sql
| server 200o server?
|
| *** Sent via Developersdex http://www.developersdex.com ***
| Don't just participate in USENET...get rewarded for it!
|
|
|
|
|
|