Viet: Attach Sample DB AdventureWorksLT2012

Monday, May 25, 2015

Attach Sample DB AdventureWorksLT2012_Data

On this post Error 5120 When Attached Database, the attached database has two files the MDF and the LDF. But if you have only one MDF file, how do you attach?

Download from http://msftdbprodsamples.codeplex.com/releases/view/55330
Open MSSQL Management Studion as local administrator
Attach the file AdventureWorksLT2012_Data.mdf
High light the LDF files row to delete and click Ok button at the end

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

“Trust in the LORD and do good that you may dwell in the land and live secure.” (Psalms 37:3)

“Cast all your worries upon him because he cares for you.” (1 Peter 5:7, NABRE)

“Limit the time you spend among the stupid, but frequent the company of the thoughtful.” (Sirach 27:12)

“God gave me my money. I believe the power to make money is a gift from God—to be developed and used to the best of our ability for the good of mankind. Having been endowed with the gift I possess, I believe it is my duty to make money and still more money and to use the money I make for the good of my fellow man according to the dictates of my conscience.” ―John D. Rockefeller

“I believe God is managing affairs and that He doesn't need any advice from me. With God in charge, I believe everything will work out for the best in the end. So what is there to worry about.” ― Henry Ford

“Aim for the highest; never enter a bar-room; do not touch liquor, or if at all only at meals; never speculate; never indorse beyond your surplus cash fund; make the firm’s interest yours; break orders always to save owners; concentrate; put all your eggs in one basket, and watch that basket; expenditure always within revenue; lastly, be not impatient.” ― Andrew Carnegie, The Road to Business Success