lundi 9 juillet 2012 07:47
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
Toutes les réponses
lundi 9 juillet 2012 07:49
lundi 9 juillet 2012 08:10
I am not clear on your reply....
please in second server there is no sqlserver
lundi 9 juillet 2012 09:08
lundi 9 juillet 2012 12:30
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.
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.
mardi 10 juillet 2012 13:55
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
jeudi 12 juillet 2012 04:04
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:
- Use Copy database wizard from SQL Server Management Studio
- Create script using Generate Script Wizard
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
- Marqué comme réponse amber zhangModerator lundi 16 juillet 2012 04:55
mercredi 17 octobre 2012 09:02
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..
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!