Back, restore and Verification

Hi guys, i am new to Sql and seems to be having problems
verifiying my backup.Each time i backup, and want to test
my backup or view the contents,i do not see file in the
backup folder.Pls helpI do not know why this post is in the .Warehouse NG but
If you are backing up a database then you use the BACKUP DATABASE
command. For this you will specify a filename or devicename.
You can then after you know this use RESTORE VERIFYONLY on that file or
device.
How are you backing up your databases?
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org|||In article <2932901c465b7$60ec5ca0$a601280a@.phx.gbl>, Ayo wrote:
> Hi guys, i am new to Sql and seems to be having problems
> verifiying my backup.Each time i backup, and want to test
> my backup or view the contents,i do not see file in the
> backup folder.Pls help
>
The ONLY true way to test your backup is to RESTORE it.
Thanks Steve
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

Back, restore and Verification

Hi guys, i am new to Sql and seems to be having problems
verifiying my backup.Each time i backup, and want to test
my backup or view the contents,i do not see file in the
backup folder.Pls help
I do not know why this post is in the .Warehouse NG but
If you are backing up a database then you use the BACKUP DATABASE
command. For this you will specify a filename or devicename.
You can then after you know this use RESTORE VERIFYONLY on that file or
device.
How are you backing up your databases?
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
|||In article <2932901c465b7$60ec5ca0$a601280a@.phx.gbl>, Ayo wrote:
> Hi guys, i am new to Sql and seems to be having problems
> verifiying my backup.Each time i backup, and want to test
> my backup or view the contents,i do not see file in the
> backup folder.Pls help
>
The ONLY true way to test your backup is to RESTORE it.
Thanks Steve
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org