DECLARE @BackupFile char(91), -- 91 is length of BACKUP script

@strSQL VARCHAR(8000), @DateSuffix char(16)

set @DateSuffix = CONVERT( char(16), getdate(), 121 )

set @DateSuffix = replace(@DateSuffix, '-', '')

set @DateSuffix = replace(@DateSuffix,...

I came across this in my notes, but haven't tried it lately ... (too tired & busy right now)

+++++++++

--This selects every 500 th record, using an identity field

SELECT fielda, fieldb,...

+1 The price is right

We need more info. Are your different databases related, so that there might be common tables and SPs in multiple DBs ? Or are you combining unrelated...

RESOLUTION: There was a duplicate IP address caused by dhcp after upgrading to Windows Server 2003. It has been removed, so that should resolve it.

Thanks to everyone for all the...

FWIW:

I just tried to ping the server & it timed out, although I could remote desktop into it, so it is up & running. Normally, I have been connecting with...

+1

Could you do "in-place" ?? side-by-side seems like so much more work, but may be required in your situation.

Are you doing "In-Place" upgrade or "Side-by-side" upgrade ? I've just done "In-Place" upgrade and I didn't have to do anything for replication. It kept right on working...

Put on Service Pack 2, then you'll get it (not sure about SP1)

We use a similar product, SQLSafe by Idera. Works quite well. Otherwise, you could xxcopy the backuping across the network, then doing the restore locally. That's what...

Thanks for all the replies !

BOL has this about ALTER INDEX (replaces dbcc dbreindex), so maybe I can reindex while users are accessing the tables, even though I'm in 80...

ALZDBA (10/30/2007)

---

- also keep in mind with an in-place upgrade, all your databases (including the system databases) are still at db_level 80 (sql2000) !

- If you want to use the...

I have not re-indexed anything. I encountered some problems over the weekend during the upgrade & ran out of time. Is it recommended to rebuild all indexes ?

I ran into a couple of issues installing a separate instance of 2005 on a box that already had 2000. One issue was a conflict with JDBC drives ... it...