November 20, 2013 at 3:05 pm
I have 2 develop PC, A and B in which SQL 2008 R2 were installed.
I want to move ORDER database from A to B as the following steps:
1) copy order.mdf from A to B at d:\sqldata\order.mdf
2) at B, right click Database, Attach...
But, there is no order.mdf.
Can someone help me?
November 20, 2013 at 3:24 pm
Instead of detaching and moving files I would recommend creating a backup and then restoring that backup on your other server.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
November 20, 2013 at 5:27 pm
Agreed with Sean. Backup and restore. You database name is order but that does not necessarily mean your datafile name is order.mdf. If you need to find out the name and location of your database files you can run
exec sp_helpdb <databasename>
e.g.
exec sp_helpdb order
In the second resultset that gets displayed it lists all the data and transaction log files for that database
November 21, 2013 at 7:04 am
I did backup.
The problem is that order.bak file is not under list.
November 21, 2013 at 7:19 am
adonetok (11/21/2013)
I did backup.The problem is that order.bak file is not under list.
are you looking at correct path/folder? OR do you have any (suggested) BACKUP file extension like .BAK ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 21, 2013 at 7:36 am
I did windows update, it is ok now.
Thanks for help.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply