best option when master db is not available


i want setup database to new server machine. have backup copy of database files (data & log), lost master database existing server.

 

so have 2 ways of having database

 

1. restore backup

2. attach data files.

 

which 1 best option, when start afresh on new machine new master database.

either method should work. prefer restore.

 

if file location (folder) different, may need add move option restore.

 

refer books online, topic: restore



SQL Server  >  SQL Server Database Engine



Comments

Popular posts from this blog

BIT Version

Admin Permissions

Problems installing SQL Server 2014 - There was a failure to calculate the applicability of setting LICENSEPATH.