Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Agent Job Failed

Blade & Soul Eldoria Developer
[VIP] Member
Joined
Jul 30, 2012
Messages
1,224
Reaction score
160
declare @extraName varchar(5) = ' '
declare @date1 datetime='15/06/2015 17:43'
DECLARE @disk_shard varchar(max)
set @disk_shard =('C:\Backups\SHARD\'+@extraName+'-Shard_DB_'+@date1+'.bak')


BACKUP DATABASE SRO_VT_SHARD
TO DISK = @disk_shard
WITH FORMAT,
MEDIANAME = 'SRO_VT_SHARD',
NAME = 'SRO_VT_SHARD'
what i try to do is each backup the Sql agent will make will create separate bak with date and time

we speak here on Microsoft Sql Server 2012 enterprise​
 
Back
Top