Attach SQL Server Databse from Backup


hi,

we using sql server 2005 , have deleted database (technicaldb).  have retrieved copy of database (both mdf , ldf) files backup.

we have tried attach database (mdf , ldf) on server running sql server.  find have recreate both sql server , database login again.

when attach database original server, need delete sql server login & recreate or can map sql server login attached database ?

thanks

hi tony,

is attached happened on remote , local server?

for remote server, need add login , if go orphan user please fix that, more details on : http://www.mssqltips.com/sqlservertip/1590/understanding-and-dealing-with-orphaned-users-in-a-sql-server-database/

for same server, shouldn't need add login , things should work you. in case these logins got created need add login , user @ both level server , database.


santosh singh



SQL Server  >  Getting started with SQL Server



Comments

Popular posts from this blog

Azure DocumentDB Owner resource does not exist

BizTalk Server 2013 Azure VM Log Shipping and HA for hosts

How to send non-standard Content-Type header ?