The given details of the error have to be resolved and as far I know, the transactions log backup the full database. The log command is required to stop the restoration. The recovery of the data has to be done by using the StopAt option. I have to do the same when I got the Dell error code 2000-0142 in my Dell PC.
I am trying to automate weekly restores to a different server. I would like to have this automated as much as possible. The downside appears that if a new dbf is added to the active db, then I have to modify the script on the restore as well, due to moving the files to the appropriate location. Is there anyway around this?
This is the same issue I was facing some time ago. I reached for geek squad experts for help. I think this is some coding issue in sql which disables the dd boost.
aron121
2 Posts
0
October 22nd, 2018 13:00
The given details of the error have to be resolved and as far I know, the transactions log backup the full database. The log command is required to stop the restoration. The recovery of the data has to be done by using the StopAt option. I have to do the same when I got the Dell error code 2000-0142 in my Dell PC.
denniskemp
1 Message
0
May 17th, 2019 00:00
I am trying to automate weekly restores to a different server. I would like to have this automated as much as possible. The downside appears that if a new dbf is added to the active db, then I have to modify the script on the restore as well, due to moving the files to the appropriate location. Is there anyway around this?
robert1877
1 Message
0
May 30th, 2019 23:00
This is the same issue I was facing some time ago. I reached for geek squad experts for help. I think this is some coding issue in sql which disables the dd boost.