Viewing 15 posts - 1 through 15 (of 33 total)
Great!
thank you all for the advice, i'll go with the last solution, a new sqlserver 2016 AG box with log shipping from 2014 box
January 18, 2019 at 1:01 am
Thanks for the reply
unfortunately the procedure is for an update in place
I have a 20TB db that I have to migrate into another cluster that doesn't share the...
January 17, 2019 at 2:49 am
it's me again...
another test, I would like to go deeper on this issue
same database, but with 13K + filegroups/datafile
now it's running and stuck in "fixups" phase.
April 6, 2017 at 7:23 am
hi,
I would like to give you an update about the restore tests. I restored the smallest one,7TB with 4600 files.
It took a lot less time. the high...
March 28, 2017 at 2:26 am
select from sysaltfile blocked too 🙂
session_id,wait_type,sql_text,blocked_by
52 LCK_M_S select * from sys.sysaltfil 55
55 NULL RESTORE DATABASE [dbxxxx] FROM DISK... 0
March 14, 2017 at 9:34 am
March 14, 2017 at 7:49 am
March 13, 2017 at 9:52 am
DBCC LogInfo(<database...March 13, 2017 at 3:07 am
March 10, 2017 at 2:52 am
just launched the restore of the db with two commands, the first for full restore with NORECOVERY the second with diff and RECOVERY option
No buffers related options added
March 9, 2017 at 9:21 am
> Second, it sounds like you are...
March 9, 2017 at 8:04 am
Db restored on the test server, checkdb has found the same errors as expected
I did things suggested by Gail, (drop-create the index / tables), after this, the chekdb has...
March 9, 2017 at 7:51 am
Viewing 15 posts - 1 through 15 (of 33 total)