Re: Restoring dump files

Dale E. Reed Jr. ( (no email) )
Fri, 23 Jan 1998 11:08:06 -0800

David Kerr wrote:
>
> Dale or anyone familiar with SQL
>
> I am trying to restore dump files to test my backups.
>
> I know you must start SQL in single user mode and I know how to do that.

You don't need to be in single user mode, but the database you
are restoring to must NOT have anyone using to it.

> Must I resize my master to the size it was so I can do the restore?
> Do I need to create a Emerald db?????

You have to have a database to restore the dump into. It has to
be atleast the same size as the backed up database was. It does
NOT have to be the same name.

Chapter 12 of the Administrator's companion details backup and
restores.

-- Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com