Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
patshaw
Posting Yak Master
177 Posts |
 Posted - 2009-06-25 : 05:43:58
|
| Is there any way to check if a linked server is available before issuing a statement?I have a log shipping process which performs a local log backup and then performs a COPYTO to the dr server where the log is restored. The problem is we keep experiencing periodic loss of network. When this happens, the log backs up locally but cannot be copied to the linked dr server. This means that the missing log has to be located on the source server and manually copied to the dr server in order for log shipping to commence on the effected databases. This can be quite time consuming.Does anyone know a way of performing a check to see if the dr server is available before commencing with the backup/COPYTO operation?Thanks. |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-06-25 : 09:33:36
|
quote:
Originally posted by patshaw
Is there any way to check if a linked server is available before issuing a statement?I have a log shipping process which performs a local log backup and then performs a COPYTO to the dr server where the log is restored. The problem is we keep experiencing periodic loss of network. When this happens, the log backs up locally but cannot be copied to the linked dr server. This means that the missing log has to be located on the source server and manually copied to the dr server in order for log shipping to commence on the effected databases. This can be quite time consuming.Does anyone know a way of performing a check to see if the dr server is available before commencing with the backup/COPYTO operation?Thanks.
whenever your network comes back the missing logs should automatically copied.... |
 |
|
|
patshaw
Posting Yak Master
177 Posts |
Posted - 2009-06-25 : 10:41:22
|
| No, they aren't. This whole process is scripted and incorporates 3rd party compression. There is no facility to pick up logs that have not been copied. |
|
|
|
|
|
|
Check if remote server is available?