December 8, 2009 at 2:39 am
Hello everyone,
I am taking daily backups for databases...
Once DB crash,then i can restore thats ok
data will come everything is fine.........
Then what abt logins...
We need to take the backup for logins also...????
How to take the backup for server logins..????
Thanks,
December 8, 2009 at 2:51 am
Logins are in the master database. You should be backing that (and msdb and model) up on a regular basis.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 8, 2009 at 3:07 am
Thanks Gail Shaw,
Eg:
Daily i am taking the backup of all DB's in F drive (except system DB's)
System DB's in G drive
All (system db's & user databases) files are removed from C drive (original mbf * ldf)
So if i restore everything from F & G, i will get databases & data as well
can i get logins ???
December 8, 2009 at 3:30 am
Wait a minute... How are you backing up these databases?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 8, 2009 at 4:30 am
I created maintainence plan for all databases..
December 8, 2009 at 4:40 am
So you're doing SQL backups (creating .bak files) for all the system and user databases?
If you have, then restoring all of those (restore database) will get the logins and data back. Check Books Online, the procedure for restoring master is not the same as for user databases.
Have you ever tested a restore?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply