How to attach a database from other server

Hi

I have created a test enviroment, by installing SQL server express and SSRS on my laptop.

I also have a production server, and i am trying to make a copy of one of its database and linked it to my test server.

How do i do it?

Thanks

Hello,

If you can take the database offline:

Take the database offline, manually copy the data and log files to your test server, then attach the database back on your production server, then on the test server.

If you can not take the database offline:

Create a backup of the database on your production server, then restore it to your test server.

Hope this helps.

Jarret

|||It works. Thanks1

how to access the Sql server ...

hi ,

I have the Data and log file of the pubs dataBase(pubs,pubs_log)...

Now i want access the pubs database through the C#.net without installing the Sql server in my system.. just like the Msaccess. please any body tell me.. is it possible.

Thanks & Regards,

S.Sajan

That is not possible.

You must have SQL Server installed to use the Northwind and Pubs SQL Server databases.

You can get an Access version of Northwind here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=C6661372-8DBE-422B-8676-C632D66C529C&displaylang=EN

You can get an Access version of Pubs here:

http://authors.aspalliance.com/andrewmooney/53/pubs.zip

You could then use them in your C# application with the JET provider.

|||

hi Arnie Rowland,

Thanks for ur reply....my doubt is i want to deploye my project in client side.. in that time th don't see the data base... so..without installing the Sql server can access the database through the c#.net

|||

Your application can also install the SQL Server.

See these resources:

SQL Server 2005 UnAttended Installations
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
http://www.devx.com/dbzone/Article/31648