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

awe enabled but still has dynamic memory set

The main reason for these questions is each time I view the propery page for this instance I get and error generated in the event log => 1 Configuration option \'show advanced options\' changed from 1 to 1 <= and even though it is a warning it wasn't there before the awe memory was changed.

The dedicated s2k machine has 8GB of memory. AWE has been enabled, and max server memory set to 5120 (this is a clustered instance and the second machine only has 6 Gb. More is on order). When viewing properties for the instance it shows memory as being dynamic with max server memory = 5120.

Should the memory be set to something other than dynamically managed?

I confirmed the settings via sp_configure and AWE is enabled and memory is 5120... And perf mon shows target memory as around 5120 so it looks like things are set correctly. But the dynamically configure sql memory is still selected.

So is that an issue?

Thanks for any input.

MikeMike,

Set the memory to fixed when you use AWE. This way SQL won't have extend the memory whenever it needs it. It will save you some overhead.|||I was plan on making the change but was looking for some doco from Bill 1st.

Thanks for the response!!

Mike

Auto-viewing of report after selection of parameter(s)

Is there a way to automatically display the report after the last parameter
has been selected? i.e. without having to click on the "View Report" button?
Also, is it possible to change the position of that button?
--
Thank you,
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.comOn Dec 9, 8:30 am, "Alain Quesnel" <alainsanss...@.logiquel.com> wrote:
> Is there a way to automatically display the report after the last parameter
> has been selected? i.e. without having to click on the "View Report" button?
> Also, is it possible to change the position of that button?
> --
> Thank you,
> Alain Quesnel
> alainsanss...@.logiquel.com
> www.logiquel.com
In terms of the automatically viewing part, the only way to
accommodate this is to set defaults for the parameters. You could set
the autorefresh functionality in addition, that would basically do a
postback at whatever frequency you set and refresh the data (via:
Layout tab >> Report drop-down >> Report Properties... >> General tab
>> Autorefresh). In terms of the View Report button, there is very
limited things that can be done to the Report Manager via CSS. These
links might be helpful.
http://msdn2.microsoft.com/en-us/library/ms345247.aspx
http://weblogs.asp.net/jgalloway/archive/2006/12/12/reporting-services-add-a-logo-to-the-report-manager.aspx
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks for the info.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:bcc3af94-43aa-4bf1-946b-2e91219e3e15@.w40g2000hsb.googlegroups.com...
> On Dec 9, 8:30 am, "Alain Quesnel" <alainsanss...@.logiquel.com> wrote:
>> Is there a way to automatically display the report after the last
>> parameter
>> has been selected? i.e. without having to click on the "View Report"
>> button?
>> Also, is it possible to change the position of that button?
>> --
>> Thank you,
>> Alain Quesnel
>> alainsanss...@.logiquel.com
>> www.logiquel.com
>
> In terms of the automatically viewing part, the only way to
> accommodate this is to set defaults for the parameters. You could set
> the autorefresh functionality in addition, that would basically do a
> postback at whatever frequency you set and refresh the data (via:
> Layout tab >> Report drop-down >> Report Properties... >> General tab
>> Autorefresh). In terms of the View Report button, there is very
> limited things that can be done to the Report Manager via CSS. These
> links might be helpful.
> http://msdn2.microsoft.com/en-us/library/ms345247.aspx
> http://weblogs.asp.net/jgalloway/archive/2006/12/12/reporting-services-add-a-logo-to-the-report-manager.aspx
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant|||On Dec 10, 9:00 am, "Alain Quesnel" <alainsanss...@.logiquel.com>
wrote:
> Thanks for the info.
> Alain Quesnel
> alainsanss...@.logiquel.com
> www.logiquel.com
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:bcc3af94-43aa-4bf1-946b-2e91219e3e15@.w40g2000hsb.googlegroups.com...
> > On Dec 9, 8:30 am, "Alain Quesnel" <alainsanss...@.logiquel.com> wrote:
> >> Is there a way to automatically display the report after the last
> >> parameter
> >> has been selected? i.e. without having to click on the "View Report"
> >> button?
> >> Also, is it possible to change the position of that button?
> >> --
> >> Thank you,
> >> Alain Quesnel
> >> alainsanss...@.logiquel.com
> >>www.logiquel.com
> > In terms of the automatically viewing part, the only way to
> > accommodate this is to set defaults for the parameters. You could set
> > the autorefresh functionality in addition, that would basically do a
> > postback at whatever frequency you set and refresh the data (via:
> > Layout tab >> Report drop-down >> Report Properties... >> General tab
> >> Autorefresh). In terms of the View Report button, there is very
> > limited things that can be done to the Report Manager via CSS. These
> > links might be helpful.
> >http://msdn2.microsoft.com/en-us/library/ms345247.aspx
> >http://weblogs.asp.net/jgalloway/archive/2006/12/12/reporting-service...
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant