T-sql restore db SqlServer

RIpristinare un db tramite t-sql



RESTORE FILELISTONLY
FROM DISK = 'D:\wvoce_sin2010\dbwvoce.bak'
GO


----Make Database to single user Mode



ALTER DATABASE db-name
SET SINGLE_USER WITH
ROLLBACK IMMEDIATE

----Restore Database
RESTORE DATABASE db-name
FROM DISK = 'D:\file.bak'
WITH REPLACE,MOVE 'filem-df' TO 'D:\file.bak',
MOVE 'file-log' TO 'C:\file.ldf'

ALTER DATABASE pentaho SET MULTI_USER
GO

T-sql dare permessi a user

Per dare i permessi ad un user esistente sul nostro motore db Sql Server, tramite t-sql questi comanda da dare:

USE db_name;
CREATE USER user_name FOR LOGIN login_name;
EXEC sp_addrolemember 'db_datareader', 'username'
EXEC sp_addrolemember 'db_datawriter', 'username'
EXEC sp_addrolemember 'db_owner', 'username'