RS First Dynamics NAV Blog


...from NAV 3.60 to NAV 2013
Archivio Posts
Anno 2015

Anno 2014

Anno 2013

Anno 2012

Anno 2011

Anno 2010

Anno 2009

Anno 2008

Anno 2007

RESTORE MASTER DB FROM FILE

Example
The following example restores the master database on the default server instance.
The example assumes that the server instance is already running in single-user mode.

The example starts sqlcmd and executes a RESTORE DATABASE statement that restores
a full database backup of master from a disk device: Z:\SQLServerBackups\master.bak.

Note for NAMED ISTANCE
For a named instance, the sqlcmd command must specify the -S<ComputerName>\<InstanceName> option.

PROCEDURE:
C:\> sqlcmd

RESTORE DATABASE master FROM DISK = 'Z:\SQLServerBackups\master.bak' WITH REPLACE;
GO 

Categoria: Sql Server ALL
martedì, 12 mag 2009 Ore. 12.29

Messaggi collegati


Statistiche
  • Views Home Page: 465.439
  • Views Posts: 882.358
  • Views Gallerie: 0
  • n° Posts: 343
  • n° Commenti: 0
Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003