Please help e!! not sure what to do..SQL Database user moved under System Databases

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Please help e!! not sure what to do..SQL...

Please help e!! not sure what to do..SQL Database user moved under System Databases

Rate Topic

Display Mode

Topic Options

Author

Message

montse 22199

Posted Tuesday, November 06, 2012 4:04 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 22, 2013 2:08 PM
Points: 19, Visits: 63

Hello Experts,
I have a software that is running with SQL Server 2005. The software has an utility to configure replication between 2 databases. When I was trying to configure it, by mistake I placed the same name of my main db (tlmain) and the tool placed the db under SYSTEM Databases Sad

. I think it created as a distribuitor database now.
The weird part is that my data is there and my client sw is working fine but I would like to re-configure my db again as a user database.
How can I accomplish this?
Im thinking to backup my database first and put it offline and the restore the database again. But Im not to expert in SQL and also I am not sure if this will work putting back the database as a user database.
I need help please !!! advices and tips are welcome...im super stress because the database grew fast and also I cannot configure my replication between the 2 databases I have because of this!!

Im attaching the image of my db.

Post Attachments

bd.doc (15 views, 364.50 KB)

Post #1381741

sanket kokane

Posted Tuesday, November 06, 2012 10:40 PM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 11:12 PM
Points: 323, Visits: 973

Duplicate post

http://www.sqlservercentral.com/Forums/Topic1381740-1292-1.aspx

-----------------------------------------------------------------------------
संकेत कोकणे

Post #1381792

« Prev Topic | Next Topic »

Permissions