August 26, 2008 at 12:26 pm
Hi,
Can we backup a database on a network location?
or can we restore from a network location (without copying the backup file on the local machine)?
I tried both but they didnt work, any one has any idea?
FYI.........my problem is
Server 1 has a DB say abc...........backup is scheduled of abc daily at 9 PM
i want to restore this backup on Server 2 (without copying the backup file from Server 1 to Server 2).........
Thanks,
Usman
August 26, 2008 at 1:16 pm
In SQL 2005 you can backup to a network location. You just have to make sure that the account running the SQL Server Agent has the appropriate level of rights to that location.
Regards, Irish
August 26, 2008 at 1:18 pm
i have seen that, but its not working. SQL Server agent is running under my network user. and i have the access to the other server. But its not working.
August 26, 2008 at 1:58 pm
What error are you getting?
Regards, Irish
August 26, 2008 at 2:02 pm
What does 'it does not work' mean?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 26, 2008 at 6:36 pm
I remember doing it on SQL 2000 also. I couldn't browse to the file location in the backup & restore GUIs, but I could "copy-paste" it into the file location.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply