RESTORE DATABASE [Triceps]
FROM  DISK = N'C:\TricepsData\Triceps.bak' WITH  FILE = 1,  
MOVE N'Triceps' TO N'C:\TricepsData\triceps.mdf',  MOVE N'Triceps_log' TO N'C:\TricepsData\triceps.ldf',  NOUNLOAD,  REPLACE, STATS = 10
GO

CREATE LOGIN [Triceps] WITH PASSWORD=N'Triceps', CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
EXEC sys.sp_addsrvrolemember @loginame = N'Triceps', @rolename = N'sysadmin'
GO

USE [Triceps]
update site set [database] = DB_NAME() + '@' + @@SERVERNAME

DROP USER [Triceps]
GO

CREATE USER [Triceps] FOR LOGIN [Triceps]
GO

EXEC sp_addrolemember N'db_owner', N'Triceps'
GO

EXEC master..sp_addsrvrolemember @loginame = N'Triceps', @rolename = N'sysadmin'
GO