SQL Server 2005 Connect at Run Time

[Daniele Pinai]

Hi.
I had created a DB on Sql server 2005 Instance
Db Named 'My_Db.mdf" with My_Db_Log.ldf file .

After that i had detached it.
I had copied on my USB Pen Driver. All works Fine.

Now the problem became HARDER (for me)

On my USB Pen Driver the Mdf and Ldb file must be named 'Demo_Db'
Demo_Db.Mdf and demo_Db_Log.Ldf

I had tried the simplest way, renamed the file, obviously this way is wrong

Can i rename phisical file name and connect to these fiel at run time ??

can my Mdf file call different Ldf file ?? ( the same but with other name)

I Hope to be explane

Thank's a Lots for your answer !!!!

Daniele Pinai
Italy

[Erland Sommarskog]

Daniele Pinai (Daniel...@discussions.microsoft.com) writes:
> I had created a DB on Sql server 2005 Instance
> Db Named 'My_Db.mdf" with My_Db_Log.ldf file .
>
> After that i had detached it.
> I had copied on my USB Pen Driver. All works Fine.
>
> Now the problem became HARDER (for me)
>
> On my USB Pen Driver the Mdf and Ldb file must be named 'Demo_Db'
> Demo_Db.Mdf and demo_Db_Log.Ldf
>
> I had tried the simplest way, renamed the file, obviously this way is
> wrong
>
> Can i rename phisical file name and connect to these fiel at run time ??

You cannot connect directly to the files, you need to attach them to
SQL Server first. But obviously, the files can have any name when you
attach them. Look up the syntax for CREATE DATABASE FOR ATTACH in
Books Online.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx