Guys,

I think you're missing it ... you are just repeating what I've already posted up there.

I know that SQL creates the numeric suffix which is appended at the end of...

Anzio can you elaborate a bit more on your post please ... doesnt really give me more to go on with.

-¢ödêmån-

MSSearch should be running with the same account as SQL Server.

Also check out this link

http://dbforums.com/arch/72/2003/1/643358

Cheers

-¢ödêmån-

Glad to see someone brought this up, I must say this is a very important topic Andy.

After working from a financial institution who had money to blow on DASD and...

I've got 3 Servers which are win2k adv, sql2k ent and fixed mem seem to act different on all 3. I still cant work this one out, can anyone shed...

All these can actually be done in the RESTORE DATABASE command see BOL.

restore database new_name from disk = 'c:\sql\backup\d_database_name.bak' with

move 'logical_filename_data' to 'physical_OS_new_name'

etc...

-¢ödêmån-