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

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

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

--
BrianHi 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...
> 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:
>> --
>> Brian|||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|||Thanks, that is what I am looking for.
--
Brian
"Tibor Karaszi" 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
>