Backing up SQL databases

I am backing up three databases being used for a
inventory program. I have scheduled these databases to
be backed up at night using enterprise manager. If I
needed to restore any of these databases would I have to
restore all three? I do not back up transaction logs
because they do not need to restore to a specific point
(they could restore back to the previous night when the
databases were being backed up). Also do I have to
backup the other default databases that came with the SQl
2000 server in order to restore the three databases
specific to the inventory program?
> If I
> needed to restore any of these databases would I have to
> restore all three?
Technically, each database can be restored independently. However, your
inventory application might need the data in all three databases to be in
sync. It is probably safest to restore all three unless you know enough
about the app to be certain restoring a single database isn't a problem.

> Also do I have to
> backup the other default databases that came with the SQl
> 2000 server in order to restore the three databases
> specific to the inventory program?
You should backup the master and msdb system databases as part of your
backup plan. These system databases only need to be restored if they are
lost or corrupted. You don't need to restore them before your inventory
databases.
Hope this helps.
Dan Guzman
SQL Server MVP
"Andy" <anonymous@.discussions.microsoft.com> wrote in message
news:451701c4800c$cb3dbbc0$a301280a@.phx.gbl...
> I am backing up three databases being used for a
> inventory program. I have scheduled these databases to
> be backed up at night using enterprise manager. If I
> needed to restore any of these databases would I have to
> restore all three? I do not back up transaction logs
> because they do not need to restore to a specific point
> (they could restore back to the previous night when the
> databases were being backed up). Also do I have to
> backup the other default databases that came with the SQl
> 2000 server in order to restore the three databases
> specific to the inventory program?
|||OK thanks. Most of that makes sense to me. However the
last part you said referring to the default
databases, "you don't need to restore them before the
inventory databases." Do you mean if I had to restore
the inventory databases I would not have to restore these
default databases? Also if these default databases
became corrupt like you said would they not be able to be
replaced without having a backup of them. I mean if they
are default databases do they ever change? Are they
(default databases) unique to my particular SQL server
installation and are needed inclusively to run my
inventory app?
Lastly if I backup these three databases at night at
separate times wihtin a couple of hours of each when no
one is accessing the inventory program at all would they
still be in sync if restored all at once. If not could I
schedule all three databases to be backed up at the same
time to the server hard drive(I later back the database
backup files to tape).
[vbcol=seagreen]
>--Original Message--
to
>Technically, each database can be restored
independently. However, your
>inventory application might need the data in all three
databases to be in
>sync. It is probably safest to restore all three unless
you know enough
>about the app to be certain restoring a single database
isn't a problem.[vbcol=seagreen]
SQl
>You should backup the master and msdb system databases
as part of your
>backup plan. These system databases only need to be
restored if they are
>lost or corrupted. You don't need to restore them
before your inventory
>databases.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"Andy" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:451701c4800c$cb3dbbc0$a301280a@.phx.gbl...
to[vbcol=seagreen]
SQl
>
>.
>
|||Hi,
Answers to your queries:-
1. Do you mean if I had to restore the inventory databases I would not
have to restore these
default databases?
No need to restore the default (system) databases while restoring Inventory
databases. System database keeps tract of database, logins, backups , jobs
... information. But you need to backup and keep these datases in a safe
location, which will be helpful during a crash or corruption.
2. I mean if they are default databases do they ever change?
Yes, they will change. Especially MASTER and MSDB database.
Master database will change while you add a new database, add a new login,
change parameters ...
MSDB database will change when you add a new Job (task), operator, backup,
restore ....
SO it is necessory to restore these backup during problem sitation.
3. Are they (default databases) unique to my particular SQL server
installation and are needed inclusively to run my inventory app?
Uniqueness will be there. Because those databases store the Server name,
logins, system informations...
4. If not could I schedule all three databases to be backed up at the same
time to the server hard drive?
You could backup these databases simulateneosly or one by one. One by one
is also fine, Because changes to these database will happen only during the
above mentioned time (answer to my second question)
Thanks
Hari
MCDBA
"Andy" <anonymous@.discussions.microsoft.com> wrote in message
news:4b1f01c4801a$65fef810$a401280a@.phx.gbl...[vbcol=seagreen]
> OK thanks. Most of that makes sense to me. However the
> last part you said referring to the default
> databases, "you don't need to restore them before the
> inventory databases." Do you mean if I had to restore
> the inventory databases I would not have to restore these
> default databases? Also if these default databases
> became corrupt like you said would they not be able to be
> replaced without having a backup of them. I mean if they
> are default databases do they ever change? Are they
> (default databases) unique to my particular SQL server
> installation and are needed inclusively to run my
> inventory app?
> Lastly if I backup these three databases at night at
> separate times wihtin a couple of hours of each when no
> one is accessing the inventory program at all would they
> still be in sync if restored all at once. If not could I
> schedule all three databases to be backed up at the same
> time to the server hard drive(I later back the database
> backup files to tape).
> to
> independently. However, your
> databases to be in
> you know enough
> isn't a problem.
> SQl
> as part of your
> restored if they are
> before your inventory
> message
> to
> SQl
|||>> Lastly if I backup these three databases at night at[vbcol=seagreen]
If there is no activity at night, you should not have a consistency problem.
However, if there's activity at night, and if a user adds/modifies data to
database A and B, but not to C, you might hit a consistency issue since the
backups of each database will end at different times. In this case, you
will need to backup the transaction logs and restore to a point-in-time for
all 3 databases to guarantee consistency (or at least close to it, since
there's still a chance a trx is committed on database A, but not yet on B
and C at that time).
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"Andy" <anonymous@.discussions.microsoft.com> wrote in message
news:4b1f01c4801a$65fef810$a401280a@.phx.gbl...
> OK thanks. Most of that makes sense to me. However the
> last part you said referring to the default
> databases, "you don't need to restore them before the
> inventory databases." Do you mean if I had to restore
> the inventory databases I would not have to restore these
> default databases? Also if these default databases
> became corrupt like you said would they not be able to be
> replaced without having a backup of them. I mean if they
> are default databases do they ever change? Are they
> (default databases) unique to my particular SQL server
> installation and are needed inclusively to run my
> inventory app?
> Lastly if I backup these three databases at night at
> separate times wihtin a couple of hours of each when no
> one is accessing the inventory program at all would they
> still be in sync if restored all at once. If not could I
> schedule all three databases to be backed up at the same
> time to the server hard drive(I later back the database
> backup files to tape).
>
|||Can I also schedule backup of nondefault databases(our
inventory program) simultaneously?
>--Original Message--
>Hi,
>Answers to your queries:-
>1. Do you mean if I had to restore the inventory
databases I would not
>have to restore these
>default databases?
>No need to restore the default (system) databases while
restoring Inventory
>databases. System database keeps tract of database,
logins, backups , jobs
>... information. But you need to backup and keep these
datases in a safe
>location, which will be helpful during a crash or
corruption.
>2. I mean if they are default databases do they ever
change?
>Yes, they will change. Especially MASTER and MSDB
database.
>Master database will change while you add a new database,
add a new login,
>change parameters ...
>MSDB database will change when you add a new Job (task),
operator, backup,
>restore ....
>SO it is necessory to restore these backup during problem
sitation.
>3. Are they (default databases) unique to my particular
SQL server
>installation and are needed inclusively to run my
inventory app?
> Uniqueness will be there. Because those databases
store the Server name,
>logins, system informations...
>
>4. If not could I schedule all three databases to be
backed up at the same
>time to the server hard drive?
> You could backup these databases simulateneosly or one
by one. One by one
>is also fine, Because changes to these database will
happen only during the
> above mentioned time (answer to my second question)
>Thanks
>Hari
>MCDBA
>
>"Andy" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:4b1f01c4801a$65fef810$a401280a@.phx.gbl...
these[vbcol=seagreen]
be[vbcol=seagreen]
they[vbcol=seagreen]
I[vbcol=seagreen]
unless[vbcol=seagreen]
to[vbcol=seagreen]
point[vbcol=seagreen]
the
>
>.
>

Backing up SQL databases

I am backing up three databases being used for a
inventory program. I have scheduled these databases to
be backed up at night using enterprise manager. If I
needed to restore any of these databases would I have to
restore all three? I do not back up transaction logs
because they do not need to restore to a specific point
(they could restore back to the previous night when the
databases were being backed up). Also do I have to
backup the other default databases that came with the SQl
2000 server in order to restore the three databases
specific to the inventory program?> If I
> needed to restore any of these databases would I have to
> restore all three?
Technically, each database can be restored independently. However, your
inventory application might need the data in all three databases to be in
sync. It is probably safest to restore all three unless you know enough
about the app to be certain restoring a single database isn't a problem.

> Also do I have to
> backup the other default databases that came with the SQl
> 2000 server in order to restore the three databases
> specific to the inventory program?
You should backup the master and msdb system databases as part of your
backup plan. These system databases only need to be restored if they are
lost or corrupted. You don't need to restore them before your inventory
databases.
Hope this helps.
Dan Guzman
SQL Server MVP
"Andy" <anonymous@.discussions.microsoft.com> wrote in message
news:451701c4800c$cb3dbbc0$a301280a@.phx.gbl...
> I am backing up three databases being used for a
> inventory program. I have scheduled these databases to
> be backed up at night using enterprise manager. If I
> needed to restore any of these databases would I have to
> restore all three? I do not back up transaction logs
> because they do not need to restore to a specific point
> (they could restore back to the previous night when the
> databases were being backed up). Also do I have to
> backup the other default databases that came with the SQl
> 2000 server in order to restore the three databases
> specific to the inventory program?|||OK thanks. Most of that makes sense to me. However the
last part you said referring to the default
databases, "you don't need to restore them before the
inventory databases." Do you mean if I had to restore
the inventory databases I would not have to restore these
default databases? Also if these default databases
became corrupt like you said would they not be able to be
replaced without having a backup of them. I mean if they
are default databases do they ever change? Are they
(default databases) unique to my particular SQL server
installation and are needed inclusively to run my
inventory app?
Lastly if I backup these three databases at night at
separate times wihtin a couple of hours of each when no
one is accessing the inventory program at all would they
still be in sync if restored all at once. If not could I
schedule all three databases to be backed up at the same
time to the server hard drive(I later back the database
backup files to tape).

>--Original Message--
to[vbcol=seagreen]
>Technically, each database can be restored
independently. However, your
>inventory application might need the data in all three
databases to be in
>sync. It is probably safest to restore all three unless
you know enough
>about the app to be certain restoring a single database
isn't a problem.
>
SQl[vbcol=seagreen]
>You should backup the master and msdb system databases
as part of your
>backup plan. These system databases only need to be
restored if they are
>lost or corrupted. You don't need to restore them
before your inventory
>databases.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"Andy" <anonymous@.discussions.microsoft.com> wrote in
message
>news:451701c4800c$cb3dbbc0$a301280a@.phx.gbl...
to[vbcol=seagreen]
SQl[vbcol=seagreen]
>
>.
>|||Hi,
Answers to your queries:-
1. Do you mean if I had to restore the inventory databases I would not
have to restore these
default databases?
No need to restore the default (system) databases while restoring Inventory
databases. System database keeps tract of database, logins, backups , jobs
... information. But you need to backup and keep these datases in a safe
location, which will be helpful during a crash or corruption.
2. I mean if they are default databases do they ever change?
Yes, they will change. Especially MASTER and MSDB database.
Master database will change while you add a new database, add a new login,
change parameters ...
MSDB database will change when you add a new Job (task), operator, backup,
restore ....
SO it is necessory to restore these backup during problem sitation.
3. Are they (default databases) unique to my particular SQL server
installation and are needed inclusively to run my inventory app?
Uniqueness will be there. Because those databases store the Server name,
logins, system informations...
4. If not could I schedule all three databases to be backed up at the same
time to the server hard drive?
You could backup these databases simulateneosly or one by one. One by one
is also fine, Because changes to these database will happen only during the
above mentioned time (answer to my second question)
Thanks
Hari
MCDBA
"Andy" <anonymous@.discussions.microsoft.com> wrote in message
news:4b1f01c4801a$65fef810$a401280a@.phx.gbl...[vbcol=seagreen]
> OK thanks. Most of that makes sense to me. However the
> last part you said referring to the default
> databases, "you don't need to restore them before the
> inventory databases." Do you mean if I had to restore
> the inventory databases I would not have to restore these
> default databases? Also if these default databases
> became corrupt like you said would they not be able to be
> replaced without having a backup of them. I mean if they
> are default databases do they ever change? Are they
> (default databases) unique to my particular SQL server
> installation and are needed inclusively to run my
> inventory app?
> Lastly if I backup these three databases at night at
> separate times wihtin a couple of hours of each when no
> one is accessing the inventory program at all would they
> still be in sync if restored all at once. If not could I
> schedule all three databases to be backed up at the same
> time to the server hard drive(I later back the database
> backup files to tape).
>
> to
> independently. However, your
> databases to be in
> you know enough
> isn't a problem.
> SQl
> as part of your
> restored if they are
> before your inventory
> message
> to
> SQl|||>> Lastly if I backup these three databases at night at
If there is no activity at night, you should not have a consistency problem.
However, if there's activity at night, and if a user adds/modifies data to
database A and B, but not to C, you might hit a consistency issue since the
backups of each database will end at different times. In this case, you
will need to backup the transaction logs and restore to a point-in-time for
all 3 databases to guarantee consistency (or at least close to it, since
there's still a chance a trx is committed on database A, but not yet on B
and C at that time).
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"Andy" <anonymous@.discussions.microsoft.com> wrote in message
news:4b1f01c4801a$65fef810$a401280a@.phx.gbl...[vbcol=seagreen]
> OK thanks. Most of that makes sense to me. However the
> last part you said referring to the default
> databases, "you don't need to restore them before the
> inventory databases." Do you mean if I had to restore
> the inventory databases I would not have to restore these
> default databases? Also if these default databases
> became corrupt like you said would they not be able to be
> replaced without having a backup of them. I mean if they
> are default databases do they ever change? Are they
> (default databases) unique to my particular SQL server
> installation and are needed inclusively to run my
> inventory app?
> Lastly if I backup these three databases at night at
> separate times wihtin a couple of hours of each when no
> one is accessing the inventory program at all would they
> still be in sync if restored all at once. If not could I
> schedule all three databases to be backed up at the same
> time to the server hard drive(I later back the database
> backup files to tape).
>|||Can I also schedule backup of nondefault databases(our
inventory program) simultaneously?
>--Original Message--
>Hi,
>Answers to your queries:-
>1. Do you mean if I had to restore the inventory
databases I would not
>have to restore these
>default databases?
>No need to restore the default (system) databases while
restoring Inventory
>databases. System database keeps tract of database,
logins, backups , jobs
>... information. But you need to backup and keep these
datases in a safe
>location, which will be helpful during a crash or
corruption.
>2. I mean if they are default databases do they ever
change?
>Yes, they will change. Especially MASTER and MSDB
database.
>Master database will change while you add a new database,
add a new login,
>change parameters ...
>MSDB database will change when you add a new Job (task),
operator, backup,
>restore ....
>SO it is necessory to restore these backup during problem
sitation.
>3. Are they (default databases) unique to my particular
SQL server
>installation and are needed inclusively to run my
inventory app?
> Uniqueness will be there. Because those databases
store the Server name,
>logins, system informations...
>
>4. If not could I schedule all three databases to be
backed up at the same
>time to the server hard drive?
> You could backup these databases simulateneosly or one
by one. One by one
>is also fine, Because changes to these database will
happen only during the
> above mentioned time (answer to my second question)
>Thanks
>Hari
>MCDBA
>
>"Andy" <anonymous@.discussions.microsoft.com> wrote in
message
>news:4b1f01c4801a$65fef810$a401280a@.phx.gbl...
these[vbcol=seagreen]
be[vbcol=seagreen]
they[vbcol=seagreen]
I[vbcol=seagreen]
unless[vbcol=seagreen]
to[vbcol=seagreen]
point[vbcol=seagreen]
the[vbcol=seagreen]
>
>.
>

Backing Up databases with Enterprise Manager

Please forgive my ignorance - I'm completely new to MSSQL.

Our office bought a set of Laserfiche licenses and had to also buy MSSQL to handle the database end of things. Part of my job is to make sure everything gets backed up. I want to use Enterprise Manager to back up the databases which seems straightforward enough - even though I've never done it.

Our Network Admin has installed a temporary USB drive to hold our back-ups until a more permanent form of media can be installed. He is using drive compression to maximize the space available. The server sees it as Drive F:

I created a folder on F: to contain my MSSQL Back-ups. Then I opened Enterprise Manager and clicked on SQL Server Group, which contains two databases:

(local) (Windows NT)

and

CYWD_IMAGE/LASERFICHE (Windows NT)

My understanding is that they both have to be backed up.

I clicked on the first one, then selected the Database Maintenence Plan Wizard from the 'Tools' menu. I stepped through the process (choosing 'all databases') until I got to the point where I could specify the back-up directory. I was able to browse right to the folder I created and choose it. I could then finish the process normally. The problem is that when I selected the second database (CYWD_IMAGE/LASERFICHE) and launched the wizard I was unable to browse to my folder. I could choose the F: Drive but no folder showed up under it. Oddly, it would not even show me my D: partition (just thought I'd mention that in case it is somehow relevent).

I don't see any difference in the properties tabs between these two databases. The obvious difference is the name, and that one says (local) and the other does not.

I really don't want to choose to dump the back-up into the root of F:

Can anyone tell me what I'm doing wrong?

Thanks in advance.

MacIf the plan created by your first Wizard backs up "all databases', why do you need to create a second backup plan?|||If the plan created by your first Wizard backs up "all databases', why do you need to create a second backup plan?

There are two servers under the SQL Servers Group, and each contain multiple databases. As far as I can tell the back-up plan will not span both servers, therefore the need for two plans.

It turns out the second server and it's databases are not currently in use so I lucked out. I am still curious why the second server and it's databases behaved this way, though.

Follow-up question. How to I review the plan I created to make modifications? If I pull up the Maintnence Planner there is no option to review exisiting plans.|||If the two servers are on different machines, then they will have different drives. You created a folder on the F drive of one machine, but not the other.

To review or edit the maitenance plans, open up the job they created in the SQL Server Agent tab.|||If the two servers are on different machines, then they will have different drives. You created a folder on the F drive of one machine, but not the other.

To review or edit the maitenance plans, open up the job they created in the SQL Server Agent tab.

Thanks - the servers both appear to be the same machine. Our other servers do not have external (or network) drives that would evaluate to F: - but it was a good thing to check for!

I was able to locate the SQL Server Agent Tab, I appreciate the information!

I'm sure I'll have other questions later, but I'm set for now.|||Be careful not to fill up your harddrive|||Be careful not to fill up your harddrive

Will do - Supposedly I'm going to have to burn off older jobs to dvd to avoid that.

Doesn't sounds like I'll be getting any additional storage drives any time soon, does it? ;)

backing up

hello,
I canot get my databases to automatically backup twice a day. I have tried
through enterprise manager a couple of different ways. Can someone tell me
how to do this?
Thanks!
Eric
What errors are you seing? Is SQLAgent running ?
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Eric Throckmorton" <eric@.contractorsunlimited.com> wrote in message
news:%23%23jAasU3EHA.3388@.TK2MSFTNGP15.phx.gbl...
> hello,
> I canot get my databases to automatically backup twice a day. I have
> tried through enterprise manager a couple of different ways. Can someone
> tell me how to do this?
> Thanks!
> Eric
>
|||Eric,
Have you tried backing it up manually from Query Analyzer, does that work?
Have you tried backing up PUBS database or another database?
If you could include the error message that you are getting, that would be
helpful.
Thanks,
Fargham

back up without ent manager.

As per earlier post my ent manager has stopped working and I have not been
ale to re-install it. I want to make full back ups of the database but have
never done this without ent manager.
Can I just copy the files in the data folder? or is there a better way.
JohnYou can easily use a batch file and OSQL
osql -S. -E -Q"BACKUP DATABASE Pubs TO DISK= 'd:\PubDeleteMePlease.bak'"
You could write something in VB and use the DMO library.
I would first though, and I haven't read you previous posts that you refer
to, I don't think, investigate why my EM is not working.
--
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
"John Pether" <john@.john.com> wrote in message
news:#onkIILXDHA.384@.TK2MSFTNGP12.phx.gbl...
> As per earlier post my ent manager has stopped working and I have not been
> ale to re-install it. I want to make full back ups of the database but
have
> never done this without ent manager.
> Can I just copy the files in the data folder? or is there a better way.
> John
>|||Thanks for the help guys:) I have been trying to find out the reason ent
manager stopped working lal day...but its holding me up and I may be better
off just re-installing the whole thing(is on my dev machine)
The problem is the mmc snap in will not open, i get the following error:
MMC cannot open the file c:\program Files\Microsoft SQL
Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC
This may be because the file does not exist, is not an MMC console, or was
created by a later version of MMC. This may also be because you do not have
sufficient access rights to the file.
I tried as local administrator and get the following error:
c:\program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise
Manager.MSC
The service cannot be started, either because it is disabled or because it
has no enabled devices associated with it.
If anyone has any suggestions I would appreciate the help other wise i'm
just gonna re-install the whole thing, I have already re-installed client
tools without success..
John
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:eQ9wXtLXDHA.1900@.TK2MSFTNGP10.phx.gbl...
> You can easily use a batch file and OSQL
> osql -S. -E -Q"BACKUP DATABASE Pubs TO DISK= 'd:\PubDeleteMePlease.bak'"
> You could write something in VB and use the DMO library.
> I would first though, and I haven't read you previous posts that you refer
> to, I don't think, investigate why my EM is not working.
>
>
> --
> --
> 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
>
> "John Pether" <john@.john.com> wrote in message
> news:#onkIILXDHA.384@.TK2MSFTNGP12.phx.gbl...
> > As per earlier post my ent manager has stopped working and I have not
been
> > ale to re-install it. I want to make full back ups of the database but
> have
> > never done this without ent manager.
> >
> > Can I just copy the files in the data folder? or is there a better way.
> >
> > John
> >
> >
>|||In addition to what the others have said, you might want to look at =using WITH INIT
as in BACKUP DATABASE pubs TO DISK=3D'c:\pubs_fullbackup.bak' WITH INIT
This initializes (clears) the backup file each time.
If you don't do this...
Lets say that pubs is 15MB.
The first time that you issue a backup your backup file will be 15MB. =The second time that you issue your statement the backup file will =contain both backups -- 30MB. The third time that you issue your backup =statement it will be 45MB, the fourth time, 60MB....(plus any increase =in the size of the database along the way).
If you use WITH INIT your backup file will only contain one database =backup.
-- Keith, SQL Server MVP
"John Pether" <john@.john.com> wrote in message =news:%23onkIILXDHA.384@.TK2MSFTNGP12.phx.gbl...
> As per earlier post my ent manager has stopped working and I have not =been
> ale to re-install it. I want to make full back ups of the database but =have
> never done this without ent manager.
> > Can I just copy the files in the data folder? or is there a better =way.
> > John
> >sql

Back Button : Going back to parent report from the child report in Report Manager screen

Hi,
In my report manager screen, i want to place the back button option by which user can navigate to the parent report?
For example, I am viewing the orders screen(parent report), in that screen i am clicking the orderid column, it navigates to another report(child report), from which i want to go back to parent report..
I am not using the reportviewer control...
i am using only the report manager....
is it possible?
how do we achieve this?

thanks in advance

Have you figured a way to do this? I am trying to do the same thing.

Thanks,

|||It is possible using Jump To Report functionality

Back Button : Going back to parent report from the child report in Report Manager screen

Hi,
In my report manager screen, i want to place the back button option by which user can navigate to the parent report?
For example, I am viewing the orders screen(parent report), in that screen i am clicking the orderid column, it navigates to another report(child report), from which i want to go back to parent report..
I am not using the reportviewer control...
i am using only the report manager....
is it possible?
how do we achieve this?

thanks in advance

Have you figured a way to do this? I am trying to do the same thing.

Thanks,

|||It is possible using Jump To Report functionality

What is Query Analyzer's replacement in SQL Server 2005?

Both Query Analyzer and Enterprise Manager are gone from SQL Server 2005. In their place is a single tool, SQL Server Management Studio. This tool has most of the features of its predecessors, but with an upgraded UI and a lot of improved functionality. I think that most DBAs will find it to be a good upgrade. If you'd like more information on some of the new features with this tool, read my article on SQL Server Management Studio client tool enhancements.
http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1146801,00.htmlPAE allows the OS to use more than 4GB of memory. AWE allows the
application to use more than 4GB.
Andrew J. Kelly SQL MVP
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:7D318157-43B8-49AD-9DF7-F38F6ABEEA03@.microsoft.com...
> guys,
> what is the difference between AWE and PAE?
|||for SQL server, shd i enable PAE or AWE? Can both be enabled at the same time?
"Andrew J. Kelly" wrote:

> PAE allows the OS to use more than 4GB of memory. AWE allows the
> application to use more than 4GB.
> --
> Andrew J. Kelly SQL MVP
>
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:7D318157-43B8-49AD-9DF7-F38F6ABEEA03@.microsoft.com...
>
>
|||AWE is a SQL Server setting (sp_configure) and PAE is an operating system setting (BOOT.INI). If you
want SQL Server to utilize > 4GB memory, you need both settings.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:82A723DF-8EEA-431B-8669-79146E1DCA1D@.microsoft.com...[vbcol=seagreen]
> for SQL server, shd i enable PAE or AWE? Can both be enabled at the same time?
> "Andrew J. Kelly" wrote:
|||in that case...in a server with 5G of ram
should i put the /AWE /PAE swith in the same line in the boot.ini?
For the OS, i can see under system mgmt that 5G is enabled. How abt for sql?
how do i check it has 5G? Also, is there any significant on it? The
performance shd be better i suppose
Thank you
"Tibor Karaszi" wrote:

> AWE is a SQL Server setting (sp_configure) and PAE is an operating system setting (BOOT.INI). If you
> want SQL Server to utilize > 4GB memory, you need both settings.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:82A723DF-8EEA-431B-8669-79146E1DCA1D@.microsoft.com...
>
>
|||boot.ini should have something like this:
multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windo ws Server 2003,
Enterprise" /fastdetect /pae /3gb
(The /3gb switch is not necessary, but for a box with 5gb of RAM it'll
provide a little more to the apps, i.e. SQL Server.)
To check the amount of physical RAM the OS is seeing you can just check
the Performance tab in task manager.
To turn on AWE memory for SQL Server you use the sp_configure stored
proc (in Query Analyzer for example):
exec sp_configure 'awe enabled', 1
reconfigure
go
Then you have to restart the SQL instance as the AWE setting only takes
affect on server startup. Also, when SQL Server is using AWE memory, it
cannot use dynamic memory management. It *will not swap pages out of
memory *if another app requests memory and the OS doesn't have enough to
satisfy the request (unlike the SQL dynamic memory manager). So you
should specify a "max server memory" amount with sp_configure. For
example, on your 5GB box, if you wanted to allocate 4GB to SQL and the
remaining 1GB to the OS & other apps, you would do this in QA:
exec sp_configure "max server memory", 5120
reconfigure
go
All this is documented in SQL BOL:
http://msdn.microsoft.com/library/de...onfig_3stg.asp
To see how much memory SQL Server is currently consuming you can open
the System Monitor (perfmon.exe) and add the counter: SQLServer:Memory
Manager | Total Server Memory (KB). SQL BOL has a lot of good stuff on
AWE & memory management.
HTH
*mike hodgson*
/ mallesons stephen jaques/
blog: http://sqlnerd.blogspot.com
rupart wrote:
[vbcol=seagreen]
>in that case...in a server with 5G of ram
>should i put the /AWE /PAE swith in the same line in the boot.ini?
>For the OS, i can see under system mgmt that 5G is enabled. How abt for sql?
>how do i check it has 5G? Also, is there any significant on it? The
>performance shd be better i suppose
>Thank you
>"Tibor Karaszi" wrote:
>
|||does /3g means the system will allocate 3g for system and the rest for
sql(that is after enabling thru AWE, rite?)?
yeah, good link...thank you
"Mike Hodgson" wrote:

> boot.ini should have something like this:
> multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windo ws Server 2003,
> Enterprise" /fastdetect /pae /3gb
> (The /3gb switch is not necessary, but for a box with 5gb of RAM it'll
> provide a little more to the apps, i.e. SQL Server.)
> To check the amount of physical RAM the OS is seeing you can just check
> the Performance tab in task manager.
> To turn on AWE memory for SQL Server you use the sp_configure stored
> proc (in Query Analyzer for example):
> exec sp_configure 'awe enabled', 1
> reconfigure
> go
> Then you have to restart the SQL instance as the AWE setting only takes
> affect on server startup. Also, when SQL Server is using AWE memory, it
> cannot use dynamic memory management. It *will not swap pages out of
> memory *if another app requests memory and the OS doesn't have enough to
> satisfy the request (unlike the SQL dynamic memory manager). So you
> should specify a "max server memory" amount with sp_configure. For
> example, on your 5GB box, if you wanted to allocate 4GB to SQL and the
> remaining 1GB to the OS & other apps, you would do this in QA:
> exec sp_configure "max server memory", 5120
> reconfigure
> go
> All this is documented in SQL BOL:
> http://msdn.microsoft.com/library/de...onfig_3stg.asp
> To see how much memory SQL Server is currently consuming you can open
> the System Monitor (perfmon.exe) and add the counter: SQLServer:Memory
> Manager | Total Server Memory (KB). SQL BOL has a lot of good stuff on
> AWE & memory management.
> HTH
> --
> *mike hodgson*
> / mallesons stephen jaques/
> blog: http://sqlnerd.blogspot.com
>
> rupart wrote:
>
|||The other way around. 3 GB for the application and 1 GB for the system.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:4944B057-1DC7-4638-BB88-9040FDCC9B9F@.microsoft.com...[vbcol=seagreen]
> does /3g means the system will allocate 3g for system and the rest for
> sql(that is after enabling thru AWE, rite?)?
> yeah, good link...thank you
> "Mike Hodgson" wrote:
|||Oops - slight typo in my "max server memory" statement. To set a max
server memory of 4GB you would run:
exec sp_configure "max server memory", 4096
reconfigure
go
The 5120 figure I included in my previous post would try to set it at
5GB (not 4GB).
*mike hodgson*
blog: http://sqlnerd.blogspot.com
Mike Hodgson wrote:
[vbcol=seagreen]
> boot.ini should have something like this:
> multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windo ws Server 2003,
> Enterprise" /fastdetect /pae /3gb
> (The /3gb switch is not necessary, but for a box with 5gb of RAM it'll
> provide a little more to the apps, i.e. SQL Server.)
> To check the amount of physical RAM the OS is seeing you can just
> check the Performance tab in task manager.
> To turn on AWE memory for SQL Server you use the sp_configure stored
> proc (in Query Analyzer for example):
> exec sp_configure 'awe enabled', 1
> reconfigure
> go
> Then you have to restart the SQL instance as the AWE setting only
> takes affect on server startup. Also, when SQL Server is using AWE
> memory, it cannot use dynamic memory management. It *will not swap
> pages out of memory *if another app requests memory and the OS doesn't
> have enough to satisfy the request (unlike the SQL dynamic memory
> manager). So you should specify a "max server memory" amount with
> sp_configure. For example, on your 5GB box, if you wanted to allocate
> 4GB to SQL and the remaining 1GB to the OS & other apps, you would do
> this in QA:
> exec sp_configure "max server memory", 5120
> reconfigure
> go
> All this is documented in SQL BOL:
> http://msdn.microsoft.com/library/de...nfig_3stg..asp
> To see how much memory SQL Server is currently consuming you can open
> the System Monitor (perfmon.exe) and add the counter: SQLServer:Memory
> Manager | Total Server Memory (KB). SQL BOL has a lot of good stuff
> on AWE & memory management.
> HTH
> --
> *mike hodgson*
> / mallesons stephen jaques/
> blog: http://sqlnerd.blogspot.com
>
> rupart wrote:

AWE got 0, said DBCC MEMORYSTATUS...

I have done these steps to config and enable AWE. But, DBCC MEMORYSTATUS
still show AWE=0 on everywhere, liked Memory Manager, Memory node Id =0, etc
.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
-- restart the sql
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'min server memory', 1024
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
The box is a:
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)
Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
That's a WinServer 2003 64-bit.
Physical_memory_in_bytes virtual_memory_in_bytes bpool_committed
bpool_commit_target bpool_visible
-- -- --
-- --
8584736768 2147352576 5280 199912
199912
Am I doing it right? How to verify my stuff are consuming memory from the
AWE?
Thanks.You can use Performance on Windows and verify Memory Manager, Total Server
Memory.
Check your SQL Server log when the instance was started, there must be a
'Address Windowing Extensions enabled' message. If AWE was not succesfully
started there must be a related error message.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"light_wt" wrote:

>
> I have done these steps to config and enable AWE. But, DBCC MEMORYSTATUS
> still show AWE=0 on everywhere, liked Memory Manager, Memory node Id =0, e
tc.
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> -- restart the sql
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'min server memory', 1024
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> The box is a:
> Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)
> Mar 23 2007 16:28:52
> Copyright (c) 1988-2005 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
> That's a WinServer 2003 64-bit.
> Physical_memory_in_bytes virtual_memory_in_bytes bpool_committed
> bpool_commit_target bpool_visible
> -- -- --
> -- --
> 8584736768 2147352576 5280 199912
> 199912
> Am I doing it right? How to verify my stuff are consuming memory from the
> AWE?
> Thanks.
>|||Did you add your SQL Server service account to "Lock pages in memory" list
before performing this action?
Otherwise, it would not let you set AWE enable.
How to: Enable the Lock Pages in Memory Option (Windows):
http://msdn2.microsoft.com/en-us/library/ms190730.aspx
Ekrem ?nsoy
"light_wt" <lightwt@.discussions.microsoft.com> wrote in message
news:2217E528-6E89-4C83-987C-FAA270A30FE3@.microsoft.com...
>
> I have done these steps to config and enable AWE. But, DBCC MEMORYSTATUS
> still show AWE=0 on everywhere, liked Memory Manager, Memory node Id =0,
> etc.
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> -- restart the sql
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'min server memory', 1024
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> The box is a:
> Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)
> Mar 23 2007 16:28:52
> Copyright (c) 1988-2005 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
> That's a WinServer 2003 64-bit.
> Physical_memory_in_bytes virtual_memory_in_bytes bpool_committed
> bpool_commit_target bpool_visible
> -- -- --
> -- --
> 8584736768 2147352576 5280 199912
> 199912
> Am I doing it right? How to verify my stuff are consuming memory from the
> AWE?
> Thanks.
>|||Also, there are AWE specific counters under SQLServer:Buffer Manager. Take a
look at these AWE counters to see if there are any AWE-related memory
activities.
Linchi
"light_wt" wrote:

>
> I have done these steps to config and enable AWE. But, DBCC MEMORYSTATUS
> still show AWE=0 on everywhere, liked Memory Manager, Memory node Id =0, e
tc.
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> -- restart the sql
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'min server memory', 1024
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> The box is a:
> Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)
> Mar 23 2007 16:28:52
> Copyright (c) 1988-2005 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
> That's a WinServer 2003 64-bit.
> Physical_memory_in_bytes virtual_memory_in_bytes bpool_committed
> bpool_commit_target bpool_visible
> -- -- --
> -- --
> 8584736768 2147352576 5280 199912
> 199912
> Am I doing it right? How to verify my stuff are consuming memory from the
> AWE?
> Thanks.
>|||thanks everyone for your ideas.
i've look at the SQL Server Log, after the instances started, the AWE is
enable.
i've check the userid who can do Lock Memory and is the same perosn who own
the Job.
in perfmon, I have added all AWE-related counters in SQLServer:Buffer
Manager
and changed the vertical counter to 5.
nothing happen. AWE got 0.
Am I missing something?
thanks.

AWE got 0, said DBCC MEMORYSTATUS...

I have done these steps to config and enable AWE. But, DBCC MEMORYSTATUS
still show AWE=0 on everywhere, liked Memory Manager, Memory node Id =0, etc.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
-- restart the sql
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'min server memory', 1024
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
The box is a:
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)
Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
That's a WinServer 2003 64-bit.
Physical_memory_in_bytes virtual_memory_in_bytes bpool_committed
bpool_commit_target bpool_visible
-- -- --
-- --
8584736768 2147352576 5280 199912
199912
Am I doing it right? How to verify my stuff are consuming memory from the
AWE?
Thanks.
You can use Performance on Windows and verify Memory Manager, Total Server
Memory.
Check your SQL Server log when the instance was started, there must be a
'Address Windowing Extensions enabled' message. If AWE was not succesfully
started there must be a related error message.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"light_wt" wrote:

>
> I have done these steps to config and enable AWE. But, DBCC MEMORYSTATUS
> still show AWE=0 on everywhere, liked Memory Manager, Memory node Id =0, etc.
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> -- restart the sql
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'min server memory', 1024
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> The box is a:
> Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)
> Mar 23 2007 16:28:52
> Copyright (c) 1988-2005 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
> That's a WinServer 2003 64-bit.
> Physical_memory_in_bytes virtual_memory_in_bytes bpool_committed
> bpool_commit_target bpool_visible
> -- -- --
> -- --
> 8584736768 2147352576 5280 199912
> 199912
> Am I doing it right? How to verify my stuff are consuming memory from the
> AWE?
> Thanks.
>
|||Did you add your SQL Server service account to "Lock pages in memory" list
before performing this action?
Otherwise, it would not let you set AWE enable.
How to: Enable the Lock Pages in Memory Option (Windows):
http://msdn2.microsoft.com/en-us/library/ms190730.aspx
Ekrem ?nsoy
"light_wt" <lightwt@.discussions.microsoft.com> wrote in message
news:2217E528-6E89-4C83-987C-FAA270A30FE3@.microsoft.com...
>
> I have done these steps to config and enable AWE. But, DBCC MEMORYSTATUS
> still show AWE=0 on everywhere, liked Memory Manager, Memory node Id =0,
> etc.
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> -- restart the sql
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'min server memory', 1024
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> The box is a:
> Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)
> Mar 23 2007 16:28:52
> Copyright (c) 1988-2005 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
> That's a WinServer 2003 64-bit.
> Physical_memory_in_bytes virtual_memory_in_bytes bpool_committed
> bpool_commit_target bpool_visible
> -- -- --
> -- --
> 8584736768 2147352576 5280 199912
> 199912
> Am I doing it right? How to verify my stuff are consuming memory from the
> AWE?
> Thanks.
>
|||Also, there are AWE specific counters under SQLServer:Buffer Manager. Take a
look at these AWE counters to see if there are any AWE-related memory
activities.
Linchi
"light_wt" wrote:

>
> I have done these steps to config and enable AWE. But, DBCC MEMORYSTATUS
> still show AWE=0 on everywhere, liked Memory Manager, Memory node Id =0, etc.
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> -- restart the sql
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'min server memory', 1024
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> The box is a:
> Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)
> Mar 23 2007 16:28:52
> Copyright (c) 1988-2005 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
> That's a WinServer 2003 64-bit.
> Physical_memory_in_bytes virtual_memory_in_bytes bpool_committed
> bpool_commit_target bpool_visible
> -- -- --
> -- --
> 8584736768 2147352576 5280 199912
> 199912
> Am I doing it right? How to verify my stuff are consuming memory from the
> AWE?
> Thanks.
>
|||thanks everyone for your ideas.
i've look at the SQL Server Log, after the instances started, the AWE is
enable.
i've check the userid who can do Lock Memory and is the same perosn who own
the Job.
in perfmon, I have added all AWE-related counters in SQLServer:Buffer
Manager
and changed the vertical counter to 5.
nothing happen. AWE got 0.
Am I missing something?
thanks.

AWE got 0, said DBCC MEMORYSTATUS...

:)
I have done these steps to config and enable AWE. But, DBCC MEMORYSTATUS
still show AWE=0 on everywhere, liked Memory Manager, Memory node Id =0, etc.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
-- restart the sql
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'min server memory', 1024
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
The box is a:
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)
Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
That's a WinServer 2003 64-bit.
Physical_memory_in_bytes virtual_memory_in_bytes bpool_committed
bpool_commit_target bpool_visible
-- -- --
-- --
8584736768 2147352576 5280 199912
199912
Am I doing it right? How to verify my stuff are consuming memory from the
AWE?
Thanks.You can use Performance on Windows and verify Memory Manager, Total Server
Memory.
Check your SQL Server log when the instance was started, there must be a
'Address Windowing Extensions enabled' message. If AWE was not succesfully
started there must be a related error message.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"light_wt" wrote:
> :)
> I have done these steps to config and enable AWE. But, DBCC MEMORYSTATUS
> still show AWE=0 on everywhere, liked Memory Manager, Memory node Id =0, etc.
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> -- restart the sql
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'min server memory', 1024
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> The box is a:
> Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)
> Mar 23 2007 16:28:52
> Copyright (c) 1988-2005 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
> That's a WinServer 2003 64-bit.
> Physical_memory_in_bytes virtual_memory_in_bytes bpool_committed
> bpool_commit_target bpool_visible
> -- -- --
> -- --
> 8584736768 2147352576 5280 199912
> 199912
> Am I doing it right? How to verify my stuff are consuming memory from the
> AWE?
> Thanks.
>|||Did you add your SQL Server service account to "Lock pages in memory" list
before performing this action?
Otherwise, it would not let you set AWE enable.
How to: Enable the Lock Pages in Memory Option (Windows):
http://msdn2.microsoft.com/en-us/library/ms190730.aspx
--
Ekrem Ã?nsoy
"light_wt" <lightwt@.discussions.microsoft.com> wrote in message
news:2217E528-6E89-4C83-987C-FAA270A30FE3@.microsoft.com...
> :)
> I have done these steps to config and enable AWE. But, DBCC MEMORYSTATUS
> still show AWE=0 on everywhere, liked Memory Manager, Memory node Id =0,
> etc.
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> -- restart the sql
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'min server memory', 1024
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> The box is a:
> Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)
> Mar 23 2007 16:28:52
> Copyright (c) 1988-2005 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
> That's a WinServer 2003 64-bit.
> Physical_memory_in_bytes virtual_memory_in_bytes bpool_committed
> bpool_commit_target bpool_visible
> -- -- --
> -- --
> 8584736768 2147352576 5280 199912
> 199912
> Am I doing it right? How to verify my stuff are consuming memory from the
> AWE?
> Thanks.
>|||Also, there are AWE specific counters under SQLServer:Buffer Manager. Take a
look at these AWE counters to see if there are any AWE-related memory
activities.
Linchi
"light_wt" wrote:
> :)
> I have done these steps to config and enable AWE. But, DBCC MEMORYSTATUS
> still show AWE=0 on everywhere, liked Memory Manager, Memory node Id =0, etc.
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> -- restart the sql
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'min server memory', 1024
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> The box is a:
> Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)
> Mar 23 2007 16:28:52
> Copyright (c) 1988-2005 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
> That's a WinServer 2003 64-bit.
> Physical_memory_in_bytes virtual_memory_in_bytes bpool_committed
> bpool_commit_target bpool_visible
> -- -- --
> -- --
> 8584736768 2147352576 5280 199912
> 199912
> Am I doing it right? How to verify my stuff are consuming memory from the
> AWE?
> Thanks.
>|||thanks everyone for your ideas.
i've look at the SQL Server Log, after the instances started, the AWE is
enable.
i've check the userid who can do Lock Memory and is the same perosn who own
the Job.
in perfmon, I have added all AWE-related counters in SQLServer:Buffer
Manager
and changed the vertical counter to 5.
nothing happen. AWE got 0.
Am I missing something?
thanks.

Avoid duplicates in SELECT

SELECT *
FROM FUND
INNER JOIN POSITION ON FUND.ACCT = POSITION.ACCT
INNER JOIN SECURITY ON POSITION.SEC_ID = SECURITY.SEC_ID
WHERE (FUND.MANAGER = 'smith')
I get duplicate SEC_ID's with this query because Smith may be the manager of
multiple funds that hold positions in the same security. For this query I
only need to return one record per security, doesn't matter which.
Any help would be appreciated.Ah, the old "any row will do" trick... why bother with the extra data if it
really doesn't matter which row it is?
Can you provide DDL, sample data, and desired results? Please see
http://www.aspfaq.com/5006 to help you give better specs and get better
answers
"Terri" <terri@.cybernets.com> wrote in message
news:dbmmpg$4rg$1@.reader2.nmix.net...
> SELECT *
> FROM FUND
> INNER JOIN POSITION ON FUND.ACCT = POSITION.ACCT
> INNER JOIN SECURITY ON POSITION.SEC_ID = SECURITY.SEC_ID
> WHERE (FUND.MANAGER = 'smith')
> I get duplicate SEC_ID's with this query because Smith may be the manager
> of
> multiple funds that hold positions in the same security. For this query I
> only need to return one record per security, doesn't matter which.
> Any help would be appreciated.
>|||At least I didn't ask for the "first" row :)
In this case it truly doesn't matter. The business problem is, Provide a
unique list of securities held by each manager. Managers don't hold
securities directly, they manage multiple funds which in turn hold
securities. Let me get together some DDL. Thanks
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23Ht5xFYjFHA.232@.TK2MSFTNGP10.phx.gbl...
> Ah, the old "any row will do" trick... why bother with the extra data if
it
> really doesn't matter which row it is?
> Can you provide DDL, sample data, and desired results? Please see
> http://www.aspfaq.com/5006 to help you give better specs and get better
> answers

>|||> At least I didn't ask for the "first" row :)
Well, it's pretty much the same concept, and the same kind of problem that
SQL Server doesn't know how to solve.|||How does DISTINCT "know" which value to select from a list that contains
duplicates?
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:e4Vr8cgjFHA.3448@.TK2MSFTNGP12.phx.gbl...
> Well, it's pretty much the same concept, and the same kind of problem that
> SQL Server doesn't know how to solve.
>|||>> How does DISTINCT "know" which value to select from a list that contains
duplicates? <<
A table is not a list. And the result set is a new table build from
the query. You are still thinking in physical terms, as if the rows
were punch cards.|||On Wed, 20 Jul 2005 17:12:47 -0600, Terri wrote:

>SELECT *
>FROM FUND
>INNER JOIN POSITION ON FUND.ACCT = POSITION.ACCT
>INNER JOIN SECURITY ON POSITION.SEC_ID = SECURITY.SEC_ID
>WHERE (FUND.MANAGER = 'smith')
>I get duplicate SEC_ID's with this query because Smith may be the manager o
f
>multiple funds that hold positions in the same security. For this query I
>only need to return one record per security, doesn't matter which.
>Any help would be appreciated.
>
Hi Terri,
After reading the thread, I'd say that half of your problem is solved if
you replace "SELECT *" with "SELECT column, column, ...", listing only
the columns you need. Probably "SELECT SecID" or something like that.
The other half of your problem is elementary once the irrelevant extra
columns are no longer in the select list: simply inset the keyword
DISTINCT between SELECT and the column list and the duplicates are gone.
SELECT DISTINCT SecID
FROM Funds
INNER JOIN Positions
ON Positions.Acct = Funds.Acct
INNER JOIN Securities
ON Securites.SecID = Positions.SecID
WHERE Funds.Manager = 'Smith'
(untested)
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)

availability of Enterprise Manager

Is there a way to run the user interface tools for SQL Server, such as
Enterprise Manager and Query Analyzer, from two different computers on a
network, or do you need a separate license for each computer that will be
running them?
We are considering migrating to SQL Server, and we will have two developers
working on it. We will be installing our data in only one database, so we
only need one copy of SQL Server for the actual database. However, both
developers will need access to the user interface tools. Does this mean we
need to purchase two copies of SQL Server if the developers are working from
two different computers?
Thanks in advance,
Paul
"Paul Ponzelli" <begone@.spam.forever> wrote in
news:O4VpAi5PFHA.2252@.TK2MSFTNGP15.phx.gbl:

> Is there a way to run the user interface tools for SQL Server, such as
> Enterprise Manager and Query Analyzer, from two different computers on
> a network, or do you need a separate license for each computer that
> will be running them?
> We are considering migrating to SQL Server, and we will have two
> developers working on it. We will be installing our data in only one
> database, so we only need one copy of SQL Server for the actual
> database. However, both developers will need access to the user
> interface tools. Does this mean we need to purchase two copies of SQL
> Server if the developers are working from two different computers?
Licensing is not my field, but I try... If you're running in per processor
licensing mode I do not think that you need extra licenses for the
developers. Otherwise I think you only have to ensure that the developers
have client license to the database. What you should consider (in my
opinion) since this seems to be a development project, is to buy one MSDN
license for each developer. As far as I've understood Microsofts policy,
that should do, even without any licenses for the Server.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging
|||Thanks for your reply, Ole. However, everyone in my organization already
has a copy of Access 2002, and thus a license for MSDE. But MSDE doesn't
have the Enterprise Manager tool, and that's what I'm asking about. Can
developers on two different computers use Enterprise Manager for a SQL
Server database without having to buy two copies of SQL Server, or is there
a way they can both use Enterprise Manager from a single copy of SQL Server?
"Ole Kristian Bangs" <olekristian.bangas@.masterminds.no> wrote in message
news:Xns9636EFC48769Folekristianbangaas@.207.46.248 .16...
> "Paul Ponzelli" <begone@.spam.forever> wrote in
> news:O4VpAi5PFHA.2252@.TK2MSFTNGP15.phx.gbl:
>
> Licensing is not my field, but I try... If you're running in per processor
> licensing mode I do not think that you need extra licenses for the
> developers. Otherwise I think you only have to ensure that the developers
> have client license to the database. What you should consider (in my
> opinion) since this seems to be a development project, is to buy one MSDN
> license for each developer. As far as I've understood Microsofts policy,
> that should do, even without any licenses for the Server.
> --
> Ole Kristian Bangs
> MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging
|||"Paul Ponzelli" <begone@.spam.forever> wrote in
news:u6WUar6PFHA.3336@.TK2MSFTNGP09.phx.gbl:

> Thanks for your reply, Ole. However, everyone in my organization
> already has a copy of Access 2002, and thus a license for MSDE. But
> MSDE doesn't have the Enterprise Manager tool, and that's what I'm
> asking about. Can developers on two different computers use
> Enterprise Manager for a SQL Server database without having to buy two
> copies of SQL Server, or is there a way they can both use Enterprise
> Manager from a single copy of SQL Server?
Note: I said MSDN, not MSDE. MSDN is Microsoft Developer Network, which
gives access to software for testing and development purposes. One MSDN
membership is (as far as I know) required per developer. Except for that,
no other licenses should be neccessary. For further information:
http://msdn.microsoft.com/howtobuy/vs2005/subscribe/
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging
|||>> I said MSDN, not MSDE.
You're right! Duh.
Thanks so much, Ole.
|||hi,
in addition to Ole answer, you can get SQL Server Developer edition for
about $50, which includes all the client tools ...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||That's Great! Thanks, Andrea.

AutoStart

Hi,
Installed MSDE desktop (sp3) on XP, however the server does not autostart on
re-booting the machine. In the service manager the server/instance name is
missing after every re-boot. I enter it manually, check the autostart box
and it runs fine, but again after re-boot the server/instance name is lost
again.
I know our work machines are limited in allowing us to edit the registry,
but on a same build machine with full sql svr installed the problem does not
occur.
Any idea?
Cheers, Josh
Hi,
In Control Panel -- Admin tools -- Services -- Select the SQL Server
service.
Double click on the services and make it to automatic and click ok.
Thanks
Hari
SQL Server MVP
"Josh" <joshua.phillips@.notthisbit.blueyonder.co.uk> wrote in message
news:8CF778B9-DED3-48D2-912E-9EEFCC91BA80@.microsoft.com...
> Hi,
> Installed MSDE desktop (sp3) on XP, however the server does not autostart
> on
> re-booting the machine. In the service manager the server/instance name
> is
> missing after every re-boot. I enter it manually, check the autostart box
> and it runs fine, but again after re-boot the server/instance name is lost
> again.
> I know our work machines are limited in allowing us to edit the registry,
> but on a same build machine with full sql svr installed the problem does
> not
> occur.
> Any idea?
> Cheers, Josh
|||Hi,
It is alreday set to auto - the icon in the task bar tray does start, but
the white circle is empty. When I then click on the sql server service
manager, the server / instance name is blank - i.e. it is not remembering the
server / instance name from before the reboot.
Josh
"Hari Prasad" wrote:

> Hi,
> In Control Panel -- Admin tools -- Services -- Select the SQL Server
> service.
> Double click on the services and make it to automatic and click ok.
> Thanks
> Hari
> SQL Server MVP
>
> "Josh" <joshua.phillips@.notthisbit.blueyonder.co.uk> wrote in message
> news:8CF778B9-DED3-48D2-912E-9EEFCC91BA80@.microsoft.com...
>
>
|||hi Josh,
Josh wrote:
> Hi,
> Installed MSDE desktop (sp3) on XP, however the server does not
> autostart on re-booting the machine. In the service manager the
> server/instance name is missing after every re-boot. I enter it
> manually, check the autostart box and it runs fine, but again after
> re-boot the server/instance name is lost again.
> I know our work machines are limited in allowing us to edit the
> registry, but on a same build machine with full sql svr installed the
> problem does not occur.
please have a look at
http://support.microsoft.com/default...b;EN-US;814132
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply