restoring a server

restoring a server

Post by scott chapi » Wed, 10 Jan 2001 00:16:20



When you are saying you saved the files, did you do a datbase backup or an
NT backup.  If a datbase backup jsut restore the database and log.  If only
an NT backup you can try to attach the database to the server.

Remarks
The AttachDB method is used when a change to the location of operating
system (OS) files implementing the database must be made visible to an
instance of SQL Server.

The DataFiles argument can specify up to 16 OS files. Each file should be
specified by complete name, including the path. At least one file in the
list of those specified must be the PRIMARY data file. Operating system
files implementing storage for the transaction log can be specified.

For more information about setting multistring parameters, see Using SQL-DMO
Multistrings.

The AttachDB method fails if more than 16 OS files are specified. When using
SQL-DMO to move a database implemented on more than 16 files, use the
CreateForAttach property of a Database object.

Making a database visible to an instance of SQL Server by using the AttachDB
method requires appropriate permissions. The SQL Server login used for
SQLServer object connection must be a member of the system-defined role
sysadmin.

 
 
 

restoring a server

Post by JL » Wed, 10 Jan 2001 05:20:06


Thanks,

it works great.

Jerry


Quote:> When you are saying you saved the files, did you do a datbase backup or an
> NT backup.  If a datbase backup jsut restore the database and log.  If
only
> an NT backup you can try to attach the database to the server.

> Remarks
> The AttachDB method is used when a change to the location of operating
> system (OS) files implementing the database must be made visible to an
> instance of SQL Server.

> The DataFiles argument can specify up to 16 OS files. Each file should be
> specified by complete name, including the path. At least one file in the
> list of those specified must be the PRIMARY data file. Operating system
> files implementing storage for the transaction log can be specified.

> For more information about setting multistring parameters, see Using
SQL-DMO
> Multistrings.

> The AttachDB method fails if more than 16 OS files are specified. When
using
> SQL-DMO to move a database implemented on more than 16 files, use the
> CreateForAttach property of a Database object.

> Making a database visible to an instance of SQL Server by using the
AttachDB
> method requires appropriate permissions. The SQL Server login used for
> SQLServer object connection must be a member of the system-defined role
> sysadmin.


 
 
 

1. Restore to Server X from a backup copied from Server Y

Is it possible to take a backup created via the Enterprise Manager SQL
Server  backup process on a server Y, copy the BAK file to another
unrelated server (X)  and restore  that backup on Server X via its  
Enterprise Manager?

If it is, can some kind soul suggest how?

cheers

David

2. Script to create logins

3. How to restore SQL server 6.5 backup to SQL server 2000

4. Please Help!!!

5. Restoring SQL Server 7.0 database to SQL Server 2000 Environment Question

6. Proc Cache filling up?

7. Backup and Restore from Server A to Server B

8. SQL Help!

9. Restore SQL Server 6.5 database to SQL Server 7.0

10. problems restoring SQL server to a server with different hardware

11. Restore SQL Server 2000 database

12. backup restore SQL-SERVER with ARC-SERVE