MS SQL Server - SQL2000 meltdown on its way?

Author

SQL2000 meltdown on its way?

gstar

2006-02-09, 8:23 pm

Hi,
We have SQL 2000 running with several databases live to the public. In
the next few days our web developers are rolling out substantial
updates to the system and history tells me this could go badly wrong!
Presently I have a maintenece plan which does a complete db backup each
night and hourly log backups on the hour but restoring in the past has
mucked up permissions and accounts (as you can see I'm no expert
here!). Am I doing something wrong with the maintenence plan or is this
normal with SQL 2000? Secondly has anyone any improved ideas what I can
do to minimise the problems if something does go wrong? I thought about
getting an XP box with identical SQL setup and asking the developers to
roll out there first to test the water....Does anyone have a step by
step process for completly recreating the DB with permissions should
the worst occur?

Any ideas appreciated.

Andrew J. Kelly

2006-02-09, 8:23 pm

http://www.sqlservercentral.com/scr...utions/1598.asp Script
Roles and Permissions
http://www.sqlservercentral.com/col...irdatabases.asp
Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after
a Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers

http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=320125 Moving a Diagram
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues 2000
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://msdn2.microsoft.com/en-us/library/ms345408(en-US,SQL.90).aspx Moving
system dbs 2005
http://www.databasejournal.com/feat...cle.php/3379901 Moving
system DB's 2000
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore

--
Andrew J. Kelly SQL MVP

"gstar" <gary.brett@gmail.com> wrote in message
news:1139514965.532199.167480@g44g2000cwa.googlegroups.com...
> Hi,
> We have SQL 2000 running with several databases live to the public. In
> the next few days our web developers are rolling out substantial
> updates to the system and history tells me this could go badly wrong!
> Presently I have a maintenece plan which does a complete db backup each
> night and hourly log backups on the hour but restoring in the past has
> mucked up permissions and accounts (as you can see I'm no expert
> here!). Am I doing something wrong with the maintenence plan or is this
> normal with SQL 2000? Secondly has anyone any improved ideas what I can
> do to minimise the problems if something does go wrong? I thought about
> getting an XP box with identical SQL setup and asking the developers to
> roll out there first to test the water....Does anyone have a step by
> step process for completly recreating the DB with permissions should
> the worst occur?
>
> Any ideas appreciated.
>

Sponsored Links