hot backup: sp3

Showing posts with label sp3. Show all posts

Friday, March 23, 2012

How can I back up to a device with out over writing the last backu

I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
database's to a device,,which works fine but it over writes the files in the
directory. The code i am using is
BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD , NAME = N'my backup', NOSKIP , STATS = 10, NOFORMAT
Can anyone please help me with this, I tried using a mapped drive but that
does not work. Is there any way I can use a maint plan to back up to a device
and not over write the last back up file? in the use this directory can I use
the unc?It WILL overwrite the old since you give same name to the backup file. You
must figure out another way to work for you. My backup will write to a
folder depend on what day of the week. So I always have a 7 days of backup.
hth,
"DAVID S" <DAVIDS@.discussions.microsoft.com> wrote in message
news:254A39AA-C621-43B9-A12B-78AFCBF23F8F@.microsoft.com...
>I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
> database's to a device,,which works fine but it over writes the files in
> the
> directory. The code i am using is
> BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD , NAME => N'my backup', NOSKIP , STATS = 10, NOFORMAT
> Can anyone please help me with this, I tried using a mapped drive but that
> does not work. Is there any way I can use a maint plan to back up to a
> device
> and not over write the last back up file? in the use this directory can I
> use
> the unc?
>|||The answer to my question is yes you can use the unc path in the use this
dircetory. but I still don't know about the device over write problem.
"DAVID S" wrote:
> I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
> database's to a device,,which works fine but it over writes the files in the
> directory. The code i am using is
> BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD , NAME => N'my backup', NOSKIP , STATS = 10, NOFORMAT
> Can anyone please help me with this, I tried using a mapped drive but that
> does not work. Is there any way I can use a maint plan to back up to a device
> and not over write the last back up file? in the use this directory can I use
> the unc?
>|||Have you thought of using RETAINDAYS parameter in your backup statement.
Check BOL...
Thanks
GYK
"DAVID S" wrote:
> The answer to my question is yes you can use the unc path in the use this
> dircetory. but I still don't know about the device over write problem.
> "DAVID S" wrote:
> > I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
> > database's to a device,,which works fine but it over writes the files in the
> > directory. The code i am using is
> >
> > BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD , NAME => > N'my backup', NOSKIP , STATS = 10, NOFORMAT
> >
> > Can anyone please help me with this, I tried using a mapped drive but that
> > does not work. Is there any way I can use a maint plan to back up to a device
> > and not over write the last back up file? in the use this directory can I use
> > the unc?
> >
> >|||Yes and it did not work.. but thank you for responding
"GYK" wrote:
> Have you thought of using RETAINDAYS parameter in your backup statement.
> Check BOL...
> Thanks
> GYK
> "DAVID S" wrote:
> > The answer to my question is yes you can use the unc path in the use this
> > dircetory. but I still don't know about the device over write problem.
> >
> > "DAVID S" wrote:
> >
> > > I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
> > > database's to a device,,which works fine but it over writes the files in the
> > > directory. The code i am using is
> > >
> > > BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD , NAME => > > N'my backup', NOSKIP , STATS = 10, NOFORMAT
> > >
> > > Can anyone please help me with this, I tried using a mapped drive but that
> > > does not work. Is there any way I can use a maint plan to back up to a device
> > > and not over write the last back up file? in the use this directory can I use
> > > the unc?
> > >
> > >|||Try removing the name = N'my backup'... leave it blank and try...
Thanks
GYK
"DAVID S" wrote:
> Yes and it did not work.. but thank you for responding
> "GYK" wrote:
> > Have you thought of using RETAINDAYS parameter in your backup statement.
> > Check BOL...
> >
> > Thanks
> > GYK
> >
> > "DAVID S" wrote:
> >
> > > The answer to my question is yes you can use the unc path in the use this
> > > dircetory. but I still don't know about the device over write problem.
> > >
> > > "DAVID S" wrote:
> > >
> > > > I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
> > > > database's to a device,,which works fine but it over writes the files in the
> > > > directory. The code i am using is
> > > >
> > > > BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD , NAME => > > > N'my backup', NOSKIP , STATS = 10, NOFORMAT
> > > >
> > > > Can anyone please help me with this, I tried using a mapped drive but that
> > > > does not work. Is there any way I can use a maint plan to back up to a device
> > > > and not over write the last back up file? in the use this directory can I use
> > > > the unc?
> > > >
> > > >|||NOINIT means append and INIT means overwrite. Your statement posted will append.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"DAVID S" <DAVIDS@.discussions.microsoft.com> wrote in message
news:254A39AA-C621-43B9-A12B-78AFCBF23F8F@.microsoft.com...
>I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
> database's to a device,,which works fine but it over writes the files in the
> directory. The code i am using is
> BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD , NAME => N'my backup', NOSKIP , STATS = 10, NOFORMAT
> Can anyone please help me with this, I tried using a mapped drive but that
> does not work. Is there any way I can use a maint plan to back up to a device
> and not over write the last back up file? in the use this directory can I use
> the unc?
>

Monday, March 19, 2012

How can a spid block himself.

SQL2K sp3.
Ive got some DB blocking going on and a couple of times now I see that a
spid is blocked by himself. How can this happen?
TIA, ChrisR
See if this helps.
The blocked column in the sysprocesses table is populated for latch waits
after you install SQL Server 2000 SP4
http://support.microsoft.com/?id=906344
AMB
"ChrisR" wrote:

> SQL2K sp3.
> Ive got some DB blocking going on and a couple of times now I see that a
> spid is blocked by himself. How can this happen?
> TIA, ChrisR
|||Thanks, but as indicated, I have sp3.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> See if this helps.
> The blocked column in the sysprocesses table is populated for latch waits
> after you install SQL Server 2000 SP4
> http://support.microsoft.com/?id=906344
>
> AMB
> "ChrisR" wrote:

How can a spid block himself.

SQL2K sp3.
Ive got some DB blocking going on and a couple of times now I see that a
spid is blocked by himself. How can this happen?
TIA, ChrisRSee if this helps.
The blocked column in the sysprocesses table is populated for latch waits
after you install SQL Server 2000 SP4
http://support.microsoft.com/?id=906344
AMB
"ChrisR" wrote:

> SQL2K sp3.
> Ive got some DB blocking going on and a couple of times now I see that a
> spid is blocked by himself. How can this happen?
> TIA, ChrisR|||Thanks, but as indicated, I have sp3.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> See if this helps.
> The blocked column in the sysprocesses table is populated for latch waits
> after you install SQL Server 2000 SP4
> http://support.microsoft.com/?id=906344
>
> AMB
> "ChrisR" wrote:
>

How can a spid block himself.

SQL2K sp3.
Ive got some DB blocking going on and a couple of times now I see that a
spid is blocked by himself. How can this happen?
TIA, ChrisRSee if this helps.
The blocked column in the sysprocesses table is populated for latch waits
after you install SQL Server 2000 SP4
http://support.microsoft.com/?id=906344
AMB
"ChrisR" wrote:
> SQL2K sp3.
> Ive got some DB blocking going on and a couple of times now I see that a
> spid is blocked by himself. How can this happen?
> TIA, ChrisR|||Thanks, but as indicated, I have sp3.
"Alejandro Mesa" wrote:
> See if this helps.
> The blocked column in the sysprocesses table is populated for latch waits
> after you install SQL Server 2000 SP4
> http://support.microsoft.com/?id=906344
>
> AMB
> "ChrisR" wrote:
> > SQL2K sp3.
> >
> > Ive got some DB blocking going on and a couple of times now I see that a
> > spid is blocked by himself. How can this happen?
> >
> > TIA, ChrisR

Monday, March 12, 2012

How best to update a record from another record in the same table?

(SQL Server 2000, SP3)
Hello all!
I have a seemingly easy question that seems to stump me whenever I come across it, and was
hoping to get some clarification.
Consider the following:
create table Test (Id int, Value1 sysname, Value2 sysname)
go
insert into Test values (1, 'Test1', 'Another1')
insert into Test values (2, 'Test2', 'Another2')
go
I would like to update the first record with some of the fields in the second record.
Part of my confusion lies in the fact that you can't alias the table to be UPDATEd. My
first attempt looks something like this:
update Test
set Test.Value2 = Value2
from Test as t2
where Test.Id = 1
and t2.Id = 2
Which gives me the following error:
Server: Msg 107, Level 16, State 3, Line 1
The column prefix 'Test' does not match with a table name or alias name used in the query.
So I tried to remove the Test reference in the WHERE clause:
update Test
set Test.Value2 = Value2
from Test as t2
where Id = 1
and t2.Id = 2
And this gives me 0 records affected -- perhaps like it's using the t2.Id implicitly.
I could do something like this:
update Test
set Test.Value2 = (select Value2 from Test where Id = 2)
where Id = 1
And that works, but I'd hate to reference Test for as many times as I might have fields to
update in the SET clause.
I'd appreciate any pointers that anyone might be able to provide! :-)
John PetersonEither one would do...
update t1
set Value2=t2.Value2
from Test t1, Test t2
where t1.Id=1 and t2.Id=2
update t1
set Value2=t2.Value2
from Test t1 join Test t2
on t1.Id=1 and t2.Id=2
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:%23GZxFZsXDHA.2320@.TK2MSFTNGP12.phx.gbl...
> (SQL Server 2000, SP3)
> Hello all!
> I have a seemingly easy question that seems to stump me whenever I come
across it, and was
> hoping to get some clarification.
> Consider the following:
> create table Test (Id int, Value1 sysname, Value2 sysname)
> go
> insert into Test values (1, 'Test1', 'Another1')
> insert into Test values (2, 'Test2', 'Another2')
> go
> I would like to update the first record with some of the fields in the
second record.
> Part of my confusion lies in the fact that you can't alias the table to be
UPDATEd. My
> first attempt looks something like this:
> update Test
> set Test.Value2 = Value2
> from Test as t2
> where Test.Id = 1
> and t2.Id = 2
> Which gives me the following error:
> Server: Msg 107, Level 16, State 3, Line 1
> The column prefix 'Test' does not match with a table name or alias name
used in the query.
> So I tried to remove the Test reference in the WHERE clause:
> update Test
> set Test.Value2 = Value2
> from Test as t2
> where Id = 1
> and t2.Id = 2
> And this gives me 0 records affected -- perhaps like it's using the t2.Id
implicitly.
> I could do something like this:
> update Test
> set Test.Value2 = (select Value2 from Test where Id = 2)
> where Id = 1
> And that works, but I'd hate to reference Test for as many times as I
might have fields to
> update in the SET clause.
> I'd appreciate any pointers that anyone might be able to provide! :-)
> John Peterson
>|||Thanks, oj!
I didn't realize that you could do an alias after the UPDATE, and then specify the actual
table name in the FROM clause. Very interesting!
Thanks again!
John Peterson
"oj" <nospam_ojngo@.home.com> wrote in message
news:%23Ya0TdsXDHA.652@.TK2MSFTNGP10.phx.gbl...
> Either one would do...
> update t1
> set Value2=t2.Value2
> from Test t1, Test t2
> where t1.Id=1 and t2.Id=2
> update t1
> set Value2=t2.Value2
> from Test t1 join Test t2
> on t1.Id=1 and t2.Id=2
>
> --
> -oj
> RAC v2.2 & QALite!
> http://www.rac4sql.net
>
> "John Peterson" <j0hnp@.comcast.net> wrote in message
> news:%23GZxFZsXDHA.2320@.TK2MSFTNGP12.phx.gbl...
> > (SQL Server 2000, SP3)
> >
> > Hello all!
> >
> > I have a seemingly easy question that seems to stump me whenever I come
> across it, and was
> > hoping to get some clarification.
> >
> > Consider the following:
> >
> > create table Test (Id int, Value1 sysname, Value2 sysname)
> > go
> >
> > insert into Test values (1, 'Test1', 'Another1')
> > insert into Test values (2, 'Test2', 'Another2')
> > go
> >
> > I would like to update the first record with some of the fields in the
> second record.
> >
> > Part of my confusion lies in the fact that you can't alias the table to be
> UPDATEd. My
> > first attempt looks something like this:
> >
> > update Test
> > set Test.Value2 = Value2
> > from Test as t2
> > where Test.Id = 1
> > and t2.Id = 2
> >
> > Which gives me the following error:
> >
> > Server: Msg 107, Level 16, State 3, Line 1
> > The column prefix 'Test' does not match with a table name or alias name
> used in the query.
> >
> > So I tried to remove the Test reference in the WHERE clause:
> >
> > update Test
> > set Test.Value2 = Value2
> > from Test as t2
> > where Id = 1
> > and t2.Id = 2
> >
> > And this gives me 0 records affected -- perhaps like it's using the t2.Id
> implicitly.
> >
> > I could do something like this:
> >
> > update Test
> > set Test.Value2 = (select Value2 from Test where Id = 2)
> > where Id = 1
> >
> > And that works, but I'd hate to reference Test for as many times as I
> might have fields to
> > update in the SET clause.
> >
> > I'd appreciate any pointers that anyone might be able to provide! :-)
> >
> > John Peterson
> >
> >
>|||You're welcome, John.
I believe you can find the example and some info regarding this syntax in
sql book online under "update".
--
-oj
Rac v2.2 & QALite
http://www.rac4sql.net
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:O9fn6fsXDHA.2204@.TK2MSFTNGP12.phx.gbl...
> Thanks, oj!
> I didn't realize that you could do an alias after the UPDATE, and then
specify the actual
> table name in the FROM clause. Very interesting!
> Thanks again!
> John Peterson
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:%23Ya0TdsXDHA.652@.TK2MSFTNGP10.phx.gbl...
> > Either one would do...
> >
> > update t1
> > set Value2=t2.Value2
> > from Test t1, Test t2
> > where t1.Id=1 and t2.Id=2
> >
> > update t1
> > set Value2=t2.Value2
> > from Test t1 join Test t2
> > on t1.Id=1 and t2.Id=2
> >
> >
> >
> > --
> > -oj
> > RAC v2.2 & QALite!
> > http://www.rac4sql.net
> >
> >
> >
> > "John Peterson" <j0hnp@.comcast.net> wrote in message
> > news:%23GZxFZsXDHA.2320@.TK2MSFTNGP12.phx.gbl...
> > > (SQL Server 2000, SP3)
> > >
> > > Hello all!
> > >
> > > I have a seemingly easy question that seems to stump me whenever I
come
> > across it, and was
> > > hoping to get some clarification.
> > >
> > > Consider the following:
> > >
> > > create table Test (Id int, Value1 sysname, Value2 sysname)
> > > go
> > >
> > > insert into Test values (1, 'Test1', 'Another1')
> > > insert into Test values (2, 'Test2', 'Another2')
> > > go
> > >
> > > I would like to update the first record with some of the fields in the
> > second record.
> > >
> > > Part of my confusion lies in the fact that you can't alias the table
to be
> > UPDATEd. My
> > > first attempt looks something like this:
> > >
> > > update Test
> > > set Test.Value2 = Value2
> > > from Test as t2
> > > where Test.Id = 1
> > > and t2.Id = 2
> > >
> > > Which gives me the following error:
> > >
> > > Server: Msg 107, Level 16, State 3, Line 1
> > > The column prefix 'Test' does not match with a table name or alias
name
> > used in the query.
> > >
> > > So I tried to remove the Test reference in the WHERE clause:
> > >
> > > update Test
> > > set Test.Value2 = Value2
> > > from Test as t2
> > > where Id = 1
> > > and t2.Id = 2
> > >
> > > And this gives me 0 records affected -- perhaps like it's using the
t2.Id
> > implicitly.
> > >
> > > I could do something like this:
> > >
> > > update Test
> > > set Test.Value2 = (select Value2 from Test where Id = 2)
> > > where Id = 1
> > >
> > > And that works, but I'd hate to reference Test for as many times as I
> > might have fields to
> > > update in the SET clause.
> > >
> > > I'd appreciate any pointers that anyone might be able to provide! :-)
> > >
> > > John Peterson
> > >
> > >
> >
> >
>

Monday, February 27, 2012

hotfixes - general question

Whaer can I get a list of the hotfixes/interim builds etc
post sp3(a).
TIA,
JBHave a look at :
http://support.microsoft.com/common/canned.aspx?r=d&h=microsoft%20sql%20server%202000%20post-sp3%20hotfixes&ll=&sz=kbsqlserv2000presp4fix&fr=&du=&sd=gn&ln=en-us&cnd=1&vr=&cat=&vrl=&sg=&maxresults=20
Rgds,
Paul Ibison (SQL Server MVP)

Friday, February 24, 2012

Hotfix 2187 for SP4

If I Upgrade from SP3 ( 8.00.818 ) to SP4 (8.00.2039 ) and then apply hotfix
( 8.00.2187 ) will we be completely up to date with Sql Server patches ?Hi
"Bil" wrote:

> If I Upgrade from SP3 ( 8.00.818 ) to SP4 (8.00.2039 ) and then apply hotf
ix
> ( 8.00.2187 ) will we be completely up to date with Sql Server patches ?
>
AFAIK that was the last hotfix that was generally available
[url]http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx[/ur
l] shows there were some more available from PSS
John

Hotfix 2187 for SP4

If I Upgrade from SP3 ( 8.00.818 ) to SP4 (8.00.2039 ) and then apply hotfix
( 8.00.2187 ) will we be completely up to date with Sql Server patches ?
Hi
"Bil" wrote:

> If I Upgrade from SP3 ( 8.00.818 ) to SP4 (8.00.2039 ) and then apply hotfix
> ( 8.00.2187 ) will we be completely up to date with Sql Server patches ?
>
AFAIK that was the last hotfix that was generally available
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx shows there were some more available from PSS
John

Hotfix 2187 for SP4

If I Upgrade from SP3 ( 8.00.818 ) to SP4 (8.00.2039 ) and then apply hotfix
( 8.00.2187 ) will we be completely up to date with Sql Server patches ?Hi
"Bil" wrote:
> If I Upgrade from SP3 ( 8.00.818 ) to SP4 (8.00.2039 ) and then apply hotfix
> ( 8.00.2187 ) will we be completely up to date with Sql Server patches ?
>
AFAIK that was the last hotfix that was generally available
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx shows there were some more available from PSS
John

hot fixes

Are there any fixes that I need to apply after applying sp3 or sp3a or I
should wait for sp4.
yes . . .roll up hotfix 826161 to bring minor version to 818/819
"SB138" wrote:

> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.
|||Definitely.
http://support.microsoft.com/?kbid=821277
http://www.aspfaq.com/
(Reverse address to reply.)
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:257396DF-80D6-4DFF-9F9B-76D8D7D4A275@.microsoft.com...
> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.
|||and u can sign up for sp4 beta if intrested :
http://support.microsoft.com/kb/290211
Andy.
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:257396DF-80D6-4DFF-9F9B-76D8D7D4A275@.microsoft.com...
> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.

hot fixes

Are there any fixes that I need to apply after applying sp3 or sp3a or I
should wait for sp4.yes . . .roll up hotfix 826161 to bring minor version to 818/819
"SB138" wrote:

> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.|||Definitely.
http://support.microsoft.com/?kbid=821277
http://www.aspfaq.com/
(Reverse address to reply.)
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:257396DF-80D6-4DFF-9F9B-76D8D7D4A275@.microsoft.com...
> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.|||and u can sign up for sp4 beta if intrested :
http://support.microsoft.com/kb/290211
Andy.
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:257396DF-80D6-4DFF-9F9B-76D8D7D4A275@.microsoft.com...
> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.

Sunday, February 19, 2012

hot fixes

Are there any fixes that I need to apply after applying sp3 or sp3a or I
should wait for sp4.yes . . .roll up hotfix 826161 to bring minor version to 818/819
"SB138" wrote:
> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.|||Definitely.
http://support.microsoft.com/?kbid=821277
--
http://www.aspfaq.com/
(Reverse address to reply.)
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:257396DF-80D6-4DFF-9F9B-76D8D7D4A275@.microsoft.com...
> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.|||and u can sign up for sp4 beta if intrested :
http://support.microsoft.com/kb/290211
Andy.
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:257396DF-80D6-4DFF-9F9B-76D8D7D4A275@.microsoft.com...
> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.

Friday, March 23, 2012

How can I back up to a device with out over writing the last backu

How can I back up to a device with out over writing the last backu

How can I back up to a device with out over writing the last backu

Monday, March 19, 2012

How can a spid block himself.

How can a spid block himself.

How can a spid block himself.

Monday, March 12, 2012

How best to update a record from another record in the same table?

Monday, February 27, 2012

hotfixes - general question

Friday, February 24, 2012

Hotfix 2187 for SP4

Hotfix 2187 for SP4

Hotfix 2187 for SP4

hot fixes

hot fixes

Sunday, February 19, 2012

hot fixes

hot backup

Blog Archive

About Me