which perhaps partly accounts for why it costs 25% more 🙂

The best way to rename a file is to offline the database, use alter database modify file to amend the file path in sys.master_files, physically rename the file to match,...

does that file actually exist?

is this message occuring on startup during the database recovery phase?

as you say you are a new user........

your system database files are not necessarily in the same location as your user databases.

what does the query

select type_desc, physical_name from master.sys.master_files...

then personally this is a non-problem I would not waste time trying to fix. I would provide EM to administer this instance.

then I highly recommend you use SQL2000 tools to administer SQL2000 instances,...

are they connecting remotely and what version are the client tools if they are.

does it work if they use enterprise manager rather than SSMS?

GSquared (3/31/2010)

GilaMonster (3/30/2010)

You're complaining?

You know how many ways there are to misspell either a 4-letter name...

Asking about SQL server internals in an interview seems over the top, I think the answer that one works at the transaction log backup level and the other at individual...

my pleasure.

people what code but can't restore databases! :-):-D;-)

you can do that either through the reports web page or via SSMS, its just a matter of adding them to the correct Role.

when setting up RS on the failover server you should have done all the configuration steps exactly as on the primary server, including creating RS databases, did you do that?

The...

Apologies Ron, reading my post back I realise it sounds a bit brusque, which I did not intend.

I should have just said my code was SQL2005 compatible.

presuming this is SQL2005 the above will not work in SQL2005.

As this is a one off exercise you can reverse engineer the SQL and run the results -- AFTER EDITING...