Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tejokrishna
Starting Member
6 Posts |
 Posted - 2014-02-11 : 15:20:56
|
| Hi, Pls tell me ans, Interviewers were asked me below questions.1. Can we shrink log file in mirror database?2. If we added ndf file at primary database in logshipping, what is the status of secondary database?3. We have same jobs(update command) at Principle server & Mirror server, First job at principle server is succeeded, Then job at Mirror server is succeeded with different value.. which job result is exists at mirror database?Thanks,Krishna |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-02-11 : 16:20:45
|
| 1. Yes, but don't truncate the log.2. I can't remember, but I suspect it'll break log shipping and you'll need to add that file as part of the initial restore.3. I don't understand the question. Our jobs are written so that they only run on the principle server.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Realtime questions on High Availabilty