I haven't automated this process yet (synching up the standby manually and shipping the log every day manually via sftp) but I will definitely keep...
Well if you are not confident then the best thing would be to TEST it. create a small database in the primary (called TEST maybe?) and test it out......
Anybody ?
The problem is I cannot use file sharing / network name share for log shipping. Looks like I have no choice but to use this approach unless you have...
Ok - so there are no distance constraints or restrictions between a primary and secondary server ? The primary and secondary are in different domains...
Folks - are there any distance constraints to the hot standby with log shipping ? Meaning - can the standby be a 3000 miles apart from the primary ?
never mind i found the answer to my question and for those who may be interested here's the answer --...
Why google when you have sql-server-performance.com [:D] Anyway here are my questions -- 1) We have a 2 node production active/active cluster and I...
I understand LUNs can be grown online if we are using a 3rd party clustering software like Veritas for example (irrespective of the SAN/storage type)...
All -- We are running a 2 node win 2k3/sql srvr 2005 active/active cluster with a 50gb EMC shared LUN for each instance (one instance on each node)....
Satya to the rescue as usual [:)] Thanks - I already read the first two articles and will check out the last one today.
2 node sql srvr 2005 ent. edition active/active cluster on win 2003 is going to be moved to a different domain. The IPs/hostnames etc. will NOT...
SP2 has been applied - that fixed the report issue indeed. Thanks for your help gentlemen - this is one awsome forum indeed. Keep up the good work....
Thanks everybody - I will apply SP2 and let you know if that fixes the reports issue or not.
Thanks, here's the result of that query: ServicePack BuildNumber ------------------ ------------------- RTM 9.00.1399.06
Thomas - the backupset and restorehistory msdb tables are showing backup / restore data correctly - don't see any issues with these tables. Satya -...
native
When I click on "Backup and Restore Events" on the drop down list under the "Report" button I see the backup/restore report page but none of the...
Sounds good, thanks.
Separate names with a comma.
