BACKUP DATABASE [demo]
TO DISK = N’C:\Program Files\demo.bak
WITH NOFORMAT, NOINIT
NAME = N’demo-Fill Database Backup’,
SKIP, NOREWIND, NOUNLOAD, STATS=10
GO
BACKUP DATABASE [demo]
TO DISK = N’C:\Program Files\demo.bak
WITH INIT
GO
BACKUP DATABASE [demo]
TO DISK = N’C:\Program Files\demodf.bak
WITH INIT, DIFFERENTIAL
GO
BACKUP log [demo]
TO DISK = N’C:\Program Files\demolb.bak
WITH INIT
GO
=======================================================
=======================================================
- Database User
- New
- Uzupełniamy USER NAME
- Login name - wybieramy […]
- okno „Select Logon” -> Object Types
- okno „Select Object Types” -> Browse -> wybieramy użytkownika -> OK -> OK
USE [demo]
GO
CREATE USER [adas] FOR LOGIN [ADAM]
GO
=======================================================
=======================================================
- Logon
- New
- Login name: ADAM
- „SQL Server authentication”
- uzupełnić 2 razy password
USE [master]
GO
CREATE LOGIN [ADAM]
WITH PASSWORD = N’123456’,
DEFAULT_DATABASE=[master],
CHECK_EXPIRATION=ON,
CHECK_POLICY=ON
GO
=======================================================
=======================================================
USE [demo]
GO
EXP sp_addrolemember N’db_owner’, N’EWCIA’
GO
- Serwer -> Security -> Logins
- wybrać użytkownika
- properties
- server roles
- checbox „sysadmin”
EXEC master..sp_addsrvrolemember
@loginame = N’C208_20\EWA’,
@rolename = N’sysadmin’
GO
=======================================================
=======================================================
BACKUP log [demo]
TO DISK = N’C:\dane\demolb.bak’
WITH INIT
GO
BACKUP database [demo]
TO DISK = N’C:\dane\demo1.bak’,
DISK = N’C:\dane\demo2.bak’,
=======================================================
=======================================================
USE [master]
GO
CREATE LOGIN [C208\EWA] FROM WINDOWS
WITH DEFAULT_DATABASE [master]
GO
=======================================================
=======================================================
- Serwer -> Databases -> ”wybrana baza” -> Security -> Users
- prawym i „New User”
- Username: EWCIA
- Login name - wybieramy […]
- Browse
- [C208_20\EWA] -> OK -> OK
USE [demo]
GO
CREATE USER [EWCIA] FOR LOGIN [C208_20\EWA]
GO
=======================================================
=======================================================
- Serwer -> Databases -> ”wybrana baza” -> Security -> Users
-rozwin
- EWCIA
- properties
use [demo]
GO
GRANT SELECT ON SCHEMA::[dbo] DO [EWCIA]
GO