Viewing 15 posts - 12,061 through 12,075 (of 49,552 total)
Break the mirroring, bring the mirror online. At this point there will be no more principal or mirror, just two databases on different servers. Providing the mirror doesn't also need...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 17, 2013 at 10:54 am
Wait or restore from backup. Since you have mirroring, you can break the mirroring, bring the mirror online and continue working on that, back up the mirror and then use...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 17, 2013 at 9:41 am
Short answer: SSMS is incredibly inefficient at displaying rows.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 17, 2013 at 7:40 am
No, they can't.
There should be messages, probably mixed up with the login failures, stating which phase of recovery the DB is in and what time is estimated left.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 17, 2013 at 7:36 am
What's the question here?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 17, 2013 at 2:32 am
Progress should be logged into the SQL error log.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 17, 2013 at 2:32 am
Boris Pazin (8/17/2013)
Biggest table has about 76 millions of rows. So, I guess deleting and re-creating 76M of rows could be harmful for all queries which use that table?
No, doing...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 17, 2013 at 2:31 am
Unless it's causing trouble (failed checkDB or other errors), just leave it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2013 at 12:20 pm
You never answered
Beatrix Kiddo (8/16/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2013 at 10:21 am
And if you go to restore and that full backup taken after the switch back to full is damaged and won't restore? Or lost in a drive failure?
Intentionally breaking the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2013 at 9:23 am
HowardW (8/16/2013)
I can't see how snapshot backups could cause the error message reported by the OP.
They can. Seen it a number of times before here.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2013 at 9:21 am
gasbod (8/16/2013)
You could create a job to change your recovery model during the process then switch it back to full mode after and fire off a full back up.
If you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2013 at 8:43 am
Index rebuilds in full recovery model are a 'size of data' operation. The entire index, every single modified page, gets logged, so the log space required is > size of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2013 at 8:06 am
OnlyOneRJ (8/16/2013)
Like if data gets deleted after 2 hours then using log backup they want that data to be recovered ... will it be possible???
Now that's what log backups are...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2013 at 5:41 am
Check that there isn't some snapshot backup tool running against your databases. BackupExec, DPM or something like that.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2013 at 5:40 am
Viewing 15 posts - 12,061 through 12,075 (of 49,552 total)