Comments
Sort by recent activity
I have sent the log file to Red Gate Support [support@red-gate.com].
thanks / comments
I have sent the log file to Red Gate Support [support@red-gate.com].
thanks
normally when we do the restore database, we will create a copy job and load job (using sql server job agent) right after, so the db is ready to load the new t-log. would that have the effect on the state of the db? / comments
normally when we do the restore database, we will create a copy job and load job (using sql server job agent) right after, so the db is ready to load the new t-log. would that have the effect on th...
if the network share folder is the same as the dest server t-log restore location, would that a problem? thanks / comments
if the network share folder is the same as the dest server t-log restore location, would that a problem? thanks
i use non-operational (restore with norecovery), so it will be in restoring state? and won't be able to display the database structure, etc. and view the data ? But on sql server, if you use restore with norecovery, it will make the standby server dispaly as read-only state, is this a difference? thanks / comments
i use non-operational (restore with norecovery), so it will be in restoring state? and won't be able to display the database structure, etc. and view the data ? But on sql server, if you use resto...
i use redgate backup a database, then restore it with the second option (on the step 3 recovery completion state): non - opertional, after restore, the database is in read-only state, and i am able to view the database completely when i check from sql server EM.
if i use command like this
restore database xxx from disk = 'n:\MSSQL\Backup\xxx.bak' with norecovery, replace.
we are still able to see the database is in read-only state, but if i ran the command you sent me, it is showing loading state.
why is that? / comments
i use redgate backup a database, then restore it with the second option (on the step 3 recovery completion state): non - opertional, after restore, the database is in read-only state, and i am able...
i got the email notified that the restore completed successfully with norecovery, and the first t-log backup have copied to remote server successfully, but the database still in loading state, it is a very small db, after compress backup only 46M. is this normal? thanks / comments
i got the email notified that the restore completed successfully with norecovery, and the first t-log backup have copied to remote server successfully, but the database still in loading state, it i...
also, for the restore t-log job, after you create it, how do you edit it? is that you need to have sql backup pro to be able to edit it? / comments
also, for the restore t-log job, after you create it, how do you edit it? is that you need to have sql backup pro to be able to edit it?
the restore finished around 12:25pm, then the first t-log backup at 12:30, it is successfully copied to network share every 15 mins (which is i specified on the remote server), but the load job couldn't successful (i set up every 5 mins). / comments
the restore finished around 12:25pm, then the first t-log backup at 12:30, it is successfully copied to network share every 15 mins (which is i specified on the remote server), but the load job cou...
we are using sql 5.4.
the backup on the source server took place at 10:57, finished at 11:24, the restore on the dest server finished at 12:25. the first transaction log backup occured at 12:30. / comments
we are using sql 5.4.
the backup on the source server took place at 10:57, finished at 11:24, the restore on the dest server finished at 12:25. the first transaction log backup occured at 12:30.
the source database already have a backup t-log job running every 15 mins initiated by sql server agent, so if i set up another backup jobs by sql backup tool, will it cause problem? thanks / comments
the source database already have a backup t-log job running every 15 mins initiated by sql server agent, so if i set up another backup jobs by sql backup tool, will it cause problem? thanks