Where do I look to find BIDS after its installed? I am reinstalling now to see if I can get that installed. However, I have a few installs now and...

Thank you, that worked!

I receive this:

Msg 3141, Level 16, State 0, Line 6

The database to be restored was named 'pbFamily'. Reissue the statement using the WITH REPLACE option to overwrite the 'Pbfamily_new' database.

Msg...

Hi Deepak,

I tried the command I get:

Msg 3101, Level 16, State 1, Line 4

Exclusive access could not be obtained because the database is in use.

Msg 3013, Level 16, State 1,...

I think I may have the wrong names:

Here is what I get when I run the commands:

RESTORE FILELISTONLY FROM DISK = 'C:\SQL-Backups\pbfamily\pbFamily_db_200805040200.BAK'

Results:

PBFamily_Data d:\Program Files\Microsoft SQL...

Just to confirm:

I have 1 database

I have 2 .BAK files, both from the same database. One is from last month and the other is the current date. Lets...

I was able to restore a DB that was created in SQL Server Express 2005 to a Server Server 2005 Enterprise Edition.

The problem was that the Enterprise Edition database is...

Here is the error message:

Restore failed for Server 'pb003070\express'. (Micrsoft.SqlServer.Express.Smo)

System.Data.SQLClient.SQLError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetFor Creation' on 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\lava ent.mdf'. (Micrsoft.SqlServer.Express.Smo)

Thanks, I tried this morning and everything worked great. You can tell I am new to SQL 2005. It was kind of confusing to startup of the Management Studio Express...

I am logged into this server now:

9.00.3042.00SP2Express Edition

The other one is the Enterprise edition. The 2005 is the Express Edition. Will that work?

I think my confusion is that I have SQL Server 2000 and SQL 2005 on Server. I was logged into the wrong one.

One server is: 8.00.2039SP4Personal Edition

The other: 9.00.3054.00SP2Enterprise Edition

I see now. So, they are different.

How can I take a DB in the Enterprise Edition and restore it to the Personal...

I am not really sure. This is what the About boxes say on the SQL Server 2005s.

Server B

Microsoft SQL Server Management Studio Express9.00.3042.00

Microsoft Data Access Components (MDAC)2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)

Microsoft MSXML2.6 3.0...