difference between 'Backup' and DB maint. plan backup?

hi.
ive not setup any backups under 'Management' -> 'Backup' on my SQL2000 box.
instead ive used the 'Complete Backup' and ' Transaction Log Backup' tab
under Database Maintenance Plans -> 'NonSystemDatabaseMaintenance'.
is setting up a backup using a maintenance plan the same as setting up a
full backup under the 'Backup' tab?
thanks.Hi,
Backup tab is just creating the Logical Backup device. What you are doing is
exacltly the right procedure to take Full database
and Transaction log backup.
Looks like you are performing backup only for non system database backup,
But i recomend you to do the backup for all the system
databases as well. This will help you in the eve of crash.
Thanks
Hari
SQL Server MVP
"mb" <mb@.discussions.microsoft.com> wrote in message
news:C67C8B52-07C6-40D0-A722-2BCE97582372@.microsoft.com...
> hi.
> ive not setup any backups under 'Management' -> 'Backup' on my SQL2000
> box.
> instead ive used the 'Complete Backup' and ' Transaction Log Backup' tab
> under Database Maintenance Plans -> 'NonSystemDatabaseMaintenance'.
> is setting up a backup using a maintenance plan the same as setting up a
> full backup under the 'Backup' tab?
> thanks.|||hmm, yes, but i dont believe i have the option of 'remove inactive entries
from transaction log' when creating transaction logs from the maintenance
plans. true?
"Hari Prasad" wrote:
> Hi,
> Backup tab is just creating the Logical Backup device. What you are doing is
> exacltly the right procedure to take Full database
> and Transaction log backup.
> Looks like you are performing backup only for non system database backup,
> But i recomend you to do the backup for all the system
> databases as well. This will help you in the eve of crash.
> Thanks
> Hari
> SQL Server MVP
>
>
> "mb" <mb@.discussions.microsoft.com> wrote in message
> news:C67C8B52-07C6-40D0-A722-2BCE97582372@.microsoft.com...
> > hi.
> >
> > ive not setup any backups under 'Management' -> 'Backup' on my SQL2000
> > box.
> > instead ive used the 'Complete Backup' and ' Transaction Log Backup' tab
> > under Database Maintenance Plans -> 'NonSystemDatabaseMaintenance'.
> >
> > is setting up a backup using a maintenance plan the same as setting up a
> > full backup under the 'Backup' tab?
> >
> > thanks.
>
>|||Btw, I've written an article about this:
http://www.karaszi.com/SQLServer/info_restore_no_truncate.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"mb" <mb@.discussions.microsoft.com> wrote in message
news:5E78EC73-4EBA-4DAD-836E-3EBAD9D3BFA8@.microsoft.com...
> hmm, yes, but i dont believe i have the option of 'remove inactive entries
> from transaction log' when creating transaction logs from the maintenance
> plans. true?
> "Hari Prasad" wrote:
>> Hi,
>> Backup tab is just creating the Logical Backup device. What you are doing is
>> exacltly the right procedure to take Full database
>> and Transaction log backup.
>> Looks like you are performing backup only for non system database backup,
>> But i recomend you to do the backup for all the system
>> databases as well. This will help you in the eve of crash.
>> Thanks
>> Hari
>> SQL Server MVP
>>
>>
>> "mb" <mb@.discussions.microsoft.com> wrote in message
>> news:C67C8B52-07C6-40D0-A722-2BCE97582372@.microsoft.com...
>> > hi.
>> >
>> > ive not setup any backups under 'Management' -> 'Backup' on my SQL2000
>> > box.
>> > instead ive used the 'Complete Backup' and ' Transaction Log Backup' tab
>> > under Database Maintenance Plans -> 'NonSystemDatabaseMaintenance'.
>> >
>> > is setting up a backup using a maintenance plan the same as setting up a
>> > full backup under the 'Backup' tab?
>> >
>> > thanks.
>>|||Maint plan will not add the NO_TRUNCATE option for the backup log command. This option is what
empties the log and when you uncheck in the backup dialog, this option is added. Terrible GUI design
in the backup dialog (not maint wiz) IMO, and this option has a very special purpose and is only
used for disaster scenarios.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"mb" <mb@.discussions.microsoft.com> wrote in message
news:5E78EC73-4EBA-4DAD-836E-3EBAD9D3BFA8@.microsoft.com...
> hmm, yes, but i dont believe i have the option of 'remove inactive entries
> from transaction log' when creating transaction logs from the maintenance
> plans. true?
> "Hari Prasad" wrote:
>> Hi,
>> Backup tab is just creating the Logical Backup device. What you are doing is
>> exacltly the right procedure to take Full database
>> and Transaction log backup.
>> Looks like you are performing backup only for non system database backup,
>> But i recomend you to do the backup for all the system
>> databases as well. This will help you in the eve of crash.
>> Thanks
>> Hari
>> SQL Server MVP
>>
>>
>> "mb" <mb@.discussions.microsoft.com> wrote in message
>> news:C67C8B52-07C6-40D0-A722-2BCE97582372@.microsoft.com...
>> > hi.
>> >
>> > ive not setup any backups under 'Management' -> 'Backup' on my SQL2000
>> > box.
>> > instead ive used the 'Complete Backup' and ' Transaction Log Backup' tab
>> > under Database Maintenance Plans -> 'NonSystemDatabaseMaintenance'.
>> >
>> > is setting up a backup using a maintenance plan the same as setting up a
>> > full backup under the 'Backup' tab?
>> >
>> > thanks.
>>

difference between 'Backup' and DB maint. plan backup?

hi.
ive not setup any backups under 'Management' -> 'Backup' on my SQL2000 box.
instead ive used the 'Complete Backup' and ' Transaction Log Backup' tab
under Database Maintenance Plans -> 'NonSystemDatabaseMaintenance'.
is setting up a backup using a maintenance plan the same as setting up a
full backup under the 'Backup' tab?
thanks.Hi,
Backup tab is just creating the Logical Backup device. What you are doing is
exacltly the right procedure to take Full database
and Transaction log backup.
Looks like you are performing backup only for non system database backup,
But i recomend you to do the backup for all the system
databases as well. This will help you in the eve of crash.
Thanks
Hari
SQL Server MVP
"mb" <mb@.discussions.microsoft.com> wrote in message
news:C67C8B52-07C6-40D0-A722-2BCE97582372@.microsoft.com...
> hi.
> ive not setup any backups under 'Management' -> 'Backup' on my SQL2000
> box.
> instead ive used the 'Complete Backup' and ' Transaction Log Backup' tab
> under Database Maintenance Plans -> 'NonSystemDatabaseMaintenance'.
> is setting up a backup using a maintenance plan the same as setting up a
> full backup under the 'Backup' tab?
> thanks.|||hmm, yes, but i dont believe i have the option of 'remove inactive entries
from transaction log' when creating transaction logs from the maintenance
plans. true?
"Hari Prasad" wrote:

> Hi,
> Backup tab is just creating the Logical Backup device. What you are doing
is
> exacltly the right procedure to take Full database
> and Transaction log backup.
> Looks like you are performing backup only for non system database backup,
> But i recomend you to do the backup for all the system
> databases as well. This will help you in the eve of crash.
> Thanks
> Hari
> SQL Server MVP
>
>
> "mb" <mb@.discussions.microsoft.com> wrote in message
> news:C67C8B52-07C6-40D0-A722-2BCE97582372@.microsoft.com...
>
>|||Maint plan will not add the NO_TRUNCATE option for the backup log command. T
his option is what
empties the log and when you uncheck in the backup dialog, this option is ad
ded. Terrible GUI design
in the backup dialog (not maint wiz) IMO, and this option has a very special
purpose and is only
used for disaster scenarios.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"mb" <mb@.discussions.microsoft.com> wrote in message
news:5E78EC73-4EBA-4DAD-836E-3EBAD9D3BFA8@.microsoft.com...[vbcol=seagreen]
> hmm, yes, but i dont believe i have the option of 'remove inactive entries
> from transaction log' when creating transaction logs from the maintenance
> plans. true?
> "Hari Prasad" wrote:
>|||Btw, I've written an article about this:
http://www.karaszi.com/SQLServer/in...no_truncate.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"mb" <mb@.discussions.microsoft.com> wrote in message
news:5E78EC73-4EBA-4DAD-836E-3EBAD9D3BFA8@.microsoft.com...[vbcol=seagreen]
> hmm, yes, but i dont believe i have the option of 'remove inactive entries
> from transaction log' when creating transaction logs from the maintenance
> plans. true?
> "Hari Prasad" wrote:
>

difference between 'Backup' and DB maint. plan backup?

hi.
ive not setup any backups under 'Management' -> 'Backup' on my SQL2000 box.
instead ive used the 'Complete Backup' and ' Transaction Log Backup' tab
under Database Maintenance Plans -> 'NonSystemDatabaseMaintenance'.
is setting up a backup using a maintenance plan the same as setting up a
full backup under the 'Backup' tab?
thanks.
Hi,
Backup tab is just creating the Logical Backup device. What you are doing is
exacltly the right procedure to take Full database
and Transaction log backup.
Looks like you are performing backup only for non system database backup,
But i recomend you to do the backup for all the system
databases as well. This will help you in the eve of crash.
Thanks
Hari
SQL Server MVP
"mb" <mb@.discussions.microsoft.com> wrote in message
news:C67C8B52-07C6-40D0-A722-2BCE97582372@.microsoft.com...
> hi.
> ive not setup any backups under 'Management' -> 'Backup' on my SQL2000
> box.
> instead ive used the 'Complete Backup' and ' Transaction Log Backup' tab
> under Database Maintenance Plans -> 'NonSystemDatabaseMaintenance'.
> is setting up a backup using a maintenance plan the same as setting up a
> full backup under the 'Backup' tab?
> thanks.
|||hmm, yes, but i dont believe i have the option of 'remove inactive entries
from transaction log' when creating transaction logs from the maintenance
plans. true?
"Hari Prasad" wrote:

> Hi,
> Backup tab is just creating the Logical Backup device. What you are doing is
> exacltly the right procedure to take Full database
> and Transaction log backup.
> Looks like you are performing backup only for non system database backup,
> But i recomend you to do the backup for all the system
> databases as well. This will help you in the eve of crash.
> Thanks
> Hari
> SQL Server MVP
>
>
> "mb" <mb@.discussions.microsoft.com> wrote in message
> news:C67C8B52-07C6-40D0-A722-2BCE97582372@.microsoft.com...
>
>
|||Maint plan will not add the NO_TRUNCATE option for the backup log command. This option is what
empties the log and when you uncheck in the backup dialog, this option is added. Terrible GUI design
in the backup dialog (not maint wiz) IMO, and this option has a very special purpose and is only
used for disaster scenarios.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"mb" <mb@.discussions.microsoft.com> wrote in message
news:5E78EC73-4EBA-4DAD-836E-3EBAD9D3BFA8@.microsoft.com...[vbcol=seagreen]
> hmm, yes, but i dont believe i have the option of 'remove inactive entries
> from transaction log' when creating transaction logs from the maintenance
> plans. true?
> "Hari Prasad" wrote:
|||Btw, I've written an article about this:
http://www.karaszi.com/SQLServer/inf...o_truncate.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"mb" <mb@.discussions.microsoft.com> wrote in message
news:5E78EC73-4EBA-4DAD-836E-3EBAD9D3BFA8@.microsoft.com...[vbcol=seagreen]
> hmm, yes, but i dont believe i have the option of 'remove inactive entries
> from transaction log' when creating transaction logs from the maintenance
> plans. true?
> "Hari Prasad" wrote:

Diagram keeps resetting page breaks

I am using SQL Server 2005. I have created a database diagram and using page setup, I have set the page to 100% scale. On the diagram, I display page breaks. When I go to print the diagram (or click reset page breaks), all of the diagram objects shift down about half a page. Is anyone else having this problem? Does anyone have a fix? This is getting really frustrating! I am trying to avoid having tables span accross pages as fields tend to get lost due to margin issues.

Thanks in advance!

-Julie

I have found the Diagramming tool to be a very frustrating tool to create acceptable printouts.

So I recommend using Visio to create your Diagrams. And with Visio, you have full control of the printouts (I often use continuous Size D paper on a plotter.)

Developers on Other Machines (formerly: Problem installing SQL Server Reporting Services )

Bruce:
Sorry for the misposting.
I don't understand what you mean by "you haven't setup your roles for
the developers on other machines." Once a user role (developer or
otherwise) is set up on the server, shouldn't it be in effect no
matter where a user logs in from?
Jody
"Bruce Loehle-Conger (bruce_lcNOSPAM@.hotmail.com)" wrote:
> Your problem seems different. He was having a problem installing. Your
> problem seems to be accessing it. It looks to me like you haven't setup your
> roles for the developers on other machines.
Bruce L-C
>"JodyT" <datagal@.msn.com> wrote in message
>news:f9d864c3.0408111251.61c4d16f@.posting.google.com...
>> I'm having a similar problem...
>>
>> Enterprise and Developer set up on one server machine, Developer on
2
>> other desktops. If you access Report Manager from the Server
machine,
>> everything looks fine. But Report Manager accessed from the
>> non-server machines shows the top banner only... No tabs, no
folders,
>> nothing below the line, so a developer can't upload without
switching
>> over to the server, and even then there are often errors.
>>
>> Is there some configuration subtlety we missed?
>>
>> Otherwise this thing is giving me problems with OutOfMemory errors
on
>> local debugs that I know aren't too big.
>>
>> Ideas?
>> Jody
>>I suspect one of two things are happening. You have anonymous access on
which ends up treating everyone as the same regardless of how they are
logged in and they end up not having the permissions you wish them to have.
Or, the developers are either not assigned to a role, or are assigned to a
role that does not have the correct rights, or are assigned to a role with
the correct rights but that role has not been applied to the appropriate
part of the website. Unless you override it, any folder/report inherits the
role assignments from further up the tree. So if you assign the role from
above
My guess is when they are on the server they are not logged in as themselves
but are logged in as the admin for the local machine.
If they log into the server as themselves and the website does not look the
same as when they try to access it from their computers then my reasoning
falls apart.
So, check the the following.
1. Do you have anonymous access turned on?
2. What happens if you log into the server as one of the developers that are
having difficulties.
Bruce L-C
"JodyT" <datagal@.msn.com> wrote in message
news:f9d864c3.0408120929.8a3b6d7@.posting.google.com...
> Bruce:
> Sorry for the misposting.
> I don't understand what you mean by "you haven't setup your roles for
> the developers on other machines." Once a user role (developer or
> otherwise) is set up on the server, shouldn't it be in effect no
> matter where a user logs in from?
> Jody
> "Bruce Loehle-Conger (bruce_lcNOSPAM@.hotmail.com)" wrote:
> > Your problem seems different. He was having a problem installing. Your
> > problem seems to be accessing it. It looks to me like you haven't setup
your
> > roles for the developers on other machines.
> Bruce L-C
> >"JodyT" <datagal@.msn.com> wrote in message
> >news:f9d864c3.0408111251.61c4d16f@.posting.google.com...
> >> I'm having a similar problem...
> >>
> >> Enterprise and Developer set up on one server machine, Developer on
> 2
> >> other desktops. If you access Report Manager from the Server
> machine,
> >> everything looks fine. But Report Manager accessed from the
> >> non-server machines shows the top banner only... No tabs, no
> folders,
> >> nothing below the line, so a developer can't upload without
> switching
> >> over to the server, and even then there are often errors.
> >>
> >> Is there some configuration subtlety we missed?
> >>
> >> Otherwise this thing is giving me problems with OutOfMemory errors
> on
> >> local debugs that I know aren't too big.
> >>
> >> Ideas?
> >> Jody
> >>|||Actually I am the developer, with very minimal network learnin'. I
finally got the guy who installed to look at the research I've been
doing and he ended up reinstalling "paying closer attention to the
configuration options". He did have to do some monkeying around with
the anonymous thing, but he seems to have it working now. We'll see
how it goes if we ever put some actual users on it.
Thanks all for the input. It was a big help.
Jody
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message news:<ur$lBPJgEHA.556@.tk2msftngp13.phx.gbl>...
> I suspect one of two things are happening. You have anonymous access on
> which ends up treating everyone as the same regardless of how they are
> logged in and they end up not having the permissions you wish them to have.
> Or, the developers are either not assigned to a role, or are assigned to a
> role that does not have the correct rights, or are assigned to a role with
> the correct rights but that role has not been applied to the appropriate
> part of the website. Unless you override it, any folder/report inherits the
> role assignments from further up the tree. So if you assign the role from
> above
> My guess is when they are on the server they are not logged in as themselves
> but are logged in as the admin for the local machine.
> If they log into the server as themselves and the website does not look the
> same as when they try to access it from their computers then my reasoning
> falls apart.
> So, check the the following.
> 1. Do you have anonymous access turned on?
> 2. What happens if you log into the server as one of the developers that are
> having difficulties.
> Bruce L-C
> "JodyT" <datagal@.msn.com> wrote in message
> news:f9d864c3.0408120929.8a3b6d7@.posting.google.com...
> > Bruce:
> >
> > Sorry for the misposting.
> >
> > I don't understand what you mean by "you haven't setup your roles for
> > the developers on other machines." Once a user role (developer or
> > otherwise) is set up on the server, shouldn't it be in effect no
> > matter where a user logs in from?
> >
> > Jody
> >
> > "Bruce Loehle-Conger (bruce_lcNOSPAM@.hotmail.com)" wrote:
> > > Your problem seems different. He was having a problem installing. Your
> > > problem seems to be accessing it. It looks to me like you haven't setup
> your
> > > roles for the developers on other machines.
> >
> > Bruce L-C
> >
> > >"JodyT" <datagal@.msn.com> wrote in message
> > >news:f9d864c3.0408111251.61c4d16f@.posting.google.com...
> > >> I'm having a similar problem...
> > >>
> > >> Enterprise and Developer set up on one server machine, Developer on
> 2
> > >> other desktops. If you access Report Manager from the Server
> machine,
> > >> everything looks fine. But Report Manager accessed from the
> > >> non-server machines shows the top banner only... No tabs, no
> folders,
> > >> nothing below the line, so a developer can't upload without
> switching
> > >> over to the server, and even then there are often errors.
> > >>
> > >> Is there some configuration subtlety we missed?
> > >>
> > >> Otherwise this thing is giving me problems with OutOfMemory errors
> on
> > >> local debugs that I know aren't too big.
> > >>
> > >> Ideas?
> > >> Jody
> > >>