If you set up a FULL backup of original database you could use it for the simple method of replication from previous reply. Also if you don't do Transaction Log...

If I understand correctly you are replicating database once nightly?

There is a fairly straightforward method which involves using a simple script to copy latest full backup file to second server...

I would create copies of the tables to be altered using SELECT INTO and name the new tables with "NEW_" in front of old name. Inside a Transaction Truncate ...

How are you copying the data? SSIS sometimes will generate huge log files and take ages to copy large amounts of data where a simple SQL statement will often run...

There is a solution outside of SQLServer if the normal database backup method fails. Is there a backup performed of the actual files on the server - e.g C:\ drive...

cheers - I'll do that. I thought it might have been relevant to the "is there a best HA solution" but I suppose this thread is more about "best" than...

I am interested in knowing what others think of using virtualization as an HA solution. In particular what your opinions are of VMware and MS Hyper-V as alternatives to traditional...

the two languages are being merged together soon so hopefully we can have the best of both worlds (or the worst of both - possibly)

http://www.dreamincode.net/forums/showtopic90326.htm

I was surprised at the holidays in USA, but then your wages are higher than in UK. I get 33 holidays plus public holidays, plus pension.

But those were won by...

I don't want to concatenate 2 different fields I want to concatenate all of a particular Field.

So if Column is Total and Rows are days of week. Mon=1,Tue=2,Wed=3,Thur=4,Fri=5. In a...

Did anyone find a solution to this?

I would also like to concatenate like:

=Join(Fields!Total.value,",").

I also have did similar for parameter selections.

I also want to show averages.

If this isn't possible can some-one explain how to make a table next to Matrix which has averages of the matrix?

I also have had to deal with bad design from 3rd party vendor. I made changes to supplied stored procedures to improve performanace / remove bugs.

But there was one...

microsoft site has a procedure called sp_help_revlogin which can copy usernames and encrypted passwords from one server to another. In the procedure it has :

"IF (@login_name IS NULL)

DECLARE...

The "application would need to reconnect to the mirror database" is not necessarily true because the new version of MDAC in Visual Studio 2005 contains a mirror-related feature with-in the...