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 ...

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.

Close