Monday, March 28, 2016

Database Backup

Go
RESTORE DATABASE ERA
FROM DISK = 'D:\Rubol\ERA.bak'
WITH MOVE 'ermsadminsql1' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.SQLSERVER2012\MSSQL\DATA\ERA.mdf',

MOVE 'ermsadminsql1_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.SQLSERVER2012\MSSQL\DATA\ERA.ldf'



AZ-204

 42,43,44,45,46,54,55,56,57,70, 71, 80, 98,99,100,108, 104, 105, 106, 192, 193, 194, 209, 206, 207, 210, 325,326,327,329,345,346,364,373,351...