Unfortunately there's no 5-minute way to do this in SQL 2000. One approach would be to script the schema into individual objects (e.g. using a tool like ApexSQL Script or...

I am not aware of any way to do it other than restarting the SQL Service. BOL has a topic which specifically addresses moving system databases and includes an example...

You'll want to look at performance monitor counters over a period of time to get an idea of what your server's up to and where the bottlenecks are. There are...

Best practice is to put tempdb on a separate set of spindles from other data files if you can. If you can't then consider spreading it across multiple RAID 1...

I've done this at least three times in the last 2 months. Detach and reattach works fine but make sure you have a backup just in case. Also, if you...

I finally put together all my scripts and install steps for using SYDI-Server with SQL 2005 :cool:. I posted it on my blog for anybody who's interested:

http://kendalvandyke.blogspot.com/2008/06/network-documentation-with-sql-2005-and.html

Kendal Van Dyke

You first need to baseline your current activity so you know if you're already running into bottlenecks or if you have room to grow. There are several products that you...

There's a previous thread about this as well:

http://www.sqlservercentral.com/Forums/Topic7055-5-1.aspx

The only way I've seen to fix it is restart the SQL Service. KB article 244934 applies to SQL 7.0 but it's worth looking at the workaround if the behavior...

Also, what are the values for QUOTED_IDENTIFIER set to at the DB, Server, and connection level for the two servers that you're trying to compare? My guess is that some...

What schema comparison tool are you using?

Are we talking about logs or data here? The approach you will want to take depends on which of the two you're dealing with.

Kendal Van Dyke

I should also mention that I rolled my own log shipping solution and didn't use what's built into SQL Server.

The point remains that you can still apply a full...

I think it was somewhere around...

Your last assertion is correct - you can log ship from 2000 to 2005. I've personally done this before when faced with the same scenario you are in.

Kendal Van Dyke