Tag Archives: backup

Backup Windows 2008 (not R2) to a Network Share

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.

Facebooktwittergoogle_plusredditpinterestlinkedinmail

Read More ...

SQL custom backup

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
Facebooktwittergoogle_plusredditpinterestlinkedinmail

Read More ...