It's not about the service...it's about the databases. TEMPDB MUST be restored first. If you clicked on the databases or tried to connect before the TEMPDB came up....it...

In the 2005 BOL (Books OnLine), filter to SSIS, and look up Deployment Utility. The package must be part of a solution. In the properties of the solution, you...

Do you have the option to Shrink the file checked? What are the values for "Shrink database when it grows beyond" and "Amount of free space to keep after shrink"?...

An identity column always increments by the SEED value. It doesn't matter which server the database is on. That's like having a VARCHAR(10). You can move the...

What editon/version of SQL Server is installed on the Laptop and what OS is on the laptop?

By edition/version, I mean:

SQL Server 2000 or SQL Server 2005?

MSDE, Express, Developer, Personal, Standard,...

Since you don't give us the actual statement and you mask the database name, I'm guessing your database name has a dash in it like this: My-DB. If so,...

I would expect January 3, 2007. SQL Server's default is YMD, so given 2007/01/03, SQL Server 'knows' the first part has to be the year and that means the...

What values are you trying to enter that are giving the error? That's where you need to start.

-SQLBill

I'm seeing that the user databases are skipped and then TEMPDB comes up. I don't believe user databases can be restored prior to ALL the system databases being restored. ...

Look through the SQL Server Error Log....there is a good chance you ran out of space on your backup drive.

-SQLBill

Yep, installed the DTS Designer components and the Backwards Compatibility parts.

-SQLBill

Amazing you would ask this....I had the same question and found an awesome answer on this site. I no longer have the path to the originator...but...

1. Copy the DTSRUN line...

Yes, it's been posted on this site several times....but it's just:

RESTORE DATABASE dbname WITH RECOVERY

Replace dbname with the actual database name. Yes, it's that easy.

What does Enterprise Manager show? Expand the databases and refresh. Is the database in LOADING? If so, it could be done and just waiting the next restore command.

-SQLBill

Make sure there are no jobs running. If you can, stop the SQL Server Agent until you are done.

Are you using Enterprise Manager and then opening Query Analyzer to do...