Restored All Database Except for Master

Hi there,
Yesterday we built a new SQL server 2000 SP3, we restored all company
database using our b-up software. We tested them and our apps seems to work
fine against the newly built SQL server.
Question that is burning my head is: we restored everything except the
MASTER, MODEL, MSDB and PUBS. It was a matter of not knowing if they MUST be
restored together with our own databases.
Mind you, all our apps can talk and write and no problem at all. Do we still
need to restore these ones to our new SQL server?
Any advises or suggestions is much appreciated. Any questions is appreciated
too.
TIA
DMC
You might want to browse thru these to see why you may or may not want to
move the system dbs and what is involved. By the way there is nothing
special about Pubs, it is a sample db and is usually removed from production
servers.
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://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
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/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"dmc" <dario@.semiconductor.com> wrote in message
news:ebjbO6z9EHA.2984@.TK2MSFTNGP09.phx.gbl...
> Hi there,
> Yesterday we built a new SQL server 2000 SP3, we restored all company
> database using our b-up software. We tested them and our apps seems to
> work
> fine against the newly built SQL server.
> Question that is burning my head is: we restored everything except the
> MASTER, MODEL, MSDB and PUBS. It was a matter of not knowing if they MUST
> be
> restored together with our own databases.
> Mind you, all our apps can talk and write and no problem at all. Do we
> still
> need to restore these ones to our new SQL server?
> Any advises or suggestions is much appreciated. Any questions is
> appreciated
> too.
> TIA
> DMC
>

Restored All Database Except for Master

Hi there,
Yesterday we built a new SQL server 2000 SP3, we restored all company
database using our b-up software. We tested them and our apps seems to work
fine against the newly built SQL server.
Question that is burning my head is: we restored everything except the
MASTER, MODEL, MSDB and PUBS. It was a matter of not knowing if they MUST be
restored together with our own databases.
Mind you, all our apps can talk and write and no problem at all. Do we still
need to restore these ones to our new SQL server?
Any advises or suggestions is much appreciated. Any questions is appreciated
too.
TIA
DMCYou might want to browse thru these to see why you may or may not want to
move the system dbs and what is involved. By the way there is nothing
special about Pubs, it is a sample db and is usually removed from production
servers.
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://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
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/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"dmc" <dario@.semiconductor.com> wrote in message
news:ebjbO6z9EHA.2984@.TK2MSFTNGP09.phx.gbl...
> Hi there,
> Yesterday we built a new SQL server 2000 SP3, we restored all company
> database using our b-up software. We tested them and our apps seems to
> work
> fine against the newly built SQL server.
> Question that is burning my head is: we restored everything except the
> MASTER, MODEL, MSDB and PUBS. It was a matter of not knowing if they MUST
> be
> restored together with our own databases.
> Mind you, all our apps can talk and write and no problem at all. Do we
> still
> need to restore these ones to our new SQL server?
> Any advises or suggestions is much appreciated. Any questions is
> appreciated
> too.
> TIA
> DMC
>sql

Restored All Database Except for Master

Hi there,
Yesterday we built a new SQL server 2000 SP3, we restored all company
database using our b-up software. We tested them and our apps seems to work
fine against the newly built SQL server.
Question that is burning my head is: we restored everything except the
MASTER, MODEL, MSDB and PUBS. It was a matter of not knowing if they MUST be
restored together with our own databases.
Mind you, all our apps can talk and write and no problem at all. Do we still
need to restore these ones to our new SQL server?
Any advises or suggestions is much appreciated. Any questions is appreciated
too.
TIA
DMCYou might want to browse thru these to see why you may or may not want to
move the system dbs and what is involved. By the way there is nothing
special about Pubs, it is a sample db and is usually removed from production
servers.
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://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
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
Andrew J. Kelly SQL MVP
"dmc" <dario@.semiconductor.com> wrote in message
news:ebjbO6z9EHA.2984@.TK2MSFTNGP09.phx.gbl...
> Hi there,
> Yesterday we built a new SQL server 2000 SP3, we restored all company
> database using our b-up software. We tested them and our apps seems to
> work
> fine against the newly built SQL server.
> Question that is burning my head is: we restored everything except the
> MASTER, MODEL, MSDB and PUBS. It was a matter of not knowing if they MUST
> be
> restored together with our own databases.
> Mind you, all our apps can talk and write and no problem at all. Do we
> still
> need to restore these ones to our new SQL server?
> Any advises or suggestions is much appreciated. Any questions is
> appreciated
> too.
> TIA
> DMC
>

restore single table from backup

Hi,
I'm looking for tool that would allow me to restore a single table from a ba
ckup without restoring full database... I tried lumigent software but it did
not work as I expected...
Thank you for your help
Darekhi derek,
Im not sure about 3rd party tool. but with SQL Server, you can not restore a
single table out of backup. You can restore the database to a different SQL
Server, or if you are using same Server, then restore it with the different
database name and transfer the required table using DTS/bcp etc to destinati
on.
-- Vishal|||Read a while ago that CA has a tool to do this among others. You may check
with them. Of course in restoring a table (if you can) you always need to
watch out data integrity issues.
"Darek" <anonymous@.discussions.microsoft.com> wrote in message
news:CD4CFA7D-85A3-4D71-8524-EB3834C92123@.microsoft.com...

quote:

---

> Hi,
> I'm looking for tool that would allow me to restore a single table from a

---

backup without restoring full database... I tried lumigent software but it
did not work as I expected...

quote:

---

> Thank you for your help
> Darek

---

|||Hi,
SQL server versions which is higher than 6.5 will not support table level
restore, Only Filegroup / full database restore is available in SQL 7 and
2000.
Thanks
Hari
MCDBA
"Darek" <anonymous@.discussions.microsoft.com> wrote in message
news:CD4CFA7D-85A3-4D71-8524-EB3834C92123@.microsoft.com...

quote:

---

> Hi,
> I'm looking for tool that would allow me to restore a single table from a

---

backup without restoring full database... I tried lumigent software but it
did not work as I expected...

quote:

---

> Thank you for your help
> Darek

---

sql

restore master without sqlserver running?

due to a snafu on the reconfiguring of a server, a raid with the
database files was reformatted. unfortunately, our backup software does
not backup the db files since they are in use at the time of backup.
now, sqlserver won't start because there is no master.mdf file. i do
have a backup of the master db. is there any way i can restore that
without sqlserver running? or will i have to reinstall sqlserver and
then restore master along with all the other db's?This is a multi-part message in MIME format.
--=_NextPart_000_0135_01C3A9CE.AE173720
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
You can use the rebuildm.exe utility to rebuild master and then restore your
backup once that is done.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"chxxx" <chxxx@.dontemailme.com> wrote in message
news:3FB39E43.BBB2A260@.dontemailme.com...
due to a snafu on the reconfiguring of a server, a raid with the
database files was reformatted. unfortunately, our backup software does
not backup the db files since they are in use at the time of backup.
now, sqlserver won't start because there is no master.mdf file. i do
have a backup of the master db. is there any way i can restore that
without sqlserver running? or will i have to reinstall sqlserver and
then restore master along with all the other db's?
--=_NextPart_000_0135_01C3A9CE.AE173720
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

You can use the rebuildm.exe utility =to rebuild master and then restore your backup once that is done.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"chxxx" =wrote in message news:3FB39E43.BBB2A260@.do=ntemailme.com...due to a snafu on the reconfiguring of a server, a raid with thedatabase =files was reformatted. unfortunately, our backup software doesnot =backup the db files since they are in use at the time of backup.now, sqlserver =won't start because there is no master.mdf file. i dohave a backup =of the master db. is there any way i can restore thatwithout =sqlserver running? or will i have to reinstall sqlserver andthen restore =master along with all the other db's?

---

--=_NextPart_000_0135_01C3A9CE.AE173720--|||Ch
Look in books on line for how to restore your master
database. If you have a copy of the master.mdf, you may be
able to copy it to the location it should be in (d:mssql
or similar) and start sql server without needing to do
anything else.
If you can't restore master either way. If you still have
your user database you can do a fresh install and then
attach your databases. You will need to add your user
logins to the server before you can use it.
If you can not recover the msdb database you will also
need to recreate any jobs you had.
Hope this helps
John|||chxxx wrote:
> due to a snafu on the reconfiguring of a server, a raid with the
> database files was reformatted. unfortunately, our backup software
> does not backup the db files since they are in use at the time of
> backup. now, sqlserver won't start because there is no master.mdf
> file. i do have a backup of the master db. is there any way i can
> restore that without sqlserver running? or will i have to reinstall
> sqlserver and then restore master along with all the other db's?
when you say you have a backup of the master file is it a sql backup or
a standard file backup. If latter then you should be able to restore
that to its location and restart the server. If you are saying you have
a sql backup then you will need sql started in order to restore. You
can rebuild the master (rebuildm) and once sql is started you can
restore back from your sql backup to return to the original one.
--
Br,
Mark Broadbent
mcdba , mcse+i
=============|||Mark Broadbent wrote:
> chxxx wrote:
> > due to a snafu on the reconfiguring of a server, a raid with the
> > database files was reformatted. unfortunately, our backup software
> > does not backup the db files since they are in use at the time of
> > backup. now, sqlserver won't start because there is no master.mdf
> > file. i do have a backup of the master db. is there any way i can
> > restore that without sqlserver running? or will i have to reinstall
> > sqlserver and then restore master along with all the other db's?
> when you say you have a backup of the master file is it a sql backup or
> a standard file backup. If latter then you should be able to restore
> that to its location and restart the server. If you are saying you have
> a sql backup then you will need sql started in order to restore. You
> can rebuild the master (rebuildm) and once sql is started you can
> restore back from your sql backup to return to the original one.
the only backups i have are the sql backup files (.bak). the .mdf and .ldf
files are gone due to backup software not being able to back those up.
after reading bol, looks like i'll be able to use rebuildm to get sqlserver
running again.
then i'll be able to restore master and all other db's from the .bak files
i have on disk.|||chxxx wrote:
>
> Mark Broadbent wrote:
> > chxxx wrote:
> >
> > > due to a snafu on the reconfiguring of a server, a raid with the
> > > database files was reformatted. unfortunately, our backup
> > > software does not backup the db files since they are in use at
> > > the time of backup. now, sqlserver won't start because there is
> > > no master.mdf file. i do have a backup of the master db. is
> > > there any way i can restore that without sqlserver running? or
> > > will i have to reinstall sqlserver and then restore master along
> > > with all the other db's?
> >
> > when you say you have a backup of the master file is it a sql
> > backup or a standard file backup. If latter then you should be able
> > to restore that to its location and restart the server. If you are
> > saying you have a sql backup then you will need sql started in
> > order to restore. You can rebuild the master (rebuildm) and once
> > sql is started you can restore back from your sql backup to return
> > to the original one.
> the only backups i have are the sql backup files (.bak). the .mdf
> and .ldf files are gone due to backup software not being able to back
> those up.
> after reading bol, looks like i'll be able to use rebuildm to get
> sqlserver running again.
> then i'll be able to restore master and all other db's from the .bak
> files i have on disk.
Correct :?)
--
Br,
Mark Broadbent
mcdba , mcse+i
=============