How did YOU detach it?

You can do it two ways.

1. Enterprise Manager. Right click on the database, select All Tasks, Detach Database.

2. Query Analyzer. Run:

USE Master

sp_detach_db 'dbname'

-SQLBill

Why can't you do it yourself? This should do the job.

INSERT INTO \\servername.dbname.owner.tablename

SELECT * FROM dbname.owner.table

-SQLBill

Good article about trying to work together. But it goes both ways. I'm a DBA and we have a developer who does EVERYTHING as a DTS package. Each step...

Nope, can't be used. It sounds like you don't have enough disk space for the files to be attached. Check that.

Can you afford data to possibly be lost?...

If your recovery mode is FULL, you need to do both the full backup and the transaction log backup. If you don't do the log backups, your log file...

You are correct....my mistake. I misread the request.

-SQLBill

Most important. Was the .mdf file copied when the database was offline? If not, it probably is unusable.

-SQLBill

What went wrong - an explanation.

COUNT is an INTEGER value.

count(convert(varchar(15), kund_id)) end as no_of_customers

Since the first values returned are COUNTs, the column becomes INTEGER. Then you get a value...

Previous versions were 6 & 7. Microsoft numbers the versions one up. That shows the progression even when the name doesn't.

-SQLBill

Try the RESTORE HEADERONLY command. Look up the syntax in BOL. I'm not sure that will give you what you want, but try it.

-SQLBill

Unfortunately once you recover the database you can't do any more restores. As Ronald says, you will have to start over. Remember to use that WITH NORECOVERY until you...

And they keep harping on the fact they are one of the youngest Oracle certified DBA's. But I knew a guy who had a photographic memory - he passed...

My problem is that the Books OnLine is downloadable. You are applying for a SQL Server DBA job and have posted LOTS of questions here. They are very basic SQL...

My problem is that the Books OnLine is downloadable. You are applying for a SQL Server DBA job and have posted LOTS of questions here. They are very basic...

Just so anyone else is interested:

FYI - this poster had this to say in another thread:

im oracle dba and applied for sql dba job and been given sql db questions,...