��÷����Ấ�Ѿ Data

[ThePKBoy]

��÷����Ấ�Ѿ Data

(�ѹ���ͺ͡��͹����ѧ�����㨡Ѻ SQL2000 �ФѺ ���м��ͧ�Ѻ SQL2005 �Ѻ)

�١��蹹�����价��� Job ����¤Ѻ ��§�����仡�˹�������� �����Ấ�Ѿ�͹�˹�Ѻ

Quote:
--trunkating
BACKUP LOG rxjhgame WITH NO_LOG

USE [rxjhgame]
GO
--shrinking
DBCC SHRINKDATABASE(N'rxjhgame')

Declare @dateBackup Varchar(100)
Set @dateBackup = 'C:\Backups\rxjhgame_' +
Convert(varchar, datepart( year , Getdate() )) + '-'+
Convert( varchar , datepart( month , Getdate() ) ) + '-'+
Convert( varchar, datepart( day , Getdate() ) ) + '.bak'
--saving backup with name and date.
BACKUP DATABASE [rxjhgame] TO DISK = @dateBackup WITH NOFORMAT, NOINIT, NAME = N'rxjhgame-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO

Set @dateBackup = 'C:\Backups\rxjhgame_' +

����Ấ�Ѿ�͡�ҷ�� C:\Backups �ФѺ

�ͧ�٤Ѻ ���Դ�������͹ ���Ф���觤�����ҧ�ѹ�������

�� 2 ���駹�������¹ rxjhgame �� rxjhaccount ������Ҩ��繵�ͧ Backup ��� 2 �ѹ���