I was not aware of SQL Zip at the time of this article or I would have included it for sure. I have used SQL LiteSpeed in our sql farm...

Part two uses a 50 gig CRM database on a 6 way box with 8 gig of ram attached to a SAN. That is due out in a couple of...

To be honest with you I'm not sure. Peter Yeoh may be able to answer that one? It may be the compression methods used.

SQL Litespeed offers scripts for log shipping as well. I'll check with Idera about SQL Safe.

Wes

It looks in a diffrent location for the server name @@SERVERNAME was used from 7.0 and back and has to have an entry in the sysservers table to work. that...

Also, if you are using sql 2000 try

cast(serverproperty('servername') as varchar(256))

should return the name even if @@servername returns null

Nether osql -l or SQL DMO will properly detect a cluster instance name. It will pick up the active node name but not the actual cluster name.

wes

Here is another thread

http://www.sqlservercentral.com/forums/shwmessage.aspx?messageid=105032

Also, what SP are you running there was a bug with restores and attaching databases that was fixed in I want to say SP3

Wes

Can you give some more detail. What do you mean by dump the transaction log?

I would agree. We are running win2k3 and haven't had any major issues but I haven't had to restore anything over 40 gig yet on those systems. We did have...

set xact_abort ON

have you tried setting it before you do your insert?

When you use the servername it thinks it is a linked server and will make a trip to find it. If you are on the same server three part names...

actually, I don't use linked servers at all. I use osql and bcp. every server has a management database on it that houses all the tables and stored procs every...

I'm a home grown guy myself. Everything happens by server groups Prod Dev Test etc. and sub groups. All maint jobs and scripts deploy from a single administration server. All...

Good man! BOL is your best first source for information. I use it every day.

Wes