July 27, 2010 at 12:27 am
Hi all,
I'm trying to restore a db via network.
restore database Mirror from disk = '\\servername\sqldata\test.bak'
with standby = 'c:\testBackup\t1.tuf',
move 'test' to 'c:\testBackup\Mirror1.mdf',
move 'test_log' to 'c:\testBackup\Mirror1.ldf', stats = 1
the above i'm trying to run via osql command.
osql -S destserver -d Master -i C:\sql.txt -E -o C:\output.txt
My objective is to update a set of tables across the network on a timely basis.
Is the above approach is correct?
If not, what would be the right approach?
after restoring my plan is to update the tables using
restore log Mirror from disk = '\\servername\sqldata\test_log1.trn'
with standby = 'c:\testBackup\t1.tuf'
the network is not stable and transactions should be minimal. Hence, I'm avoiding Linked Servers.
Suggestions / Links are highly appreciated.
Thanks,
Ami.
July 27, 2010 at 1:45 am
pls. be a little more specific about your requirement.
After reading out your query it seems you want a stand by box where you get all the changes immediately after you update on production if this is your query then we have many solutions to it but again it depends what is your purpose behind this.
1. is it required for reporting purpose.
2. Is it required for high Availability purpose.
3. Or you have some other purpose associated with it.
pls. provide the details on your query.
Regards,
Sachin Sharma
July 27, 2010 at 3:06 am
Hi Sachin,
thanks for responding. as i mentioned.
My objective is to update a set of tables across the network on a timely basis.
it is for updating price details of certain materials.
not for reporting.
it will happen on timely basis.
morning / after noon / before EOD etc...
3-4 times in a day.
Thanks,
Ami
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply