hello RonMexico -- I think this has happened to me before. I think the name is retained for obvious reasons because of the master DB restore. I normally keep the...

hello Bobby -- have you considered logging in from the problematic app host and trying a ping, then a simple sqlcmd login just to check if it would go though?...

hello, if it's a small enough database, you may want to consider restoring the adhoc full + dif + trn form the primary to another instance then do DBCC CHECKDB....

Agree it could be a handful of other things. Have you considered possibility that somebody placed a DBCC FREEPROCCACHE on some job/ad-hoc script/or proc? I would give it a try...

Thanks mate. I was surprised too that it turns out to be fragmentation. A quick alter table rebuild cleared the excess reserved sp_spaceused. It's still the same number of rows.

I...

agree that simply increasing the number of stripes does already improve backup duration.

one would think it has to be on separate disks, but it does not necessarily...

ditto. you would think its something that should be simple but MS decides to make it harder. 🙂 same goes for edition downgrade. edition upgrade is a few clicks. edition...

Have you considered log shipping by restoring the DB to the new server with NORECOVERY and then shipping the logs there? I imagine you then have to agree on a...

agree a service 1bounce sometimes does work; when it does not the DB goes to recovery mode and you wait again, but usually this is no longer the 20 hours...

Hey @avinash-2, what's up!

Interesting post. At work, I deal with SQL Server, Oracle, and Sybase.

For what it's worth, I like to think of the multitude of database options on different DBMS as like...

<!>