If You have a Windows 2008 server (not R2)
with the backup wizard, you can not make a backup to a network share,
the solution is easy, install backup command line tools and you can do a backup to a network share at this way:
Wbadmin start backup -backupTarget:\\”server”\”share” -include:C: -vssFull -quiet
replacing “server” and “share” with the appropiate.
A very useful script to generate a backup file in SQL server by day of week and not have to create a maintenance plan.
declare @a as nvarchar(200) set @a=N'\\backupserver\backups\ddbb' + DATENAME(WEEKDAY, GETDATE()) + '.tbk' BACKUP DATABASE [bbdd] TO DISK =@a WITH NOFORMAT, INIT, NAME ='copia', SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10 GO
By continuing to use the site, you agree to the use of cookies. more information
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.