Master Load Problem

Article View: bit.databases.mssql-l

Article #2084

Back to bit.databases.mssql-l Previous Next

#2084

From: Ken Macaulay
Date: Fri, 07 Apr 1995 00:00

19 lines
1243 bytes

I am trying to restore the master db from machine A on to machine B.  Both
are NT 3.5 Servers, SQL Server V 4.21a and the size on both is 25Mb.  I am
following the instructions on P.316 of the admin quide.

I added a dump device to sysdevices on Machine B and tested it by dumping
pubs.  It worked.  In single user mode, I tried loading the dump of the
master db from machine A and the load never finishes.

Any ideas?

Tempdb on Machine A is 42Mb split over 2 devices and on Machine B it is the
default 2Mb.  Could that be the problem?

Thanks,

Ken Macaulay
----------
Ken Macaulay, Finning Ltd, Caterpillar (TM) dealer, Vancouver, BC, Canada
ken@finning.wimsey.com

Technical Details

Message-ID: <9504071527.AA07724@wapiti.finning.ca>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6611,81343081053fbff0,start
X-Google-Attributes: gidf6611,public
From: Ken Macaulay <ken@WAPITI.FINNING.CA>
Subject: Master Load Problem
Date: 1995/04/07
Message-ID: <9504071527.AA07724@wapiti.finning.ca>
X-Deja-AN: 100102385
sender: Microsoft SQL Server Discussion List
x-sender: ken@wapiti.finning.ca
comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
content-type: text/plain; charset="us-ascii"
mime-version: 1.0
newsgroups: bit.databases.mssql-l
x-mailer: <PC Eudora Version 1.4b22>