mohsenm66
یک شنبه 11 دی 1390, 16:50 عصر
میشه یک نفر در مورد گزینه های زیر یه توضیحی بده یعنی اینها چی هستند و چی کار می کنند.
BACKUP DATABASE <Database_Name, sysname, Database_Name>
TO DISK = N'<Backup_Path,,C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\><Database_Name, sysname, Database_Name>.bak'
WITH
NOFORMAT,
COMPRESSION,
NOINIT,
NAME = N'<Database_Name, sysname, Database_Name>-Full Database Backup',
SKIP,
STATS = 10;
GO
restore
USE master
GO
RESTORE DATABASE <Database_Name, sysname, Database_Name>
FROM DISK = N'<Backup_Path,,C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\><Database_Name, sysname, Database_Name>.bak'
WITH
FILE = 1,
NOUNLOAD,
REPLACE,
STATS = 10
GO
BACKUP DATABASE <Database_Name, sysname, Database_Name>
TO DISK = N'<Backup_Path,,C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\><Database_Name, sysname, Database_Name>.bak'
WITH
NOFORMAT,
COMPRESSION,
NOINIT,
NAME = N'<Database_Name, sysname, Database_Name>-Full Database Backup',
SKIP,
STATS = 10;
GO
restore
USE master
GO
RESTORE DATABASE <Database_Name, sysname, Database_Name>
FROM DISK = N'<Backup_Path,,C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\><Database_Name, sysname, Database_Name>.bak'
WITH
FILE = 1,
NOUNLOAD,
REPLACE,
STATS = 10
GO