Thanks will try this, most of the articles tied to this error refere to the firmware on the RAID, it say MS put this in in sql 2000 SP4, but...

Are you referring to free disk space for the mdf file? If so it has over 100 gig

thanks. One ? since you have been down that road. I was going to use SSIS to export logins. I have a mix of sql and nt/sql,...

After you have backed up the transaction log, you can you the GIU to shrink the file, or you can use dbcc shrinkfle, either will work

use SSIS package to move logins, jobs and sysmessages, works great.

Why not use Litespeed to compress the backup files themselves?

Log shipping is for DR, if you backup the logs with log shipping you will blow up the log shipping

people skills should also include some business analysis skills. Any good dba should understand why, not just how. When working with users and developers this makes both life...

Thanks, Duh missed this approach. Biztalk is it's own beast and come sometimes go crazy and with it the log file

What are you connecting with? Did you name the servers the same name?

Thanks, I get to tell my cowboy user this

Please ignore stupid, I was connected to the sql 2000 box when I tried this, in the words of my hero Homer Simpson

DUUUUUUUUUUUUUUUUUUUUUH!!

On your PC are the sql client tools installed? If so make sure you have tcp/ip and multi protocol. Go to your server and make sure the server...

I was aware of that route and had done this before. Problem is we are talking 28 gig across a T1 line

I believe your query timeout stops a specific query from running more than 600, not the connection itself