No announcements
Found 3117883 threads
-
8 VotesWhy Does a StandBy Database Need an Undo file?
" But all these 'needs' also apply to non-standby recoveries so, again, you're not explaining why the undo file is needed ...Answered | 12 Replies | 4659 Views | Created by jal2 - Sunday, November 30, 2014 12:56 AM | Last reply by SQLRocker - Sunday, August 16, 2020 4:33 AM
-
0 Votes
In Logshipping the Transaction undo file is used in Standby database?
That file keeps the info needed in order to undo the UNDO performed by the recovery process With ...Answered | 2 Replies | 6891 Views | Created by Ajay.G - Thursday, June 16, 2011 4:26 AM | Last reply by Uri Dimant - Thursday, June 16, 2011 5:39 AM -
0 Votes
standby file in log sipping
A transaction undo file is required if a database is loaded in read-only state.Answered | 4 Replies | 3360 Views | Created by BI_Support - Wednesday, October 10, 2012 5:01 AM | Last reply by RohitGarg - Thursday, October 11, 2012 7:23 PM -
0 Votes
How to Undo the Undo Actions of Stand By Option
STANDBY mean that ot only redo but also undo in the database is performed, but the undo file stores in formation about the ...Answered | 8 Replies | 1636 Views | Created by Chaithanya Reddy - Thursday, January 9, 2014 12:44 PM | Last reply by TiborK - Thursday, January 16, 2014 10:45 AM -
5 Votes
What is the difference when we restore the database with standby and when with NoRecovery?
Thanks to all, But in logshipping How does it happen that I am setting my 2ndory database in standby but it is changing in Restoring mode,due to which I ...Answered | 10 Replies | 15180 Views | Created by Ajay.G - Saturday, February 12, 2011 4:52 AM | Last reply by Ajay.G - Wednesday, February 16, 2011 3:23 PM -
1 Votes
Log shipping with Standby option
Check this link to get better understanding why .tuf file is used.Answered | 2 Replies | 3029 Views | Created by Harvinder Singh - Wednesday, January 23, 2013 4:30 PM | Last reply by Kumar muppa - Thursday, January 24, 2013 5:13 AM -
0 Votes
Temporary brought online standby database
You need to configure vice versa from Sec to Primary DB.Answered | 4 Replies | 2007 Views | Created by Deni Kusdeni - Wednesday, March 20, 2013 9:46 AM | Last reply by SohnDangol - Wednesday, March 20, 2013 10:01 PM -
0 Votes
Restoration of database to a standby server.
Yes of course database is restored properlyWhich I observed _1, SQL engine automatically pick this when you select the file.Answered | 4 Replies | 1084 Views | Created by Binny Mathew Earalil - Wednesday, February 19, 2014 10:47 AM | Last reply by Binny Mathew Earalil - Sunday, February 23, 2014 5:19 AM -
11 Votes
Where is the standby file method/property in SMO.Database
You need to modify the script and get latest LDF file.Answered | 13 Replies | 2727 Views | Created by GeoffGin - Saturday, May 2, 2015 12:18 PM | Last reply by GeoffGin - Monday, May 4, 2015 2:52 PM -
0 Votes
Change the .mdf & .ldf files of the standby database
Steps to perform on primary: ============================= In this case, you need to change the mode to NoRecovery mode.Answered | 6 Replies | 4023 Views | Created by Devesh Bhole - Wednesday, October 9, 2013 5:30 PM | Last reply by Kalman Toth - Friday, October 11, 2013 11:33 AM -
0 Votes
TFS - Why "Undo Pending Changes" does not revert the deleted file or why "Get Latest" option is not working?
>Why "Undo Pending Changes" does not revert the deleted file To solve this, in your second step.Answered | 3 Replies | 7665 Views | Created by vinodkpasi - Sunday, September 4, 2016 3:33 PM | Last reply by lake Xiao - Monday, September 12, 2016 8:35 AM -
0 Votes
How to bring database to standby mode?
standby or from standby -> norecovery?Answered | 1 Replies | 10867 Views | Created by Jr.DBA - Friday, November 18, 2011 6:48 PM | Last reply by TiborK - Saturday, November 19, 2011 8:24 AM -
10 Votes
This backup cannot be restored using WITH STANDBY because a database upgrade is needed
Hi, log shipping from SQL server 2005 to 2008 is not straight forward, you can not keep secondary database in standby mode alternative approach would be to have ...Answered | 9 Replies | 13333 Views | Created by Leo_Render - Tuesday, February 4, 2014 3:55 AM | Last reply by loadme77 - Friday, June 10, 2016 12:27 PM -
0 Votes
Can database snapshots be used as standby?
Thus, if you are doing performance testing which writes to the database, you need to grow the log to the size you need, or else your test will be distorted by auto-grow.Answered | 3 Replies | 616 Views | Created by vishnu sai - Sunday, April 29, 2018 1:32 AM | Last reply by Mohsin_A_Khan - Sunday, April 29, 2018 2:12 PM -
0 Votes
Changing database drive for standby database using log shipping
Thanks for the reply ,just to clarify if the primary db drive needs changing thn log shipping needs to be broken and reconfigured but what if the standby drive ...Answered | 2 Replies | 5806 Views | Created by MrFlinstone - Thursday, January 21, 2010 10:36 AM | Last reply by MrFlinstone - Friday, February 5, 2010 8:38 AM -
0 Votes
Samsung hardware does not Standby properly
If you do run that option, be aware that: Your files and personalization settings won't change.Answered | 2 Replies | 2792 Views | Created by Digvijay Singh Shaktawat - Thursday, September 29, 2011 1:00 PM | Last reply by Rafael - Escalation Engineer - Thursday, September 29, 2011 9:23 PM -
0 Votes
Does opening Standby/Read-Only 2008 Database -- does it affect primary database??
Hello, If the database is already in standby mode from logshipping, you can do read-only queries from it without breaking log shipping.Answered | 2 Replies | 2460 Views | Created by diychik - Thursday, November 1, 2012 7:31 PM | Last reply by Sarabpreet Singh Anand - Thursday, November 1, 2012 10:09 PM -
0 Votes
Log shipping standby database went Restoring mode
Hello - Though I have not tested this but you can give this a try (Do testing on Test server first): First note down the complete database file ...Answered | 2 Replies | 1614 Views | Created by dbadays - Wednesday, March 16, 2016 1:41 PM | Last reply by dbadays - Wednesday, March 16, 2016 2:15 PM -
0 Votes
New login (reader) access to standby (readonly ) database
You need to create the login in the secondary server which should have the same SID as in the primary server.Answered | 2 Replies | 6444 Views | Created by SQLSQL2018 - Monday, December 14, 2009 7:38 PM | Last reply by SQLSQL2018 - Wednesday, December 16, 2009 1:50 AM - Items 1 to 20 of 3117883 Next ›
No announcements
