tag:blogger.com,1999:blog-7423363075024286359.post8072128599889388346..comments2015-08-03T03:06:41.082-07:00Comments on @joeharris76: How To Copy A Standby Database in SQL Serverjoeharris76http://www.blogger.com/profile/09242541409318280541noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-7423363075024286359.post-91761535501044222522015-07-02T06:40:28.136-07:002015-07-02T06:40:28.136-07:00Has anyone had any issues with the .tuf undo file ...Has anyone had any issues with the .tuf undo file when running through this procedure? When I RESTORE the target DB for normal usage RESTORE DATABASE MyNewDevDb WITH RECOVERY; then the StandBy DB's .tuf file is deleted which prevents me completeing Step 11 i.e. Taking the Standby DB back online ALTER DATABASE MyStandbyDb SET ONLINE; as I receive an error message stating that the .tuf file is missing. I tried backing up the .tuf file in a separate directory and then pasting back afterwards which works but it's problematic. Thanks in advanceAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7423363075024286359.post-80650986627513337082014-01-23T08:45:02.427-08:002014-01-23T08:45:02.427-08:00If you want to run this process repeatedly, you ne...If you want to run this process repeatedly, you need to take a copy of the standby file from the source database before performing step 10. Step 10 will delete this file. Then following step 10 simply copy or move the standby file back into place and your source database is still in good shape.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7423363075024286359.post-72683626926184807222014-01-23T08:42:18.165-08:002014-01-23T08:42:18.165-08:00Depending on the Windows account used to run SQL S...Depending on the Windows account used to run SQL Server there can be problems when attempting step 9 (i.e. to bring the new Dev DB back online). You get error code 5, which means "access denied". This is because it can be that the SQL Server user does not have read/write privileges for the new mdf and ldf files. This is caused by step 8. The copy command just gives the target files default security settings. Not sure what the best solution is here, but I've used xcopy /OAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7423363075024286359.post-47415504279909743612014-01-23T06:20:57.818-08:002014-01-23T06:20:57.818-08:00Fixed! Thanks. :)Fixed! Thanks. :)joeharris76https://www.blogger.com/profile/09242541409318280541noreply@blogger.comtag:blogger.com,1999:blog-7423363075024286359.post-74357966010291273902014-01-23T06:06:08.165-08:002014-01-23T06:06:08.165-08:00Thanks, very useful.
Step 11 though should say the...Thanks, very useful.<br />Step 11 though should say the following I thing: <br /><br />ALTER DATABASE MyStandbyDb SET ONLINE; Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7423363075024286359.post-64490304629208679902013-10-26T09:03:09.040-07:002013-10-26T09:03:09.040-07:00Thanks, your post did job for me.
All the best fro...Thanks, your post did job for me.<br />All the best from Poland.<br /><br />MarcinAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7423363075024286359.post-45830425588376321042013-05-01T07:24:32.343-07:002013-05-01T07:24:32.343-07:00Thank you for this. This is a thorny little probl...Thank you for this. This is a thorny little problem and your solution worked great. Keep up the good work.Reinisnoreply@blogger.comtag:blogger.com,1999:blog-7423363075024286359.post-9468619229170064362012-12-03T12:52:17.273-08:002012-12-03T12:52:17.273-08:00Sorry Gowtham, no idea I'm afraid. Never had a...Sorry Gowtham, no idea I'm afraid. Never had an opportunity to put ParStream to the test (yet…).joeharris76https://www.blogger.com/profile/09242541409318280541noreply@blogger.comtag:blogger.com,1999:blog-7423363075024286359.post-76637199081242174392012-12-03T10:02:22.002-08:002012-12-03T10:02:22.002-08:00Nice to see many posts on Big Data.
I recently ca...Nice to see many posts on Big Data.<br /><br />I recently came to know about Pastream. I am trying to make some reports in Tableau on Parstream.<br /><br />It seems there is no separate ODBC driver. They are using Postgre SQL odbc driver. Any idea?<br /><br />Please share your thoughts.<br /><br />Best Regards<br />GowthamLeewayhttps://www.blogger.com/profile/05160774085328608214noreply@blogger.comtag:blogger.com,1999:blog-7423363075024286359.post-71133195129977412922012-05-14T14:07:07.637-07:002012-05-14T14:07:07.637-07:00Great stuffGreat stuffAnonymousnoreply@blogger.com