Dear all,
I backup the master, msdb, and my database from sql server 2000 by the add a
backup devices and backup all of these db into the backup devices..
Then it have one .bak file including the db's. Is it can restore by the sql
server 2000 when i reinstall the windows server and sql 2000 server?
or can i restore it into a new hardware system with windows server and sql 2
000server?Hi;
This BAK file can be restored in the below scenarios:
1. Restore in the same SQL server with a different name.
2. Restore it in the SQL Server after installation of Windows and SQL Server
3. Restore it in a SQL server with the same database name in a new hardware
For all the above you can use "RESTORE database " command.
Note:
This BAK files can be used when there is a crash of database. Better copy
this BAK file to
a safe place preferably to a TAPE device.
Thanks
Hari
MCDBA
"ken" <anonymous@.discussions.microsoft.com> wrote in message
news:672AFD82-EF81-4080-96D2-6344C048DCA2@.microsoft.com...
> Dear all,
> I backup the master, msdb, and my database from sql server 2000 by the add
a backup devices and backup all of these db into the backup devices..
> Then it have one .bak file including the db's. Is it can restore by the
sql server 2000 when i reinstall the windows server and sql 2000 server?
> or can i restore it into a new hardware system with windows server and sql
2000server?|||The SQL Server that you are restoring to has to have the same build number
as the one the backup came from.
This applies to the system databases, not the user databases.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||What is the build number?
If i reinstall the windows server as well as the sql server, will the build
number become a new number?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment