Prev: Speed, subselect vs group by
Next: database mirroring question
From: SQL on 25 Jun 2010 17:22
I have created some databases no init from SQL Server 2005 maintenance
plan. I want to do Init backups and override the backups I made in the
past with no init. If I do through SQL Agent code, will this take care
of the problem or some other way?
From: Erland Sommarskog on 25 Jun 2010 18:01
SQL (texassqldba(a)gmail.com) writes:
> I have created some databases no init from SQL Server 2005 maintenance
> plan. I want to do Init backups and override the backups I made in the
> past with no init. If I do through SQL Agent code, will this take care
> of the problem or some other way?

I'm not sure what your question is. If you say

BACKUP DATABASE db TO DISK = 'some_file.bak' WITH INIT

everything that was in that file will be overwritten.



--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: Speed, subselect vs group by
Next: database mirroring question