A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.
3 replaced http://stackoverflow.com/ with https://stackoverflow.com/
source | link

There are a few details that are missing from your description of the problem. For example, are you restoring using SSMS to restore the transaction logs?

It would probably be better to create a process to periodically restore the transaction logs that have not been restored. You can, of course, schedule the times that you want to restore.

For issues that you may face, see the following posts:

Log Shipping Why Would You Choose No Recovery ModeLog Shipping Why Would You Choose No Recovery Mode

Can SQL Server database be changed from NoRecovery to Standby?

These posts have some overlap, but read them both to get a better understanding of the options that you have.

There are a few details that are missing from your description of the problem. For example, are you restoring using SSMS to restore the transaction logs?

It would probably be better to create a process to periodically restore the transaction logs that have not been restored. You can, of course, schedule the times that you want to restore.

For issues that you may face, see the following posts:

Log Shipping Why Would You Choose No Recovery Mode

Can SQL Server database be changed from NoRecovery to Standby?

These posts have some overlap, but read them both to get a better understanding of the options that you have.

There are a few details that are missing from your description of the problem. For example, are you restoring using SSMS to restore the transaction logs?

It would probably be better to create a process to periodically restore the transaction logs that have not been restored. You can, of course, schedule the times that you want to restore.

For issues that you may face, see the following posts:

Log Shipping Why Would You Choose No Recovery Mode

Can SQL Server database be changed from NoRecovery to Standby?

These posts have some overlap, but read them both to get a better understanding of the options that you have.

2 replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
source | link

There are a few details that are missing from your description of the problem. For example, are you restoring using SSMS to restore the transaction logs?

It would probably be better to create a process to periodically restore the transaction logs that have not been restored. You can, of course, schedule the times that you want to restore.

For issues that you may face, see the following posts:

Log Shipping Why Would You Choose No Recovery Mode

Can SQL Server database be changed from NoRecovery to Standby?Can SQL Server database be changed from NoRecovery to Standby?

These posts have some overlap, but read them both to get a better understanding of the options that you have.

There are a few details that are missing from your description of the problem. For example, are you restoring using SSMS to restore the transaction logs?

It would probably be better to create a process to periodically restore the transaction logs that have not been restored. You can, of course, schedule the times that you want to restore.

For issues that you may face, see the following posts:

Log Shipping Why Would You Choose No Recovery Mode

Can SQL Server database be changed from NoRecovery to Standby?

These posts have some overlap, but read them both to get a better understanding of the options that you have.

There are a few details that are missing from your description of the problem. For example, are you restoring using SSMS to restore the transaction logs?

It would probably be better to create a process to periodically restore the transaction logs that have not been restored. You can, of course, schedule the times that you want to restore.

For issues that you may face, see the following posts:

Log Shipping Why Would You Choose No Recovery Mode

Can SQL Server database be changed from NoRecovery to Standby?

These posts have some overlap, but read them both to get a better understanding of the options that you have.

1
source | link

There are a few details that are missing from your description of the problem. For example, are you restoring using SSMS to restore the transaction logs?

It would probably be better to create a process to periodically restore the transaction logs that have not been restored. You can, of course, schedule the times that you want to restore.

For issues that you may face, see the following posts:

Log Shipping Why Would You Choose No Recovery Mode

Can SQL Server database be changed from NoRecovery to Standby?

These posts have some overlap, but read them both to get a better understanding of the options that you have.