I'm thinking one way to do this is modifying the system stored proc sp_MSdel_xxx at the subscriber's db to simply "RETURN" (or do nothing) during my archive/purge maintenance window. But...

Thanks for your comments, Rudy.

'Phase' migration is not an option for me as those 30 dbs host one giant app. So very much all or nothing. I've talked to Microsoft...

Hi,

I realized this thread is 4 years old, but still apply to me.

I want to migrate sybase to sql server 2012. I successfully used SSMA to migrate schema and data...

Thanks so much for your clear and concise reply, SQLBuddy. I appreciate so much.

Thanks for quick response, Perry.

From what I read Always-On AG is a combination of database mirroring and failover cluster. So I wasn't sure if they still utilize worker threads the...

Thanks Gail.

Thanks for the replies.

My question was in which option would my 2nd-diff restore finish faster? Or they would take the same amount of time to restore the 2nd-diff?

For example: My...

Yes I did use backup/restore to/from multiple files and yes with compression, but all these didn't make any difference.

Anyways, I got the issue resolved. We found out the problem was...

Our SAN administrator monitors the NetApp SAN while I'm doing the db restore and he sees the IO latency is around 10-20ms which is normal, but he sees very little...

Good point, Jason. Thanks!

Instead of using dbo.sysindexes, sys.partitions can be used to obtain the rowcount

SELECT ( SCHEMA_NAME(o.schema_id) + '.' + OBJECT_NAME(o.object_id) ) AS TblName,

...

Hi bill.galashan

you're abso correct. My script only works when all data from table is relicated. If data fiterring is used, it of course will cause diff in rowcounts between pub...

Hi tina.t.kurtluyan

Counting rows in sysindexes is much faster than counting rows in the actual table. However, because sysindexes is lazily updated, the rowcount may not be accurate. If that's...