Both plans are the same. Looking at the data, I found that the equipmentA has the LastAccessedDateTime back to 6/1/2005 and the equipmentB has the...
We have a vendor provided view. The following is the sample: SELECT TOP 400 v1, v2, v3, LastAccessedDateTime FROM v_anotherView WHERE ((v2...
I understand that NAS (Network Attached Storage) does well in file sharing and storage consoliation. Is it even viable (worth the time) to look into...
Thanks Karl. I have added the sql logon to the primary (log ship from) database. However, after I restored the database to the secondary (log ship...
I am seeking advices to add users to the currently log shipped database. We use the log shipped database for some special read access processes. I...
Thanks breckar. This works great with a smaller database. We are trying to avoid nightly backup and refresh to the receiving database. I agree...
Yes, you are right. The setting of simple mode and back to full recovery mode broke the logshipping. I have verified that last night. I have run...
I have setup a log shipping pair and they were working until Sunday morning every week (2 weeks in a row). I found that there is only job was...
Separate names with a comma.
