RS First Dynamics NAV Blog


...from NAV 3.60 to NAV 2013
Home Blogs | Home | Login | Contact | My Profile | RSS | About | Cerca

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 ISTANCEFor a named instance, the sqlcmd command must specify the -S<ComputerName>\<InstanceName> option. PROCEDURE:C:\> sqlc 
Leggi tutto il post...
Categoria: Sql Server ALL
martedì, 12 mag 2009 Ore. 12.29

Scrivi un commento


Non è possibile inviare commenti a questo Blog

Commenti

Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003