Re: Restored Backup problem

From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 04/20/05


Date: Wed, 20 Apr 2005 18:36:55 +0200

Hi

In master database.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_4g4w.asp

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Hoof Hearted" <HoofHearted@discussions.microsoft.com> wrote in message
news:87C35929-C18C-4C8A-A80C-B36283866EE2@microsoft.com...
>I had to reinstall my entire Server week. I had everything of importance
> backed up.
>
> When I put my Sql Server database .MDF files back, I found that although
> the
> Users within the databases were there, the Logins were not. Where are the
> Logins stored? I have my entire previous hard disk contents available. I
> just
> need to know what to restore.



Relevant Pages

  • Re: problem with query moving data from 1 dbase to another.
    ... You register a SQL Server instance, where such an instance can have several databases. ... Tibor Karaszi, SQL Server MVP ... > you know how to connect to an existing database, ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: error 80020009 HELP!!!
    ... Check your SQL Server event logs for any problems. ... Mike Epprecht, Microsoft SQL Server MVP ... > when they try to access the database through a web browser. ... > info by performing a database restore? ...
    (microsoft.public.sqlserver.server)
  • Re: View Security
    ... SQL Server MVP ... Columnist, SQL Server Professional ... The user can see list of other users who can login into the database. ... able to see all database structue such as view/table/sp definitions. ...
    (microsoft.public.sqlserver.security)
  • Re: restore problem about sql server
    ... > i reinstall the sql server on the machine, and use attach file method ... > to get the database back, and it works well on the server, which means ... but it used to be ok before i reinstalled the sql server. ...
    (comp.databases.ms-sqlserver)
  • Re: How do I Allow SQL DB dump job through a firewall?
    ... I'll try to setup a process that grabs the database on a regular basis after ... > Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.server)