Backing up SQL Databases

Hello:
How do you change the scheduled database backups in SQL Server 2000?
We have a scheduled backup of a production database that is run once a day.
We need to change it to update once a week; however, no matter what we do, we
can't remove or edit the existing backup schedule.
In the SQL Server Backup dialog box, regardless of whether the Destination
is removed and/or a new one is created, or if the Schedule is changed, none
of these new settings are ever saved. Why is this? What am I missing to get
around this?
Thanks,
Troy
Check your SQL Server agent jobs.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"STroy" <STroy@.discussions.microsoft.com> wrote in message
news:4AADB0A7-E440-470F-BF1E-2B5134AB1899@.microsoft.com...
> Hello:
> How do you change the scheduled database backups in SQL Server 2000?
> We have a scheduled backup of a production database that is run once a day.
> We need to change it to update once a week; however, no matter what we do, we
> can't remove or edit the existing backup schedule.
> In the SQL Server Backup dialog box, regardless of whether the Destination
> is removed and/or a new one is created, or if the Schedule is changed, none
> of these new settings are ever saved. Why is this? What am I missing to get
> around this?
> Thanks,
> Troy
|||Hello,
Do you have enough previlages to update the job. Try login as SA and update
the job schedule using enterprise manager...
Thanks
Hari
"STroy" <STroy@.discussions.microsoft.com> wrote in message
news:4AADB0A7-E440-470F-BF1E-2B5134AB1899@.microsoft.com...
> Hello:
> How do you change the scheduled database backups in SQL Server 2000?
> We have a scheduled backup of a production database that is run once a
> day.
> We need to change it to update once a week; however, no matter what we do,
> we
> can't remove or edit the existing backup schedule.
> In the SQL Server Backup dialog box, regardless of whether the Destination
> is removed and/or a new one is created, or if the Schedule is changed,
> none
> of these new settings are ever saved. Why is this? What am I missing to
> get
> around this?
> Thanks,
> Troy
|||Hello:
I am logged in under the SA account and trying to update the job in
enterprise manager. Is there something else I should be looking at or
resetting?
Thanks,
STroy
"Hari Prasad" wrote:

> Hello,
> Do you have enough previlages to update the job. Try login as SA and update
> the job schedule using enterprise manager...
> Thanks
> Hari
> "STroy" <STroy@.discussions.microsoft.com> wrote in message
> news:4AADB0A7-E440-470F-BF1E-2B5134AB1899@.microsoft.com...
>
>

Backing up SQL Databases

Hello:
How do you change the scheduled database backups in SQL Server 2000?
We have a scheduled backup of a production database that is run once a day.
We need to change it to update once a week; however, no matter what we do, we
can't remove or edit the existing backup schedule.
In the SQL Server Backup dialog box, regardless of whether the Destination
is removed and/or a new one is created, or if the Schedule is changed, none
of these new settings are ever saved. Why is this? What am I missing to get
around this?
Thanks,
TroyCheck your SQL Server agent jobs.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"STroy" <STroy@.discussions.microsoft.com> wrote in message
news:4AADB0A7-E440-470F-BF1E-2B5134AB1899@.microsoft.com...
> Hello:
> How do you change the scheduled database backups in SQL Server 2000?
> We have a scheduled backup of a production database that is run once a day.
> We need to change it to update once a week; however, no matter what we do, we
> can't remove or edit the existing backup schedule.
> In the SQL Server Backup dialog box, regardless of whether the Destination
> is removed and/or a new one is created, or if the Schedule is changed, none
> of these new settings are ever saved. Why is this? What am I missing to get
> around this?
> Thanks,
> Troy|||Hello,
Do you have enough previlages to update the job. Try login as SA and update
the job schedule using enterprise manager...
Thanks
Hari
"STroy" <STroy@.discussions.microsoft.com> wrote in message
news:4AADB0A7-E440-470F-BF1E-2B5134AB1899@.microsoft.com...
> Hello:
> How do you change the scheduled database backups in SQL Server 2000?
> We have a scheduled backup of a production database that is run once a
> day.
> We need to change it to update once a week; however, no matter what we do,
> we
> can't remove or edit the existing backup schedule.
> In the SQL Server Backup dialog box, regardless of whether the Destination
> is removed and/or a new one is created, or if the Schedule is changed,
> none
> of these new settings are ever saved. Why is this? What am I missing to
> get
> around this?
> Thanks,
> Troy|||Hello:
I am logged in under the SA account and trying to update the job in
enterprise manager. Is there something else I should be looking at or
resetting?
Thanks,
STroy
"Hari Prasad" wrote:
> Hello,
> Do you have enough previlages to update the job. Try login as SA and update
> the job schedule using enterprise manager...
> Thanks
> Hari
> "STroy" <STroy@.discussions.microsoft.com> wrote in message
> news:4AADB0A7-E440-470F-BF1E-2B5134AB1899@.microsoft.com...
> > Hello:
> >
> > How do you change the scheduled database backups in SQL Server 2000?
> >
> > We have a scheduled backup of a production database that is run once a
> > day.
> > We need to change it to update once a week; however, no matter what we do,
> > we
> > can't remove or edit the existing backup schedule.
> >
> > In the SQL Server Backup dialog box, regardless of whether the Destination
> > is removed and/or a new one is created, or if the Schedule is changed,
> > none
> > of these new settings are ever saved. Why is this? What am I missing to
> > get
> > around this?
> >
> > Thanks,
> > Troy
>
>

Backing up SQL Databases

Hello:
How do you change the scheduled database backups in SQL Server 2000?
We have a scheduled backup of a production database that is run once a day.
We need to change it to update once a week; however, no matter what we do, w
e
can't remove or edit the existing backup schedule.
In the SQL Server Backup dialog box, regardless of whether the Destination
is removed and/or a new one is created, or if the Schedule is changed, none
of these new settings are ever saved. Why is this? What am I missing to get
around this?
Thanks,
TroyCheck your SQL Server agent jobs.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"STroy" <STroy@.discussions.microsoft.com> wrote in message
news:4AADB0A7-E440-470F-BF1E-2B5134AB1899@.microsoft.com...
> Hello:
> How do you change the scheduled database backups in SQL Server 2000?
> We have a scheduled backup of a production database that is run once a day
.
> We need to change it to update once a week; however, no matter what we do,
we
> can't remove or edit the existing backup schedule.
> In the SQL Server Backup dialog box, regardless of whether the Destination
> is removed and/or a new one is created, or if the Schedule is changed, non
e
> of these new settings are ever saved. Why is this? What am I missing to ge
t
> around this?
> Thanks,
> Troy|||Hello,
Do you have enough previlages to update the job. Try login as SA and update
the job schedule using enterprise manager...
Thanks
Hari
"STroy" <STroy@.discussions.microsoft.com> wrote in message
news:4AADB0A7-E440-470F-BF1E-2B5134AB1899@.microsoft.com...
> Hello:
> How do you change the scheduled database backups in SQL Server 2000?
> We have a scheduled backup of a production database that is run once a
> day.
> We need to change it to update once a week; however, no matter what we do,
> we
> can't remove or edit the existing backup schedule.
> In the SQL Server Backup dialog box, regardless of whether the Destination
> is removed and/or a new one is created, or if the Schedule is changed,
> none
> of these new settings are ever saved. Why is this? What am I missing to
> get
> around this?
> Thanks,
> Troy|||Hello:
I am logged in under the SA account and trying to update the job in
enterprise manager. Is there something else I should be looking at or
resetting?
Thanks,
STroy
"Hari Prasad" wrote:

> Hello,
> Do you have enough previlages to update the job. Try login as SA and updat
e
> the job schedule using enterprise manager...
> Thanks
> Hari
> "STroy" <STroy@.discussions.microsoft.com> wrote in message
> news:4AADB0A7-E440-470F-BF1E-2B5134AB1899@.microsoft.com...
>
>

Back up SQL server 2005 ! Need help

i am a IT administrator ! I am now administer the webserver run SQL server 2005, running backup symantec exec . I want to know there is other better tool for sql backup ! I really dont like database much ! just want to know enough for administering them :mad:Use the built-in MSSQL 2005 tools for backing up your databases.
I haven't used Symantec's database backup product, but I have had several bad experiences with Veritas. I advise using the SQL Server tools to backup your databases to disk, and then use Symantec or Veritas to archive the backup files to tape.|||Use the built-in MSSQL 2005 tools for backing up your databases.
I haven't used Symantec's database backup product, but I have had several bad experiences with Veritas. I advise using the SQL Server tools to backup your databases to disk, and then use Symantec or Veritas to archive the backup files to tape.

+1. The only third-party tools I've considered for backing up my databases are compression utilities (like LiteSpeed from Imceda/Quest or SQL Backup from Red Gate). Other than these, I avoid plug-ins for "Enterprise" backup solutions.

I have used one other product: Timefinder Module for EMC Symmetrix. That was an interesting implementation that allowed for near-instantaneous backups of multi-terabyte databases. That's overkill for most situations though.

Regards,

hmscott

Back Up

Hi
Is there any way I can run a back up routine from a batch file
regards
Jonathan
===============
Jonathan Crawford
01273 440018
07799 068570
fax 01273 380221
jc@.jcrawford.co.uk
===============You mean you want to perform for instance a database backup from a .BAT file
? If so, yes:
Create the bat file. In there, you call OSQL.EXE using the /Q parameter, whe
re after the /Q
parameter you have your BACKUP command. Here's a simple example with a PRINT
instead of BACKUP
command:
OSQL /E /Q "Print 'Hello'
The command line switches for OSQL as well as the BACKUP command are documen
ted in Books Online.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jonathan Crawford" <jc@.jcrawford.co.uk> wrote in message
news:u3nc$KoEFHA.3992@.tk2msftngp13.phx.gbl...
> Hi
> Is there any way I can run a back up routine from a batch file
> regards
> Jonathan
> --
> ===============
> Jonathan Crawford
> 01273 440018
> 07799 068570
> fax 01273 380221
> jc@.jcrawford.co.uk
> ===============
>|||You can call the SQL Server command line utility (called osql.exe) from a
batch file, and you can run all SQL statements in osql, including BACKUP.
You can find the complete syntax for osql in Books Online.
Jacco Schalkwijk
SQL Server MVP
"Jonathan Crawford" <jc@.jcrawford.co.uk> wrote in message
news:u3nc$KoEFHA.3992@.tk2msftngp13.phx.gbl...
> Hi
> Is there any way I can run a back up routine from a batch file
> regards
> Jonathan
> --
> ===============
> Jonathan Crawford
> 01273 440018
> 07799 068570
> fax 01273 380221
> jc@.jcrawford.co.uk
> ===============
>|||You can invoke the osql commad from the batch file. Which in turn does the
actual backup using an SP / backup command.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"Jonathan Crawford" <jc@.jcrawford.co.uk> wrote in message
news:u3nc$KoEFHA.3992@.tk2msftngp13.phx.gbl...
> Hi
> Is there any way I can run a back up routine from a batch file
> regards
> Jonathan
> --
> ===============
> Jonathan Crawford
> 01273 440018
> 07799 068570
> fax 01273 380221
> jc@.jcrawford.co.uk
> ===============
>

AWE enabled ?

Hi All,

When i run the command,

use master
go
sp_configure 'awe enabled',1
go
reconfigure
go

I got the output,
name : awe enabled
minimum: 0
Maximum: 1
config_value: 0
run_value: 0

From the value of config_value ,it mean that the "awe" is not enabled.

But, when we see the System Configuration:
OS Win 2003 Standard sp1

Sql server 2005 sp1 ( I have only one instance )

System configuration = 3.83 GB of RAM

The total is 3.83GB of RAM, but When i right click the sql server
instance , select 'Properties' and then on the 'General' tab , i
see 'Memory' assigned to that instance as = 3927 (MB)

Does this mean that, someone already has enabled AWE option. That's
the reason its showing memory = 3927 MB. (or) i have to enable it
externally.

Can someone reply as soon as possible plz.

Thanks.

Here are the commands you need to run in SQL Server

sp_configure 'show advanced options', 1 RECONFIGURE GO sp_configure 'awe enabled', 1 RECONFIGURE GOYou also need to make sure your boot.ini file has the /PAE switch in it.|||

Hi GlennAlanBerry,

Do u mean to say /3GB (or) /PAE.

Because my Operating System is Win 2003 standard sp1 and sql server 2005 sp1.

And without enabling AWE also , sql server instance properties shows full sql server RAM?

Thanks.

|||If you only have 4GB of RAM in the server, and you want the OS to be able to use 3GB for applications instead of a max of 2GB, you would want to use the /3GB switch. If you had, say 8GB of RAM in the server, and you wanted the OS to be able to use more than 4GB of memory, you would want to use the /PAE switch.

Avoiding WHERE IN

This query seems to run particularly slowly, is there a way to rewrite
it without using IN?
id fruit_name
14 Apple
34 Apple
37 Banana
56 Banana
66 Banana
78 Pear
103 Orange
select * from my_table
where id in (
select max(id)
from my_table
group by fruit_name )
Result
==================
id fruit_name
34 Apple
66 Banana
78 Pear
103 Orange
Cheers!SELECT A.* FROM MyTable A
INNER JOIN
(SELECT max(id) as Id FROM MyTable) B
ON A.id = B.Id
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
<davidol@.hushmail.com> wrote in message
news:1109567370.806709.130280@.o13g2000cwo.googlegroups.com...
> This query seems to run particularly slowly, is there a way to rewrite
> it without using IN?
> id fruit_name
> 14 Apple
> 34 Apple
> 37 Banana
> 56 Banana
> 66 Banana
> 78 Pear
> 103 Orange
> select * from my_table
> where id in (
> select max(id)
> from my_table
> group by fruit_name )
> Result
> ==================
> id fruit_name
> 34 Apple
> 66 Banana
> 78 Pear
> 103 Orange
>
> Cheers!
>|||An index on (fruit_name) or perhaps (fruit_name, id) or (fruit_name, id
desc)
will help, I think.
You can also try some alternative was of writing this.
select fruit_name, max(id)
from my_table
group by fruit_name
select * from my_table
where not exists (
select * from my_table as mtcopy
where mtcopy.fruit_name = my_table.fruit_name
and mtcopy.id > my_table.id
)
select fruit_name, id
from my_table
where id = (
select top 1 id
from my_table as mtcopy
where mtcopy.fruit_name = my_table.fruit_name
order by id desc
)
Steve Kass
Drew University
davidol@.hushmail.com wrote:

>This query seems to run particularly slowly, is there a way to rewrite
>it without using IN?
>id fruit_name
>14 Apple
>34 Apple
>37 Banana
>56 Banana
>66 Banana
>78 Pear
>103 Orange
> select * from my_table
> where id in (
> select max(id)
> from my_table
> group by fruit_name )
>Result
>==================
>id fruit_name
>34 Apple
>66 Banana
>78 Pear
>103 Orange
>
>Cheers!
>
>|||SELECT MAX(id), fruit_name
FROM my_table
GROUP BY fruit_name
However, this probably won't do much to speed up the query. Can you give
actual DDL, including any indexes? (See http://www.aspfaq.com/5006
On 2/28/05 12:09 AM, in article
1109567370.806709.130280@.o13g2000cwo.googlegroups.com,
"davidol@.hushmail.com" <davidol@.hushmail.com> wrote:

> This query seems to run particularly slowly, is there a way to rewrite
> it without using IN?
> id fruit_name
> 14 Apple
> 34 Apple
> 37 Banana
> 56 Banana
> 66 Banana
> 78 Pear
> 103 Orange
> select * from my_table
> where id in (
> select max(id)
> from my_table
> group by fruit_name )
> Result
> ==================
> id fruit_name
> 34 Apple
> 66 Banana
> 78 Pear
> 103 Orange
>
> Cheers!
>

Avoid triggers in condition

I have a insert/update trigger on MYTABLE.
Is it possible to avoid/deactive this trigger under certain conditions? For
example, when I run a stored procedure.
Any ideas? Maybe setting somekind of temporary variable and unsetting it
after the store proc has run?
Thanks!On Thu, 22 Sep 2005 19:57:20 -0300, Kirsten wrote:

>I have a insert/update trigger on MYTABLE.
>Is it possible to avoid/deactive this trigger under certain conditions? For
>example, when I run a stored procedure.
>Any ideas? Maybe setting somekind of temporary variable and unsetting it
>after the store proc has run?
>Thanks!
>
Hi Kirsten
ALTER TABLE TableName
DISABLE TRIGGER TriggerName
do something
ALTER TABLE TableName
ENABLE TRIGGER TriggerName
Beware that this will disable the trigger for all connections. If a user
updates the table just when you are running the script, then the trigger
won't fire for him/her either.
A better option is to use the trigger only for code that has to be run
for in ALL circumstances, and put code that is needed only when end
users update the data in the stored procedure they call to make the
modifications.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||Kirsten,
A trigger can be enabled/disabled for a table by using the ALTER TABLE
statment.
However, TMK, a trigger will always fire when the action that the trigger is
defined for occurs and the trigger is enabled.
HTH
Jerry
"Kirsten" <norep@.norep.com> wrote in message
news:OEzZ%23j8vFHA.3860@.TK2MSFTNGP09.phx.gbl...
>I have a insert/update trigger on MYTABLE.
> Is it possible to avoid/deactive this trigger under certain conditions?
> For
> example, when I run a stored procedure.
> Any ideas? Maybe setting somekind of temporary variable and unsetting it
> after the store proc has run?
> Thanks!
>|||Ok.
What about if the condition is bases on a column?
For example, how to ask inside the trigger the following?
if only column 4 is updated then do nothing
else do everything.
Thanks!
"Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
news:61e6j19h308utjgsgcm3uios961hlmv896@.
4ax.com...
> On Thu, 22 Sep 2005 19:57:20 -0300, Kirsten wrote:
>
For
> Hi Kirsten
> ALTER TABLE TableName
> DISABLE TRIGGER TriggerName
> do something
> ALTER TABLE TableName
> ENABLE TRIGGER TriggerName
> Beware that this will disable the trigger for all connections. If a user
> updates the table just when you are running the script, then the trigger
> won't fire for him/her either.
> A better option is to use the trigger only for code that has to be run
> for in ALL circumstances, and put code that is needed only when end
> users update the data in the stored procedure they call to make the
> modifications.
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)|||Kirsten,
Use the IF UPDATE (column) AND/OR syntax. See the CREATE TRIGGER statement
in SQL BOL.
HTH
Jerry
"Kirsten" <norep@.norep.com> wrote in message
news:O$XKZu8vFHA.3252@.TK2MSFTNGP10.phx.gbl...
> Ok.
> What about if the condition is bases on a column?
> For example, how to ask inside the trigger the following?
> if only column 4 is updated then do nothing
> else do everything.
> Thanks!
> "Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
> news:61e6j19h308utjgsgcm3uios961hlmv896@.
4ax.com...
> For
>|||Look up SET CONTEXT_INFO in BOL.
"Kirsten" <norep@.norep.com> wrote in message
news:OEzZ%23j8vFHA.3860@.TK2MSFTNGP09.phx.gbl...
>I have a insert/update trigger on MYTABLE.
> Is it possible to avoid/deactive this trigger under certain conditions?
> For
> example, when I run a stored procedure.
> Any ideas? Maybe setting somekind of temporary variable and unsetting it
> after the store proc has run?
> Thanks!
>|||Maybe this is what you need:
http://www.aspfaq.com/show.asp?id=2016
"Brian Selzer" <brian@.selzer-software.com> wrote in message
news:uOa6xM9vFHA.4032@.TK2MSFTNGP15.phx.gbl...
> Look up SET CONTEXT_INFO in BOL.
> "Kirsten" <norep@.norep.com> wrote in message
> news:OEzZ%23j8vFHA.3860@.TK2MSFTNGP09.phx.gbl...
>

Avoid Package Failure

Hello everyone

i'm using a Foreach Container to run certain tasks, these ones are inside a Sequence Container. I'd like to know if there is a way to have a task failure without a foreach failure, i don't need the hole process to fail, just the current iteration so i can log it.

Thanks a lot!

You may want to check FailParentOnFailure and FailPackageOnFailure properties of your inner tasks. I have not played with those but it seems like prove what you need.

Rafael Salas

|||Use an event handler.

Set the [System::Propagate] to false in an OnError handler in the inner tasks. That way, errors won't bubble up to the Foreach loop and cause it to fail.|||Thanks a lot

I used set maximum error count to a number fairly reachable, but i think it's not a good practice. I'll try your suggestions right now.

regards.|||Hello again,

I'm having the same problem, I did what you told me, on the OnError event handler I use a script where i change the Propagate variable to False. But there's a problem with the MaximumErrorCount property. Watching on the Execution Results tab, i figured out that the package fails because of the MaximumErrorCount property overpassed the foreach's number.

Well i have to say that inside the foreach Container there is a Sequence Container, and inside this one, there are 12 tasks, and i don't know if it could be stopping the package.

any suggestion?

regards.|||

I was referring to setting the OnError event handler on the failing inner tasks, however, I believe it would work just as well as on the sequence container, as long as its configured as depected.

└───ForEach
├───Sequence (<= OnError event handler here )
├───Task 1
├───Task N

On which tasks or containers is the OnError Event Handler defined?

Avoid multiple packages to run concurrently

Is there any way to avoid multiple packages to run concurrently on the same SSIS server ?

There is nothing built in to allow this (unless you can somehow restrict the number of instances of dtexec.exe that are allowed). You would have to build functionality into all your packages that (e.g.) places a zero-byte file onto the hard drive in a particular place when it starts and removes it when its finished. Each package should check to see if this file exists before it starts.

You could also check jaegd's suggestion here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1811745&SiteID=1

-Jamie

|||Thanks for your answer Jamie.

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.

Auto-updating Display

Hi,

I would like to create an application that displays the status of my machines almost real-time (Run, Down, or idle etc). And I'm wondering what is the common method to accomplish this? Do you tell the application to keep going out and getting the status of the machines at a specific interval? or Do you have a way for the application to just 'listen' if a status update is available for the specific machines? If so, how? I only have a 'Read' access to the database. Also, other applications update the database (and I don't have access to those applications.) My application will be in VB.NET. Thanks for any leads.Checking if a machine is up or down or it's status is not related to your database in any way.

Most of the people I know that do this utilize ADSI or WMI to accomplish the desired effect with timers to continue to call upon the servers as necessary.

Autoshrink efficiency

Howdy folks!

I've got a database that needs to run 24/7. I'm looking into maintanence options and wanted to run the following by y'all:

Ok, I've read the MSDN "Maintaining databases" article and noticed the following statement about autoshrinking: "This technique uses almost no processor time and memory". I also searched these forums and found that many users say autoshrinking heavily lags down sql transfers. So who's right? And if it does lag transfers, by how much?

Another question I have about autoshrink is fragmentation. It would seem to me that over time solely depending on autoshrink would cripple a server in terms of fragmentation; is this the case?

Also, does autoshrink (or manual shrinking or compacting) update the statistics?

Final question!!! I'm programming in native c++, is there a way for me to run commands such as "DBCC SHRINKDATABASE" in native OLE DB code?

Thanks!

Autoshrink in SQL CE takes place when the last connection to the database is closed, so it has very littel effect on your app.

Autoshrink is not a replacement for CompactDatabase, so you should do that regurarly (every 14 days in ceonnection with sync process, for example)

Statistics: Most likely...yes

the native interface exposes CompactDatabase on an Engine object, see this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1934047&SiteID=1

|||Thanks for the reply Erik!

One more question...if I insert 1000 rows, delete all but 50, then insert 950 more, will my filesize stay consistant to just inserting 1000 rows?

In other words, are deleted rows replaced when inserting new rows?
|||No, used pages are not reclaimed, that is why there are features like "auto shrink" and CompactDatabase

auto-shrink create tran-log in the db?

Hi,
One of my db was set to 'auto-shrink'. Is there a set
time for 'auto-shrink' to run every day?
And, when the auto-shrink runs, will it create a large
amount of tran-logs in the db?
thanks a ton.
JJ> One of my db was set to 'auto-shrink'. Is there a set
> time for 'auto-shrink' to run every day?
Every 30 minutes!
> And, when the auto-shrink runs, will it create a large
> amount of tran-logs in the db?
Yes.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:048301c3aa30$caf5bbc0$a301280a@.phx.gbl...
> Hi,
> One of my db was set to 'auto-shrink'. Is there a set
> time for 'auto-shrink' to run every day?
> And, when the auto-shrink runs, will it create a large
> amount of tran-logs in the db?
> thanks a ton.
> JJ