how to move mdf and ldf file without detach one machine to another machine

Question

Can you any one suggest me...

'a' server having sqlserver database running good but suddenly windows corrupted & Board also having problem

I taken hard disk of 'a' server connected to another server machine but i am unable to move mdf and ldf file from 'a' server disk to 'b' server disk showing

error : can't read from the source file or disk

Answer 1

Backup\Restore?

BACKUP DATABASE dbname TO DISK = 
    N'\\Server\sharedfolder\dbname.BAK' 

---

Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/

Blog : MS SQL Development and Optimization

Blog : Large scale of database and cleansing

Answer 2

I am not clear on your reply....

please in second server there is no sqlserver 

Answer 3

So what are you trying to achieve? Install SQL Server on the second machine and move the database.

---

Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/

Blog : MS SQL Development and Optimization

Blog : Large scale of database and cleansing

Answer 4

are you sure that Harddisk which you have is healthy mean in terms of data  and also on the B server it is detecting the disk in healthy manner.

if you have the Backup of databases then you can install sql server(+sp+hot fix) similar to A which was runninng then you can restore the DB's.

or

what is your requirement?

---

Rama Udaya.K ramaudaya.blogspot.com ---------------------------------------- Please remember to mark the replies as answers if they help and un-mark them if they provide no help.

Answer 5

i think your problem is of permissions here, the hard disk that you have attached to new box where you are trying to copy files to local drive.

right click on files which needs to be moved/copied-> Properties -> Security -> Add "Everyone" account and give full permission to it.

now you will be able to move files.

Please remember to mark the replies as answers if they help

Answer 6

What is the version of your SQL server?

If you are using SQL server 2008 then try another two methods to move MDF & LDF from one server to another:

1. Use Copy database wizard from SQL Server Management Studio
2. Create script using Generate Script Wizard

Source: http://blogs.msdn.com/b/sreekarm/archive/2009/09/11/move-a-database-from-one-server-to-another-server-in-sql-server-2008.aspx

---

Read my blog (Blog)
Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

Answer 7

hi, 

Check this http://www.soheib.com/technical-knowledge/move-database-files-mdf-ldf-to-different-physical-location/ for moving database from one location to another and in addition to this..

you can check this also: http://blogs.msdn.com/b/sreekarm/archive/2009/09/11/move-a-database-from-one-server-to-another-server-in-sql-server-2008.aspx

Henry Desouza,
Technical Support Engineer

Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you!