command to backup database to null device for testing purpose? tha

command to backup database to null device for testing purpose? thaHi Brian
I am not at all sure how backing up to a NULL device will test anything?
You may want to use a small database or filegroup to do your tests. You will
not know that the backup has really worked unless you restore it!!!
John
"Brian Brian" wrote:

> --
> Brian|||Try AgileInfoSoftware DataStudio (http://www.agileinfollc.com) for moving
database to another database.
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:6C516CB3-B902-4A1D-97D4-AA9EA5384A60@.microsoft.com...[vbcol=seagreen]
> Hi Brian
> I am not at all sure how backing up to a NULL device will test anything?
> You may want to use a small database or filegroup to do your tests. You
> will
> not know that the backup has really worked unless you restore it!!!
> John
> "Brian Brian" wrote:
>|||Assuming you only want to test the syntax of your backup commands:
BACKUP DATABASE pubs TO DISK = 'nul'
The data is written to the "bit bucket".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Brian Brian" <BrianBrian@.discussions.microsoft.com> wrote in message
news:C6F64561-F058-425D-9B82-C7FBD7D9B6B1@.microsoft.com...
> --
> Brian