Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

"Sql server error 5120" while attaching database Expand / Collapse
Author
Message
Posted Thursday, May 12, 2011 10:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 12, 2011 10:52 AM
Points: 1, Visits: 0
Thank You Very Much
Post #1107899
Posted Thursday, June 16, 2011 7:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 16, 2011 7:42 AM
Points: 1, Visits: 0
THANK YOU!!!!!!!!!!!!! You saved me from more hours of frustration
Post #1126537
Posted Wednesday, August 10, 2011 8:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:42 AM
Points: 4, Visits: 185
Hello Mr.

è an old post, but decided that situation as follows:

When you attach the base within the D: \ <folder> \ MSSQL \ Data presented this error so I created another folder inside the Data folder put the base you want to attach inside the folder I created and it worked then the path was D: \ <folder > \ MSSQL \ Data \ <new <folder

Note: We attach multiple database within the directory D: \ <folder> \ MSSQL \ Data, and have never been read-only just this last.
Post #1158163
Posted Wednesday, August 17, 2011 11:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 18, 2011 10:32 AM
Points: 2, Visits: 9
Hello, I'm receiving this error also. I'm trying to attach some databases that came with the MCTS 70-433 Exam Training Kit. After copying the databases from the CD to my hard drive, two of the databases attached fine. But a third, which required I copy an .ldf file, an .mdf file, and a documents folder, will not attach. The error message says that it cannot find the Documents file specified. Which is weird, because it's in the same place as the data files. It's looking for '\MSSQL10.MSSQLSERVER\MSSQL\DATA\DOCUMENTS' but the default name of the program file given (which I can't/don't know how to change) is '\MSSQL10_50MSSQLSERVER\MSSQL\DATA....'

Just trying to learn SQL Server after learning Oracle.

Any help on this? I'm running Windows 7, SQL Server 2008 R2. And I've logged in Windows Authentication mode. Thanks in advance.
Post #1161343
Posted Wednesday, August 17, 2011 12:05 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:27 AM
Points: 42,843, Visits: 35,970
Please post new questions in a new thread. Thanks


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1161354
Posted Thursday, September 1, 2011 9:12 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, June 10, 2012 6:08 AM
Points: 1, Visits: 7
I ran Sql Server Management Studio as Administrator and used the usual steps and it worked for me.


Brij Kishore Sharma
Solution Rally
Post #1168747
Posted Monday, November 14, 2011 9:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 16, 2012 8:19 AM
Points: 9, Visits: 29
dotnet-786228 (6/18/2008)
Hello !!!

try login with Windows Authentication.

Gala;)


This solved my problem.
Post #1205369
Posted Wednesday, February 1, 2012 3:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 6, 2014 1:10 AM
Points: 4, Visits: 75
1) you check which login credential Windows/user
go windows with adminisrator
2) even you face prob
take bakup and resotre the best way
Post #1244940
Posted Tuesday, June 12, 2012 10:09 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 19, 2013 8:05 PM
Points: 2, Visits: 15
Thank you!!
It worked out for me when i logged in using Windows Authentication.
Post #1314847
Posted Sunday, June 17, 2012 12:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, June 17, 2012 12:53 AM
Points: 1, Visits: 0
copy your both mdf and ldf files to the default database folder of the sql server edition. for 2010 express edition u need to copy it to C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\. Then try to attach the db, it may work.
Thanks...
Post #1317028
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse