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 system dbs from SP3 to SP3a?

Can system databases (master, model, msdb) backed up from SQL2k SP3 be restored to an instance of SP3a? Can they be restored from SP3a to SP3? TIA!Not going to happen buddy. try installing a fresh copy of sql server somewhere else upgrade to sp3, restore your system db's there, upgrade to sp3a then move the system db's to the live server. hope this helps.|||Thanks - that's what I thought. However, how can it be determined which SP (3 or 3a) a given instance is running? @.@.version returns 8.00.760 for both of them, & Properties in EM show SP3 for both. I remember there being a way to find the build number, but I don't know how to get it. TIA.|||Check with MS website at the SP3/SP3a download pages. They usually have a section that tells you how to determine which SP you're currently running under.|||Even better: http://www.sqlteam.com/item.asp?ItemID=8318

Restore SQL master database from a file

Hello,

I need to restore the Master DB in my SQL 2k server (with sp3). The
problem is that i don't have SQL backups of this file I only have
general backup of the entire c:\ drive i made using NTBackup. So i
tried all I know and succesfully run the rebuildm utility. Now when I
try to restore it from the general backup (not SQL backup) using
"restore database master from gen_backup" i got error: "The file on
device 'gen_backup' is not a valid Microsoft Tape Format backup set."
RESTORE DATABASE is terminating abnormally.
Any ideas how I can restore it?<Moti.Ba@.gmail.com> wrote in message
news:1105264654.916229.258480@.c13g2000cwb.googlegr oups.com...
> Hello,
> I need to restore the Master DB in my SQL 2k server (with sp3). The
> problem is that i don't have SQL backups of this file I only have
> general backup of the entire c:\ drive i made using NTBackup. So i
> tried all I know and succesfully run the rebuildm utility. Now when I
> try to restore it from the general backup (not SQL backup) using
> "restore database master from gen_backup" i got error: "The file on
> device 'gen_backup' is not a valid Microsoft Tape Format backup set."
> RESTORE DATABASE is terminating abnormally.
> Any ideas how I can restore it?

Is this the same problem you had a few months ago?

http://groups.google.co.uk/groups?h...news.bluewin.ch

If you have the master.mdf and mastlog.ldf files (if you can restore them
from your NTBackup backup set), then you can try the process I described
earlier, although I haven't tried it myself, so I can't say for sure that it
will work.

Whatever happens, you need to set up proper MSSQL backups to make sure you
don't have this problem again - you can use the maintenance plan wizard to
get started quickly. You should also check out the Books Online section on
"Backing Up and Restoring Databases".

Simon|||(Moti.Ba@.gmail.com) writes:
> I need to restore the Master DB in my SQL 2k server (with sp3). The
> problem is that i don't have SQL backups of this file I only have
> general backup of the entire c:\ drive i made using NTBackup. So i
> tried all I know and succesfully run the rebuildm utility. Now when I
> try to restore it from the general backup (not SQL backup) using
> "restore database master from gen_backup" i got error: "The file on
> device 'gen_backup' is not a valid Microsoft Tape Format backup set."
> RESTORE DATABASE is terminating abnormally.
> Any ideas how I can restore it?

You cannot use the RESTORE command in SQL Server to read something
from a NT Backup, as far as I know. You first need to restore the
master.mdf and master.ldf from backup with NT Backup.

However, it is far from certain that the files are usuable, because if
you backup database files with NT backup, there is no guarantee that they
are transactionally consistent. You can get all sorts of rubbish. That is,
if SQL Server was running when you ran NT backup. If SQL Server wasn't
running the backups should be OK.

There are somewhat better odds with master than other database, because
there is little update traffic in that database, and the database is small.

But nevertheless, before you actually try to use it as a master database,
just try to attach it as a regular user database first and run DBCC CHECKDB
on it.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

restore question

I use sql2000/sp3 in w2k/sp3,if i can
restore a database from a net device direct(not copy the
bak file to local disk)?I think you want to do something like this
RESTORE DATABASE FROM DISK = '\\ServerName\ShareName\FileName'
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"peng" <zhoupeng1971@.yahoo.com> wrote in message
news:022d01c35cbd$68fde570$a001280a@.phx.gbl...
> I use sql2000/sp3 in w2k/sp3,if i can
> restore a database from a net device direct(not copy the
> bak file to local disk)?|||Hi Peng,
Make sure that the SQL Server Startup service account has the permission to
access the network for this to work.
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

restore master to another box

Is it possible to Restore Master db from a backup to a box/ instance with
another name? Will it cause any problems?
--
sql2k sp3
TIA, ChrisRIt's possible, but kind of a risky proposition, and it really depends on what
you're trying to accomplish, why you're moving the database, other databases
involved, server and database configuration, etc. Check BOL "Restoring the
master Database from a Current Backup" and "Copying Databases to Other
Servers" for details.
You also might want to look at sqlservercentral.com - a couple of links I
found are
http://www.sqlservercentral.com/columnists/bknight/restoremaster.asp and
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=8387
Personally, I install SQL Server on the destination server and detatch /
attatch the databases from old to new server. There used to be a Knowlege
Base article Q245133 that had code to generate scripts to recreate the
logins, but I couldn't find it. Let me know if you need it and I'll mail the
code to you - mstuart_spamtastesgood@.gates.com - drop the _spamtastesgood, of
course :-)
Mike
"ChrisR" wrote:
> Is it possible to Restore Master db from a backup to a box/ instance with
> another name? Will it cause any problems?
> --
> sql2k sp3
> TIA, ChrisR
>
>|||For the moment Im only trying to do some Disaster Recovery planning.
"Mike" <mstuart_spamtastesgood@.gates.com> wrote in message
news:1BDC103A-A9E2-48F1-B93F-2C28C2118EA9@.microsoft.com...
> It's possible, but kind of a risky proposition, and it really depends on
what
> you're trying to accomplish, why you're moving the database, other
databases
> involved, server and database configuration, etc. Check BOL "Restoring
the
> master Database from a Current Backup" and "Copying Databases to Other
> Servers" for details.
> You also might want to look at sqlservercentral.com - a couple of links I
> found are
> http://www.sqlservercentral.com/columnists/bknight/restoremaster.asp and
>
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=
8387
> Personally, I install SQL Server on the destination server and detatch /
> attatch the databases from old to new server. There used to be a Knowlege
> Base article Q245133 that had code to generate scripts to recreate the
> logins, but I couldn't find it. Let me know if you need it and I'll mail
the
> code to you - mstuart_spamtastesgood@.gates.com - drop the _spamtastesgood,
of
> course :-)
> Mike
> "ChrisR" wrote:
> > Is it possible to Restore Master db from a backup to a box/ instance
with
> > another name? Will it cause any problems?
> >
> > --
> > sql2k sp3
> >
> > TIA, ChrisR
> >
> >
> >|||First and foremost, backup all your databases and test your backups! There's
nothing worse (professionally, anyway) than thinking you've got good backups
and you don't when you need them. Ask me how I know...
Read BOL on recovering master and practice recovering. You should be able
to copy your environment onto a second server for testing purposes by:
1 - installing SQL Server and service packs on another server,
2 - stop SQL Server on the test server,
3 - copy the system data and log files to another location,
4 - stop SQL Server on your source server and copy all data and log files
from source to test environment,
5 - then restart SQL Server.
You'll also need backups of the other system databases (model and msdb).
Probably won't need to worry about pubs or Northwind unless you've got some
custom code in those databases you want to keep.
You'll also want to script out the logins and passwords - see the KB article
I referred to earlier. Depending on the number of changes to your login
accounts, you might even want to script a job to run and recreate the file
auto-magically.
Assuming you're not running earlier that SQL 7.0, you won't need to worry
about scripting out CREATE and ALTER database statements to add space to your
data and log files (I'm probably getting the terminology wrong - it's been a
very long time since SQL 4.2 and 6.5!!), but you'll want to know where you
created your database data, log and backup files so you don't have to go
searching everywhere when the pressure is on and the boss is looking over
your shoulder.
Finally, document on paper in clear, readable text with pictures (if
necessary) how to go about restoring your environment. You might even want
to have a coworker 'monkey test' it for you (can a monkey read your
directions and successfully do whatever you wrote down).
It sounds like extreme overkill, but at 2:00 in the AM and the payroll
server is down and you're the person they come to, you will definitely look
like a hero if you can pull it off, and you may lose your job if you can't.
Good luck!
Mike
"ChrisR" wrote:
> For the moment Im only trying to do some Disaster Recovery planning.
>
> "Mike" <mstuart_spamtastesgood@.gates.com> wrote in message
> news:1BDC103A-A9E2-48F1-B93F-2C28C2118EA9@.microsoft.com...
> > It's possible, but kind of a risky proposition, and it really depends on
> what
> > you're trying to accomplish, why you're moving the database, other
> databases
> > involved, server and database configuration, etc. Check BOL "Restoring
> the
> > master Database from a Current Backup" and "Copying Databases to Other
> > Servers" for details.
> >
> > You also might want to look at sqlservercentral.com - a couple of links I
> > found are
> > http://www.sqlservercentral.com/columnists/bknight/restoremaster.asp and
> >
> http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=
> 8387
> >
> > Personally, I install SQL Server on the destination server and detatch /
> > attatch the databases from old to new server. There used to be a Knowlege
> > Base article Q245133 that had code to generate scripts to recreate the
> > logins, but I couldn't find it. Let me know if you need it and I'll mail
> the
> > code to you - mstuart_spamtastesgood@.gates.com - drop the _spamtastesgood,
> of
> > course :-)
> >
> > Mike
> >
> > "ChrisR" wrote:
> >
> > > Is it possible to Restore Master db from a backup to a box/ instance
> with
> > > another name? Will it cause any problems?
> > >
> > > --
> > > sql2k sp3
> > >
> > > TIA, ChrisR
> > >
> > >
> > >
>
>|||Mike I appreciate your response. But do all of your instructions hold true
for a box with another name? Also, your are referring to copying system db
files. Will that get me around the downfalls of restoring master to a box
with another name?
"Mike" <mstuart_spamtastesgood@.gates.com> wrote in message
news:4D09B9F2-B7D8-4824-9809-2188E93999BC@.microsoft.com...
> First and foremost, backup all your databases and test your backups!
There's
> nothing worse (professionally, anyway) than thinking you've got good
backups
> and you don't when you need them. Ask me how I know...
> Read BOL on recovering master and practice recovering. You should be able
> to copy your environment onto a second server for testing purposes by:
> 1 - installing SQL Server and service packs on another server,
> 2 - stop SQL Server on the test server,
> 3 - copy the system data and log files to another location,
> 4 - stop SQL Server on your source server and copy all data and log files
> from source to test environment,
> 5 - then restart SQL Server.
> You'll also need backups of the other system databases (model and msdb).
> Probably won't need to worry about pubs or Northwind unless you've got
some
> custom code in those databases you want to keep.
> You'll also want to script out the logins and passwords - see the KB
article
> I referred to earlier. Depending on the number of changes to your login
> accounts, you might even want to script a job to run and recreate the file
> auto-magically.
> Assuming you're not running earlier that SQL 7.0, you won't need to worry
> about scripting out CREATE and ALTER database statements to add space to
your
> data and log files (I'm probably getting the terminology wrong - it's been
a
> very long time since SQL 4.2 and 6.5!!), but you'll want to know where you
> created your database data, log and backup files so you don't have to go
> searching everywhere when the pressure is on and the boss is looking over
> your shoulder.
> Finally, document on paper in clear, readable text with pictures (if
> necessary) how to go about restoring your environment. You might even
want
> to have a coworker 'monkey test' it for you (can a monkey read your
> directions and successfully do whatever you wrote down).
> It sounds like extreme overkill, but at 2:00 in the AM and the payroll
> server is down and you're the person they come to, you will definitely
look
> like a hero if you can pull it off, and you may lose your job if you
can't.
> Good luck!
> Mike
>
> "ChrisR" wrote:
> > For the moment Im only trying to do some Disaster Recovery planning.
> >
> >
> > "Mike" <mstuart_spamtastesgood@.gates.com> wrote in message
> > news:1BDC103A-A9E2-48F1-B93F-2C28C2118EA9@.microsoft.com...
> > > It's possible, but kind of a risky proposition, and it really depends
on
> > what
> > > you're trying to accomplish, why you're moving the database, other
> > databases
> > > involved, server and database configuration, etc. Check BOL
"Restoring
> > the
> > > master Database from a Current Backup" and "Copying Databases to Other
> > > Servers" for details.
> > >
> > > You also might want to look at sqlservercentral.com - a couple of
links I
> > > found are
> > > http://www.sqlservercentral.com/columnists/bknight/restoremaster.asp
and
> > >
> >
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=
> > 8387
> > >
> > > Personally, I install SQL Server on the destination server and detatch
/
> > > attatch the databases from old to new server. There used to be a
Knowlege
> > > Base article Q245133 that had code to generate scripts to recreate the
> > > logins, but I couldn't find it. Let me know if you need it and I'll
mail
> > the
> > > code to you - mstuart_spamtastesgood@.gates.com - drop the
_spamtastesgood,
> > of
> > > course :-)
> > >
> > > Mike
> > >
> > > "ChrisR" wrote:
> > >
> > > > Is it possible to Restore Master db from a backup to a box/ instance
> > with
> > > > another name? Will it cause any problems?
> > > >
> > > > --
> > > > sql2k sp3
> > > >
> > > > TIA, ChrisR
> > > >
> > > >
> > > >
> >
> >
> >|||Chris,
I guess I don't understand what you mean by the other box. If I understand
correctly, you have your server (we'll say production for sake of arguement)
that you want to develop a DR plan for. You need to set up an environment to
develop and test a plan against. So, you need to go through the steps I
outlined earlier - including the system .mdf and .ldf files.
One thing I did forget (yikes!) was that the master database .mdf and .ldf
files that you copy from the production server will still think that the name
of the SQL Server instance is the name of the production server. Run
'sp_dropserver' and 'sp_addserver' (see BOL 'Renaming a Server') to change
the instance name to the name of the development / test server.
This isn't exactly a restore of 'master' in the strictest sense of the word.
Your master database contains all of the information that allows the SQL
Server engine to see all of the databases installed on that instance of SQL
Server. You're just copying the master database, and all of the other
databases from the production instance to the development / test instance of
SQL Server.
If my directions are still unclear, email me @.
mstuart_spamtastesgood@.gates.com (drop the 'spamtastesgood') with you number
and I'll try to clarify things for you.
Mike

restore Master question

sql2k sp3
Im doing some disaster recovery testing. I first did a
Full backup of Master and a User db. Then I modified some
data in the User db. So then I uninstalled/ reinstalled
SQL to simulate a total box failure. I then restored the
full backup of Master. Now the thing thats weird is that
the user db came back online without restoring it. It even
has the data changes that occured after the full backups.
How can it be? I thought I would have had to restore the
User db as well in order to preserve the data?
TIA, ChrisAfter you uninstalled SQL Server, did you delete your mdf and ldf files?|||Chris,
When you were trying "to simulate a total box failure"
you forgot do delete actual databases files.
Next time, try to delete all files in MSSQL\Data folder.
HTH
Igor
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:6ba801c40170$18fd60c0$a101280a@.phx.gbl...
> sql2k sp3
> Im doing some disaster recovery testing. I first did a
> Full backup of Master and a User db. Then I modified some
> data in the User db. So then I uninstalled/ reinstalled
> SQL to simulate a total box failure. I then restored the
> full backup of Master. Now the thing thats weird is that
> the user db came back online without restoring it. It even
> has the data changes that occured after the full backups.
> How can it be? I thought I would have had to restore the
> User db as well in order to preserve the data?
> TIA, Chris|||Doh!!! Someone else just pointed that out to me also.
>--Original Message--
>After you uninstalled SQL Server, did you delete your mdf
and ldf files?
>.
>

Restore Master Problem

We are in the process of upgrading our servers. We tried to Restore Master
Database from SQL 2000 SP3 on Win NT to a new test machine that has SQL 2000
SP3 on WIN 2003 Server SP1. The restore says its successful but the service
doesn't start after restoring. I am using local system account on both the
machines.
Also I have tried to restore Master from SQL 2000 SP3 on WIN 2000 Prof SP4
to the same machine (SQL 2000 sp3 on WIN 2003 server sp1) but ran into the
same problem.
I would really appreciate if you could give me some suggestions.on the original server do you have anything unusual like
- tempdb in ram
- max server memory greater than what is available on new server.
- additional tempdb on drive which does not exist etc . .
- what errors do you get in error log?
- did sql start with -m option?
- if all fails you may have to try -f option - see BOL for more details
HTH
"Pradip" wrote:
> We are in the process of upgrading our servers. We tried to Restore Master
> Database from SQL 2000 SP3 on Win NT to a new test machine that has SQL 2000
> SP3 on WIN 2003 Server SP1. The restore says its successful but the service
> doesn't start after restoring. I am using local system account on both the
> machines.
> Also I have tried to restore Master from SQL 2000 SP3 on WIN 2000 Prof SP4
> to the same machine (SQL 2000 sp3 on WIN 2003 server sp1) but ran into the
> same problem.
> I would really appreciate if you could give me some suggestions.|||1. Start SQL from the console ( command prompt) ie sqlservr.exe -m
2. Then do the restore from the database backup.
3. thern Ctrl-C the console, and restart SQL Serve..
What error messages are you getting?
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Pradip" <Pradip@.discussions.microsoft.com> wrote in message
news:C4E333AA-055D-4EDC-8271-9DF88AF68B9C@.microsoft.com...
> We are in the process of upgrading our servers. We tried to Restore Master
> Database from SQL 2000 SP3 on Win NT to a new test machine that has SQL
2000
> SP3 on WIN 2003 Server SP1. The restore says its successful but the
service
> doesn't start after restoring. I am using local system account on both the
> machines.
> Also I have tried to restore Master from SQL 2000 SP3 on WIN 2000 Prof SP4
> to the same machine (SQL 2000 sp3 on WIN 2003 server sp1) but ran into the
> same problem.
> I would really appreciate if you could give me some suggestions.

Restore Master Problem

We are in the process of upgrading our servers. We tried to Restore Master
Database from SQL 2000 SP3 on Win NT to a new test machine that has SQL 2000
SP3 on WIN 2003 Server SP1. The restore says its successful but the service
doesn't start after restoring. I am using local system account on both the
machines.
Also I have tried to restore Master from SQL 2000 SP3 on WIN 2000 Prof SP4
to the same machine (SQL 2000 sp3 on WIN 2003 server sp1) but ran into the
same problem.
I would really appreciate if you could give me some suggestions.on the original server do you have anything unusual like
- tempdb in ram
- max server memory greater than what is available on new server.
- additional tempdb on drive which does not exist etc . .
- what errors do you get in error log?
- did sql start with -m option?
- if all fails you may have to try -f option - see BOL for more details
HTH
"Pradip" wrote:

> We are in the process of upgrading our servers. We tried to Restore Master
> Database from SQL 2000 SP3 on Win NT to a new test machine that has SQL 20
00
> SP3 on WIN 2003 Server SP1. The restore says its successful but the servic
e
> doesn't start after restoring. I am using local system account on both the
> machines.
> Also I have tried to restore Master from SQL 2000 SP3 on WIN 2000 Prof SP4
> to the same machine (SQL 2000 sp3 on WIN 2003 server sp1) but ran into the
> same problem.
> I would really appreciate if you could give me some suggestions.|||1. Start SQL from the console ( command prompt) ie sqlservr.exe -m
2. Then do the restore from the database backup.
3. thern Ctrl-C the console, and restart SQL Serve..
What error messages are you getting?
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Pradip" <Pradip@.discussions.microsoft.com> wrote in message
news:C4E333AA-055D-4EDC-8271-9DF88AF68B9C@.microsoft.com...
> We are in the process of upgrading our servers. We tried to Restore Master
> Database from SQL 2000 SP3 on Win NT to a new test machine that has SQL
2000
> SP3 on WIN 2003 Server SP1. The restore says its successful but the
service
> doesn't start after restoring. I am using local system account on both the
> machines.
> Also I have tried to restore Master from SQL 2000 SP3 on WIN 2000 Prof SP4
> to the same machine (SQL 2000 sp3 on WIN 2003 server sp1) but ran into the
> same problem.
> I would really appreciate if you could give me some suggestions.

Restore Master Problem

We are in the process of upgrading our servers. We tried to Restore Master
Database from SQL 2000 SP3 on Win NT to a new test machine that has SQL 2000
SP3 on WIN 2003 Server SP1. The restore says its successful but the service
doesn't start after restoring. I am using local system account on both the
machines.
Also I have tried to restore Master from SQL 2000 SP3 on WIN 2000 Prof SP4
to the same machine (SQL 2000 sp3 on WIN 2003 server sp1) but ran into the
same problem.
I would really appreciate if you could give me some suggestions.
on the original server do you have anything unusual like
- tempdb in ram
- max server memory greater than what is available on new server.
- additional tempdb on drive which does not exist etc . .
- what errors do you get in error log?
- did sql start with -m option?
- if all fails you may have to try -f option - see BOL for more details
HTH
"Pradip" wrote:

> We are in the process of upgrading our servers. We tried to Restore Master
> Database from SQL 2000 SP3 on Win NT to a new test machine that has SQL 2000
> SP3 on WIN 2003 Server SP1. The restore says its successful but the service
> doesn't start after restoring. I am using local system account on both the
> machines.
> Also I have tried to restore Master from SQL 2000 SP3 on WIN 2000 Prof SP4
> to the same machine (SQL 2000 sp3 on WIN 2003 server sp1) but ran into the
> same problem.
> I would really appreciate if you could give me some suggestions.
|||1. Start SQL from the console ( command prompt) ie sqlservr.exe -m
2. Then do the restore from the database backup.
3. thern Ctrl-C the console, and restart SQL Serve..
What error messages are you getting?
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Pradip" <Pradip@.discussions.microsoft.com> wrote in message
news:C4E333AA-055D-4EDC-8271-9DF88AF68B9C@.microsoft.com...
> We are in the process of upgrading our servers. We tried to Restore Master
> Database from SQL 2000 SP3 on Win NT to a new test machine that has SQL
2000
> SP3 on WIN 2003 Server SP1. The restore says its successful but the
service
> doesn't start after restoring. I am using local system account on both the
> machines.
> Also I have tried to restore Master from SQL 2000 SP3 on WIN 2000 Prof SP4
> to the same machine (SQL 2000 sp3 on WIN 2003 server sp1) but ran into the
> same problem.
> I would really appreciate if you could give me some suggestions.

restore master database: no restart

Dear all,
I'm working on MS SQL 2000 SP3.
I'm trying to switch to a new server.
When I tried to restore the master database, the server wouldn't re-start.
so I tried another way, that is to restore user-databases and transfer the
users-accounts (DTS) but it seems that the users cannot connect to the new
server.(no permissions).
I prefere to have a success "restore master database".
what am I missing?
Thanks in advance
jouj
http://support.microsoft.com/default...n-us;Q314546#9 -- Move
Databases between computers running by sql server
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:82161742-1B9D-45C5-ABFF-BDF5E384148B@.microsoft.com...
> Dear all,
> I'm working on MS SQL 2000 SP3.
> I'm trying to switch to a new server.
> When I tried to restore the master database, the server wouldn't re-start.
> so I tried another way, that is to restore user-databases and transfer the
> users-accounts (DTS) but it seems that the users cannot connect to the new
> server.(no permissions).
> I prefere to have a success "restore master database".
> what am I missing?
> Thanks in advance
> jouj
>
|||Many thanks
jouj
"Uri Dimant" wrote:

> http://support.microsoft.com/default...n-us;Q314546#9 -- Move
> Databases between computers running by sql server
>
>
>
>
>
>
> "jouj" <jouj@.discussions.microsoft.com> wrote in message
> news:82161742-1B9D-45C5-ABFF-BDF5E384148B@.microsoft.com...
>
>

restore master database: no restart

Dear all,
I'm working on MS SQL 2000 SP3.
I'm trying to switch to a new server.
When I tried to restore the master database, the server wouldn't re-start.
so I tried another way, that is to restore user-databases and transfer the
users-accounts (DTS) but it seems that the users cannot connect to the new
server.(no permissions).
I prefere to have a success "restore master database".
what am I missing'
Thanks in advance
joujhttp://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546#9 -- Move
Databases between computers running by sql server
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:82161742-1B9D-45C5-ABFF-BDF5E384148B@.microsoft.com...
> Dear all,
> I'm working on MS SQL 2000 SP3.
> I'm trying to switch to a new server.
> When I tried to restore the master database, the server wouldn't re-start.
> so I tried another way, that is to restore user-databases and transfer the
> users-accounts (DTS) but it seems that the users cannot connect to the new
> server.(no permissions).
> I prefere to have a success "restore master database".
> what am I missing'
> Thanks in advance
> jouj
>|||Many thanks
jouj
"Uri Dimant" wrote:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546#9 -- Move
> Databases between computers running by sql server
>
>
>
>
>
>
> "jouj" <jouj@.discussions.microsoft.com> wrote in message
> news:82161742-1B9D-45C5-ABFF-BDF5E384148B@.microsoft.com...
> > Dear all,
> > I'm working on MS SQL 2000 SP3.
> > I'm trying to switch to a new server.
> > When I tried to restore the master database, the server wouldn't re-start.
> >
> > so I tried another way, that is to restore user-databases and transfer the
> > users-accounts (DTS) but it seems that the users cannot connect to the new
> > server.(no permissions).
> >
> > I prefere to have a success "restore master database".
> >
> > what am I missing'
> >
> > Thanks in advance
> > jouj
> >
> >
>
>

restore master database: no restart

Dear all,
I'm working on MS SQL 2000 SP3.
I'm trying to switch to a new server.
When I tried to restore the master database, the server wouldn't re-start.
so I tried another way, that is to restore user-databases and transfer the
users-accounts (DTS) but it seems that the users cannot connect to the new
server.(no permissions).
I prefere to have a success "restore master database".
what am I missing'
Thanks in advance
joujhttp://support.microsoft.com/defaul...en-us;Q314546#9 -- Move
Databases between computers running by sql server

"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:82161742-1B9D-45C5-ABFF-BDF5E384148B@.microsoft.com...
> Dear all,
> I'm working on MS SQL 2000 SP3.
> I'm trying to switch to a new server.
> When I tried to restore the master database, the server wouldn't re-start.
> so I tried another way, that is to restore user-databases and transfer the
> users-accounts (DTS) but it seems that the users cannot connect to the new
> server.(no permissions).
> I prefere to have a success "restore master database".
> what am I missing'
> Thanks in advance
> jouj
>|||Many thanks
jouj
"Uri Dimant" wrote:

> http://support.microsoft.com/defaul...en-us;Q314546#9 -- Mo
ve
> Databases between computers running by sql server
>
>
>
>
>
>
> "jouj" <jouj@.discussions.microsoft.com> wrote in message
> news:82161742-1B9D-45C5-ABFF-BDF5E384148B@.microsoft.com...
>
>