URGENT - Steps needed before Decomissioning of a server

[Former Member]

Hi Everybody,

Currently we have Portal applications running on SQL 2000.We are going to decomission the servers,but before that we want to take a final Database backup for future restore.Is the Database restore possible with the ' Full Database' backup taken by SQL Enterprise Manager while the database is online ?

Please suggest.

Thanks,

s<i><b>A</b></i>mik.

[Former Member]

Hi Marcin,

Are you talking of msdb and Master databases ? Can you please be elaborate on what all to be backed up before scrappin down the server for future restore ?

Is the database backup while it is Online ok ? I mean,do we need to take the database offline before backup ?

Thanks,

s<i><b>A</b></i>mik.

[Former Member]

Hi Samik,

You don't need to take database offline.

Please look at following links:

https://websmp210.sap-ag.de/~sapidb/011000358700000332442005E

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/6f178c8d-0701-0010-1ba7-bbab22e8...

Regards,

Marcin Gajewski

[Former Member]

Hi,

The full database backup works only for data stored in tables. If You want to migrate all data You must remember to configure SQL logins, users, database and object owners and permissions.

Regards,

Marcin