Viewing 15 posts - 2,926 through 2,940 (of 18,926 total)
I could use that DBCC cmd right about now!.
Oh wait, too late! :hehe:
September 8, 2011 at 8:40 am
Don't know how to debug at this point. Restore never finishes...
http://www.sqlservercentral.com/Forums/Topic1171687-1550-1.aspx
September 8, 2011 at 7:24 am
Tara-1044200 (9/8/2011)
Hmm, is there a way to find when the restore would FINISH.
The query I posted is supposed to do that. This is the part after the 100% that...
September 8, 2011 at 7:23 am
Darn, it means that your backup also had long running transactions or something else blocking recovery (don't know how to debug this).
September 8, 2011 at 7:15 am
Did you restore with NORECOVERY?
If so just do RESTORE <dbname> WITH RECOVERY and it'll go back online.
Otherwise this may be able to tell if how much loonger you may need...
September 8, 2011 at 7:03 am
Brandie Tarvin (9/8/2011)
SQL 2008 SP1
During undo of a logged operation in database 'Remi', an error occurred at log record ID (101945:2157:177). The...
September 8, 2011 at 6:44 am
Brandie Tarvin (9/8/2011)
SQL 2008 SP1
During undo of a logged operation in database 'Remi', an error occurred at log record ID (101945:2157:177). The...
September 8, 2011 at 6:39 am
SwayneBell (9/8/2011)
Grant Fritchey (9/7/2011)
https://www.livemeeting.com/cc/8000181573/join?id=33Z39D&role=attend&pw=f%5E%3E2mzT7H
I'm going on at 2300GMT or 7:00PM EDT
https://www.livemeeting.com/cc/8000181573/join?id=69K9DZ&role=attend&pw=f%5E%3E2mzT7H
You'll get close to 2 out of 7 hours of...
September 8, 2011 at 6:38 am
Ya but do you need checks, defaults, triggers, unique constraints, filegroups, indexes, UDT...
This process is far from simple. I'm sure someone has tried it besides me but I gave...
September 8, 2011 at 6:37 am
Do you have a filter that can select the correct table names?
From there on out it's just a matter of how much details you need in the create script. ...
September 8, 2011 at 6:02 am
troe_atl (9/8/2011)
September 8, 2011 at 5:54 am
GilaMonster (9/8/2011)
Don't append log backups to a single file. It's hard to see what's there and damage to the file could result in losing all your backups.
Where do you get...
September 8, 2011 at 5:42 am
What's the business need for data retention?
What's the need to access the data (how long can they wait and how fast does that access need to be performance wise).
20 GB...
September 8, 2011 at 5:30 am
Rhox (9/8/2011)
I already made an extra job step, when the log backups failed the next...
September 8, 2011 at 5:25 am
My guess is that you have 2 logs with exactly the same name and the 2nd one failed (never had that error so only a guess to start looking).
You might...
September 8, 2011 at 5:14 am
Viewing 15 posts - 2,926 through 2,940 (of 18,926 total)