Viewing 15 posts - 12,061 through 12,075 (of 49,562 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...
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...
August 17, 2013 at 9:41 am
Short answer: SSMS is incredibly inefficient at displaying rows.
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.
August 17, 2013 at 7:36 am
Progress should be logged into the SQL error log.
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...
August 17, 2013 at 2:31 am
Unless it's causing trouble (failed checkDB or other errors), just leave it.
August 16, 2013 at 12:20 pm
You never answered
Beatrix Kiddo (8/16/2013)
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...
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.
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...
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...
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...
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.
August 16, 2013 at 5:40 am
Viewing 15 posts - 12,061 through 12,075 (of 49,562 total)