Create Database/table/backup and users

-------------------------
-- Create your database
-------------------------
CREATE DATABASE Persons
-------------------------
-- Create your table
-------------------------
USE Persons
CREATE TABLE persons
(
P_Id INT,
LastName VARCHAR(255),
FirstName VARCHAR(255),
Address VARCHAR(255),
City VARCHAR(255)
)
-------------------------
-- Create your back up
-------------------------
SELECT *
INTO persons_backup
FROM Persons
GO
-------------------------
-- Create Users, you will need to look into this bit yourself... here is an example
-------------------------
USE Persons
CREATE LOGIN NewAdminName WITH PASSWORD = 'ABCD'
GO
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'NewAdminName')
BEGIN
    CREATE USER [NewAdminName] FOR LOGIN [NewAdminName]
    EXEC sp_addrolemember N'db_owner', N'NewAdminName'
END;
GO
-- my source for this quick example was
-- http://stackoverflow.com/questions/1601186/sql-server-script-to-create-a-new-user