Hi.

Merge replication is the only built in way to easily sync these databases, unless you want to write some sort of custom solution which could get messy fast.

I suggest trying...

How did you initialize replication to set it up? Did you restore a backup to this subscriber or did you create and apply a snapshot?

I've had to fix this in...

Totally agree - Windows should stay where it is, on the x86 chipset. I wouldn't mind seeing SQL Server ported to Linux though.

CDP.

Agreed - This argument IS driving me nuts.

I'm not certain my original post indicated this so I'll restate it if I wasn't clear: I think SSIS is a great tool...

Ok you got me, but that would be really cool.

Chris.

Omri,

Your link is broken.

All interested,

I profiled doing this through EM, it creates a new temp table in the new tablespace, populates it, drops the old table and then renames...

Microsoft stated that this was so that they would have the best performance if every page in the database changed.

C.

I know that it is not immediately after but I'm not sure when it gets larger.

I'm going to try creating a snapshot before I go home tonight and make...

That was what the doc said but not what I'm seeing. When I create a file report on the sparse file/snapshot file on the disk, there is a fair bit...

I took one for the team and opened an MS case for this. I spoke with an engineer on the snapshot team.

According to him, there is no trace flag...

So by design it reserves the same amount of space in its data file as the (for lack of a better word) parent database?

When I look at the files through...

Good article but not practical for many environments. Like some other posters mentioned I think backup/restore should have been mentioned but with a slight twist. We use Litespeed to speed...

As every CIO gets hyped up about virtualization and reducing TCO, lets not forget that a certain degree of virtualization is built into the product already, read: Instances.

While you...

I remember reading that now that you mention it. That explains something else I saw (on the tool) on the identical test server when I changed the allocation to a...

Hi Steve,

I first started coming here to leech scripts to make my life as an admin easier and ask questions on the forums.

Several years later, I'm still coming here...