Hi,

maybe a little late to mention, but wouldn't Log Shipping also do what you are wanting and be much cheaper in terms of total cost of ownership?

http://msdn.microsoft.com/en-us/library/ms190016.aspx

Just a thought.....

Regards

GermanDBA

majorbloodnock (1/23/2009)

Agreed. Has anyone else looked at the calculation necessary to work out Easter? I had to write one a few years...

Hi,

maybe not directly SQL Server, but how about porting all the standard data providers that are available in 32 Bit to 64 Bit.

It's a PIA not being able to grab...

Hi Grant,

thanks for the tips. I will look around and see what I can see.

I have just spoken with our head of development letting him know that the tool...

Hi Grant,

I thought it sounded a little complicated the way that they had suggested.

It also seemed a little silly that MS would bring something like that to market, especially with...

Hi Grant,

as of yet no issues in itself. It looked extremely clumsy when you want to control the database objects between DEV,QAS and Prod systems. Maybe I/we just...

Hi Ells,

in full recovery mode the changes that are made to a database are stored in the transaction log file(s) and are not commited to the database file until you...

Hi Ells,

you need to consider what is happening on the system before you build up the backup strategy.

You say there is a datawarehouse running in simple recovery mode, that should...

Hi,

If it is possible you should make a transaction log backup on the database to get as much from the database as possible. This could then be used to restore...

Hi,

it isn't really a computer, but the MCP from TRON was pretty nifty.

If that doesn't count, then the computer that ED Dillinger (David Warner) uses to interface with the MCP....

Hi Brandie,

I am having the same problem. I wanted to play around with the notification possibilities and tried doing the same things as you, but to no avail.

I was...

Hi there,

we had a sql 2000 to 2005 64 bit setup running to replicate data from our production system to our DWH.

We were using transactional replication and everything was fine.

We...

Hi Nicholas,

many thanks for the tip. I have not gotten round to reading BOL for SQL 2008, actually the first place I should have looked......

Well the answer is there...

Hi Steve,

that is a good point well made.

IT has always been about automating work that a human has had to do in the past. Once this has been achieved...

Hi Nicholas,

thanks for the quick reply!

So you mean that the source and target tables would both have to have the compression turned on for this to fully work?

If the source...