They won't be set.

I don't have a script to reverse engineer them as I don't change that many of them (you should not need to), I use a script if...

I stand corrected, I had forgotten about forwarding pointers. what about internal fragmentation though?

where I have added a clustered index to a heap I have achieved a reduction in pages...

GSquared (4/5/2012)

---

Joy Smith San (4/5/2012)

---

Thanks to all. More clear now.

If you look at it in the regard that a heap is index type of 0, then you could make the...

the ops got you there Jason! Retract your statement or I link to it on the thread 🙂

nope you cannot defragment it like its an index. the heap is the...

unless you have got a LOT of jobs, SSIS, linked servers and other objects whose definitions are held in the system databases it is best not to backup and restore...

a heap table can also be fragmented, so thats not 'index' fragmentation

check the state_desc column in master.sys.databases = 'online'

http://www.sqlservercentral.com/articles/Administration/64582/

are you saying the log continues to grow even though you are running log backups?

If so what is the value of log_reuse_wait_desc in master.sys.databases

strange, it is for me. You are after the publisher right?

don't use the copy database wizard, its too slow, complicated and unreliable.

Use detach\attach or...

is_published is_subscribed is_merge_published is_distributor from master.sys.databases will be = 1

I'd be looking to add either files or filegroups to the database first and moving data accordingly.

is there other data on this drive other than the database then?

Is the log file on the same drive and if so what size is it? a shrink of...

it would fail, as in it wont even attempt to start the restore, thus preserving your database. Set up a test database, back it up and then try and restore...