2012年3月11日星期日

Disaster recovery - local account question

Hi Lance,
SQL Server Disaster Recovery Plan Examples at
http://sql-server-
performance.com/disaster_recover_examples.asp
Also If you are interested you can download and read the
MS SQL Server 2000 Operations guide from
http://www.microsoft.com/downloads/details.aspx?
displaylang=en&familyid=b91ce500-4ab7-4e1d-ac57-
03b5d0e1ab8a
There can be many disasters which are out of scope of this
topic. Disaster can be a serious non-recoverable Database
corruption due to HD failures or a non-recoverable system
crash which needs reinstallation from scratch. In both
cases you have to restore a copy of recent backup of your
database. Your Backup plan also varies from how important
is the data for you.
I did not undertand exactly what u mean by local accounts.
May be someone can answer this in a better way. Assuming
that you are taking about SQL Server logins, here are few
pointers to resolve such issues...
HOW TO: Transfer Logins and Passwords Between Instances of
SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-
us;246133
HOW TO: Resolve Permission Issues When You Move a Database
Between Servers That Are Running SQL Server
http://support.microsoft.com/default.aspx?kbid=240872
PRB: "Troubleshooting Orphaned Users" Topic in Books
Online is Incomplete
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;274188
Fixing Broken Logins and Transferring Passwords
http://www.databasejournal.com/feat...l/article.php/1
438491
HTH
Regards
Thirumal
>--Original Message--
>We have sql server 7.0 and 2000 servers that run
databases used for web front-ends in asp. I have been
given the task of coming up with disaster recovery
procedures. It looks like the databases are backed up
properly off site, however, each database has a number of
local accounts used by the asp developers to access the
stored procedures. My concern is if a disaster would
occur, how could the local accounts be migrated to the new
servers.
>In other words, can local accounts be backed up and
restored or is there a better way of doing this.
>Thanks in advance.
>Lance
>.
>Thanks for all the information, that's just what I was looking for. By the way, I also
found a nice script for transfering the accounts at www.winnetmag.com/sqlserver/a...090/16090.html.

没有评论:

发表评论