Comments
2 comments
-
Because this is the test server so no one will use this database when the logshipping happens.
EXEC master..sp_who2
to confirm that there are no connections made to that secondary database? -
Hi
The problem was the destination server seems to have not enough contiguous memory block and consequently keep restore job fail. I change it during the Startup parameter by using -g 512 and it seems to be ok now.
Add comment
Please sign in to leave a comment.
One job is running fine, however the other one keeps failing with the following error code:" VDI Error 1010: Failed to get the configuration from the server because the timeour interval has elapsed. Also Exclusive Access could not be obtained as the database is in used".
Because this is the test server so no one will use this database when the logshipping happens.
Can someone please explain to me what the problem is. Even I reinstall the database on destination server and re create log shipping job, I have the same problem
Thanks