Create & write
into a bat file (Take Database Back Up)
Write the following code on your Sql Server Management
Studio & Execute it. So, that it will create a bat file which consists of
all back up of a database.
|
Declare @Name varchar(50)
Declare @Path varchar(max)
Declare @FileName varchar(250)
Declare @FileData varchar(250)
set @path = 'C:\SQLBackup\'
select @FileData = Convert(Varchar(250), GetDate(), 112)
Declare db_cursor Cursor for
select name from Master.dbo.sysdatabases
Where name not in ('master','model','msdb','tempdb')
open db_cursor Fetch Next From db_cursor into @name
while @@fetch_status = 0
Begin
set @FileName = @Path + @name + '_' + @FileData + '.BAK'
Backup Database @name To Disk = @FileName
Fetch next From db_cursor into @name
End
close db_cursor
deallocate db_cursor
|
Run & Test the code.
No comments:
Post a Comment