bizarre that you can't, cos the notoriously picky oracle will let you do
it...
here's how that works, so maybe if you follow these steps, but apply it to
sqlserver it might work? just a thought....
THE STEPS NEEDED TO RESOLVE THIS ISSUE
----------------------------------------------------------------------------
1. On the machine where you wish to write the files to, create a shared
drive
granting the user 'Administrator' FULL Control.
Note: For reference below, this Administrator will use the password
'test',
this will be referred to as the "Destination" machine.
2. On the machine with the TARGET DB, verify the Administrator user has the
same password of the user that shared the drive on the destination
machine.
In the example here, the password would be 'test'.
3. Map a network drive on the TARGET machine to the shared drive on the
destination machine. When mapping this drive, use the Administrator
user with the password 'test'.
4. On the TARGET machine, BOTH the OracleTNSListener Service and the
OracleService<SID> services must be configured to start using the
Administrator/test account.
(As discussed above, Oracle uses the Local System account by default.)
a. Go to the Control Panel and then open up the Services panel.
b. Double click on the appropriate service
(TNSListener or OracleService<SID>).
c. Change the "Log on as" user from the "Local System Account" to
"This Account".
d. Specify the service to log on as the Administrator user.
c. Click on "OK".
5. Shutdown the TARGET database and stop and start the services on the
Target
machine. Restart the TARGET database.
6. You should now be able to use RMAN from the Catalog machine to copy the
datafiles. In the RMAN script, specify the drive letter that you mapped
in step 3.
FINAL NOTES
----------------------------------------------------------------------------
It is recommended to use the Domain Administrator account to ensure that
passwords are the same across the various machines. If there is no domain,
use the local Administrator account and ensure that the passwords are the
same
for this account across all of the machines.
-----Original Message-----
From: Snake [mailto:[EMAIL PROTECTED]]
Sent: 19 August 2002 14:40
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] Sql server maintenance plans
Whats up with SQL server not being able to backup to a mapped network
drive. That's rubbish.
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
Any views or opinions are solely those of the author and do not necessarily
represent those of Channel Four Television Corporation unless specifically
stated. This email and any files transmitted are confidential and intended
solely for the use of the individual or entity to which they are addressed.
If you have received this email in error, please notify
[EMAIL PROTECTED]
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
