September 12, 2010 at 9:52 am
Help I am being robbed 🙁
I answered the question accurately but I get a response saying that it is wrong even though they say that the answer I choose is right. (See below)
Moving Files
How can you move data files in SQL Server 2005 from one drive to another? (Check all that apply)
Sorry - you were wrong
Correct answer: Use sp_detach_db and sp_attach_db, ALTER DATABASE, Backup the database, drop it, and restore it using the WITH MOVE option.
Explanation: There are two basic ways of moving data files in SQL Server 2005. You can detach the files, copy them to the new location, and then attach them back. You can also use the ALTER DATABASE command with the MODIFY FILE options. You can also backup the database, drop it, and restore using the new location.
Ref: Moving User Databases - http://msdn.microsoft.com/en-us/library/ms345483.aspx
Nigel Peter Sammy
TTSSUG Chapter Leader
http://www.nigelpsammy.com
http://twitter.com/NPSammy
September 12, 2010 at 9:53 am
Which question is this? Can you provide a URL?
September 12, 2010 at 11:05 am
Thanks for the quick respond Steve.
I am new to the QotD section so I am not sure if I did anything wrong.
http://www.sqlservercentral.com/questions/Administration/63290/
Nigel Peter Sammy
TTSSUG Chapter Leader
http://www.nigelpsammy.com
http://twitter.com/NPSammy
September 12, 2010 at 11:11 am
NPSammy (9/12/2010)
Thanks for the quick respond Steve.I am new to the QotD section so I am not sure if I did anything wrong.
http://www.sqlservercentral.com/questions/Administration/63290/
Do you recall the answers you selected? Sometimes you can click back to verify your answers. I have found that to be helpful.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 12, 2010 at 11:49 am
Well I cant now but I just highlighted to see if any one else got a similar issue that way we will know it really is a bug. Maybe I did something wrong before submitting my answer so there is no need to look into it too much.
Nigel Sammy
Nigel Peter Sammy
TTSSUG Chapter Leader
http://www.nigelpsammy.com
http://twitter.com/NPSammy
September 12, 2010 at 7:33 pm
There's a discussion for each question. If you check that, you might see if someone else saw a similar issue.
September 13, 2010 at 5:51 am
Cool thanks for the information Steve.
Nigel Peter Sammy
TTSSUG Chapter Leader
http://www.nigelpsammy.com
http://twitter.com/NPSammy
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply