Are you looking to partition the tables across multiple file groups or databases? What is the problem you are trying to solve?

You don't want to do this in T-SLQ, it's horribly inefficient. Holding a file handle is asking for concurrency issues. Using a cursor wastes resources. And SQL Server will not...

XQuery is the choice for this, but it's limited in 2000.

This is really something you want to do in another language, not T-SQL.

You can do all that, but most people just won't read the rules/ideas/hints, and just post a question.

We have PDF versions and are working with developers to get an "ebook" section here on the site.

Log backups will keep the log at a manageable size.

You should have free space in your data files, which is used up as you add data and make changes.

How big...

It was always one of my favorite things early on in this site to answer questions and help others. I've always felt that most of the people reading the forums...

Robert,

I agree and I'm always happy to see people posting hints rather than complete solutions. Especially when people haven't made any attempt at it themselves.

Never hurts to apply a little more pressure. You've got fans now!

thanks for the recommendations on speakers. I'll check them out. Always good to find someone worth listening to.

Also , the network can be unreliable. Copies and other file operations tolerate this. The SQL Backup process won't.

You really want to back up locally and then copy to a...

norecovery can't be used with notrunate apparently. I don't see anything in BOL, but I bet you can remove the no_truncate and it will work.

http://msdn.microsoft.com/en-us/library/aa225964(SQL.80).aspx

That was a nice response.

and a great effort from you, Jack.

Thanks for the update. Was sure it was networking somewhere.

Can you not connect to the server at all, or just this database?

Can you connect to master on this instance?