sqlserver数据库命令行备份与强制还原

::完整备份

declare @filename nvarchar(100) set @filename='e:\databack\data'+convert(char(8),getdate(),112)+'.bak'  print @filename BACKUP DATABASE [local] TO DISK = @filename WITH NOINIT , NOUNLOAD , NAME = N'aWkSQLBAK', NOSKIP, STATS = 10, NOFORMATdeclare @filename nvarchar(100) set @f