Showing posts with label enterprise. Show all posts
Showing posts with label enterprise. Show all posts

Monday, March 19, 2012

A Timeout Occurs When a Database Is Automatically Expanding

Article ID : 305635
Last Review : December 2, 2005
Revision : 3.1
http://support.microsoft.com/kb/305635/
I have SQL Server 2000 Enterprise Edition and have the some reported issue
in the above article, the article says that it applies to Standard Edition,
does it mean that itâ's not the same problem I have?
Hope some one can answer me quickly..
ThanksThe article applies to all SQL 2000 editions. Timeout's occur on the client
side and it can take time for SQL Server to expand files regardless of the
SQL Server 2000 edition.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Murad Hashem" <Murad Hashem@.discussions.microsoft.com> wrote in message
news:87A2DAEE-5CEA-44C8-BFDD-B726955FADE8@.microsoft.com...
> Article ID : 305635
> Last Review : December 2, 2005
> Revision : 3.1
> http://support.microsoft.com/kb/305635/
> I have SQL Server 2000 Enterprise Edition and have the some reported issue
> in the above article, the article says that it applies to Standard
> Edition,
> does it mean that it's not the same problem I have?
> Hope some one can answer me quickly..
> Thanks
>|||Murad
As an aside to your existing problem. You would be better off controlling
the growth of your database manually.
Auto grow is good as a fall back but a better way is to monitor your
database growth and anticpate your growth requirements before they occurr.
That way you can allocate an amount of extra space that will be sufficiant
for 9 to 12 months (disk space allowing of course) rather than a typical 10%
(or similar) that people tend to use for auto grow.
Databases using auto grow typically tend to grow more regularly than
databases that are monitored and manually increased. This can mean
fragmentation at the disk level, that can lead to bad performance. Also if
you do it manually you can schedule it at a quite time, not in the middle of
your business day, which always seems to happen with autogrow. Doing outside
your main business hours will reduce the impact on your users.
Another thing is to have an archive strategy for all your databases. I work
for a large bank and we will not let a database go into production if it does
not have an archive strategy. Do this with your systems and after the first
year or two, you rarely (or in some cases never) have to expand your
databases again.
HTH
John
"Murad Hashem" wrote:
> Article ID : 305635
> Last Review : December 2, 2005
> Revision : 3.1
> http://support.microsoft.com/kb/305635/
> I have SQL Server 2000 Enterprise Edition and have the some reported issue
> in the above article, the article says that it applies to Standard Edition,
> does it mean that itâ's not the same problem I have?
> Hope some one can answer me quickly..
> Thanks
>

A Timeout Occurs When a Database Is Automatically Expanding

Article ID : 305635
Last Review : December 2, 2005
Revision : 3.1
http://support.microsoft.com/kb/305635/
I have SQL Server 2000 Enterprise Edition and have the some reported issue
in the above article, the article says that it applies to Standard Edition,
does it mean that it’s not the same problem I have?
Hope some one can answer me quickly..
Thanks
The article applies to all SQL 2000 editions. Timeout's occur on the client
side and it can take time for SQL Server to expand files regardless of the
SQL Server 2000 edition.
Hope this helps.
Dan Guzman
SQL Server MVP
"Murad Hashem" <Murad Hashem@.discussions.microsoft.com> wrote in message
news:87A2DAEE-5CEA-44C8-BFDD-B726955FADE8@.microsoft.com...
> Article ID : 305635
> Last Review : December 2, 2005
> Revision : 3.1
> http://support.microsoft.com/kb/305635/
> I have SQL Server 2000 Enterprise Edition and have the some reported issue
> in the above article, the article says that it applies to Standard
> Edition,
> does it mean that it's not the same problem I have?
> Hope some one can answer me quickly..
> Thanks
>
|||Murad
As an aside to your existing problem. You would be better off controlling
the growth of your database manually.
Auto grow is good as a fall back but a better way is to monitor your
database growth and anticpate your growth requirements before they occurr.
That way you can allocate an amount of extra space that will be sufficiant
for 9 to 12 months (disk space allowing of course) rather than a typical 10%
(or similar) that people tend to use for auto grow.
Databases using auto grow typically tend to grow more regularly than
databases that are monitored and manually increased. This can mean
fragmentation at the disk level, that can lead to bad performance. Also if
you do it manually you can schedule it at a quite time, not in the middle of
your business day, which always seems to happen with autogrow. Doing outside
your main business hours will reduce the impact on your users.
Another thing is to have an archive strategy for all your databases. I work
for a large bank and we will not let a database go into production if it does
not have an archive strategy. Do this with your systems and after the first
year or two, you rarely (or in some cases never) have to expand your
databases again.
HTH
John
"Murad Hashem" wrote:

> Article ID : 305635
> Last Review : December 2, 2005
> Revision : 3.1
> http://support.microsoft.com/kb/305635/
> I have SQL Server 2000 Enterprise Edition and have the some reported issue
> in the above article, the article says that it applies to Standard Edition,
> does it mean that it’s not the same problem I have?
> Hope some one can answer me quickly..
> Thanks
>

A Timeout Occurs When a Database Is Automatically Expanding

Article ID : 305635
Last Review : December 2, 2005
Revision : 3.1
http://support.microsoft.com/kb/305635/
I have SQL Server 2000 Enterprise Edition and have the some reported issue
in the above article, the article says that it applies to Standard Edition,
does it mean that it’s not the same problem I have?
Hope some one can answer me quickly..
ThanksThe article applies to all SQL 2000 editions. Timeout's occur on the client
side and it can take time for SQL Server to expand files regardless of the
SQL Server 2000 edition.
Hope this helps.
Dan Guzman
SQL Server MVP
"Murad Hashem" <Murad Hashem@.discussions.microsoft.com> wrote in message
news:87A2DAEE-5CEA-44C8-BFDD-B726955FADE8@.microsoft.com...
> Article ID : 305635
> Last Review : December 2, 2005
> Revision : 3.1
> http://support.microsoft.com/kb/305635/
> I have SQL Server 2000 Enterprise Edition and have the some reported issue
> in the above article, the article says that it applies to Standard
> Edition,
> does it mean that it's not the same problem I have?
> Hope some one can answer me quickly..
> Thanks
>|||Murad
As an aside to your existing problem. You would be better off controlling
the growth of your database manually.
Auto grow is good as a fall back but a better way is to monitor your
database growth and anticpate your growth requirements before they occurr.
That way you can allocate an amount of extra space that will be sufficiant
for 9 to 12 months (disk space allowing of course) rather than a typical 10%
(or similar) that people tend to use for auto grow.
Databases using auto grow typically tend to grow more regularly than
databases that are monitored and manually increased. This can mean
fragmentation at the disk level, that can lead to bad performance. Also if
you do it manually you can schedule it at a quite time, not in the middle of
your business day, which always seems to happen with autogrow. Doing outside
your main business hours will reduce the impact on your users.
Another thing is to have an archive strategy for all your databases. I work
for a large bank and we will not let a database go into production if it doe
s
not have an archive strategy. Do this with your systems and after the first
year or two, you rarely (or in some cases never) have to expand your
databases again.
HTH
John
"Murad Hashem" wrote:

> Article ID : 305635
> Last Review : December 2, 2005
> Revision : 3.1
> http://support.microsoft.com/kb/305635/
> I have SQL Server 2000 Enterprise Edition and have the some reported issue
> in the above article, the article says that it applies to Standard Edition
,
> does it mean that it’s not the same problem I have?
> Hope some one can answer me quickly..
> Thanks
>

a table/column to table/column data check (was "Help Please, SQL something Simpl

Hi all, I am not over familiar with SQL, I am a VB programmer, simply I need to achieve the following within Enterprise Manager.

I have 2 tables, different designs, different number of rows, I simply need to check whether the contents of a column in the first table is in a column in the second table, just simply a table/column to table/column data check for the same data content.

Easy Peasy for you guys, any help would be appreciated.Hi all, I am not over familiar with SQL, I am a VB programmer, simply I need to achieve the following within Enterprise Manager.

I have 2 tables, different designs, different number of rows, I simply need to check whether the contents of a column in the first table is in a column in the second table, just simply a table/column to table/column data check for the same data content.

Easy Peasy for you guys, any help would be appreciated.

Welcome to the forum,ok here is your solution

CREATE TABLE t1(
col1 VARCHAR(20)
,col2 VARCHAR(20)
,col3 VARCHAR(20)
)

CREATE TABLE t2(
col4 VARCHAR(20)
,col5 VARCHAR(20)
)

The sql statement to check content of a col1 is in col4 or not...

SELECT * FROM
t1,t2
WHERE t1.col1=t2.col4|||Many thanks, will give it a try a wee bit later and post result.

Many thanks...|||Hi, this appears to work fine, however if I change the logic to check what is not in table2 it appears to go into a endless loop, any help appreciated.|||Hi, sorry after further testing, I may not have explained myself very well, apologies, I need to access row1 of table1 and then scan column2 in table2, the entire table, for the occurence of the data item in row1 table1.

Many thanks in anticipation.|||Hi, this appears to work fine, however if I change the logic to check what is not in table2 it appears to go into a endless loop, any help appreciated.
Test it ...

insert into t1 values('joy','datta','harry')
insert into t1 values('Pink','datta56','harry2')
insert into t1 values('Sheep','datta5','harry3')
insert into t1 values('Ghree','datta11','harry5')

insert into t2 values('Sheep','datta5')
insert into t2 values('Ghree','datta11')

SELECT * FROM
t1
WHERE t1.col1 NOT IN(SELECT t2.col5 FROM t2)|||Thanks sorted..

Tuesday, March 6, 2012

A red X appears over the 'replicator monitor'

Using the 'SQL Server Enterprise Manager' before selecting 'push new
subsription' a red X appears over the 'replicator monitor'. I noted the red
cross appears over the folder 'merge agents'. If I look at the 'error
details of the merge agent' it says 'The process could not drop one or more
tables because the tables are being used by other publications.'. The thing
is, I'm not dropping any table, just trying to replicate a table between 3
databases. Why does this error happen?
Thnx for your time
Martin
Martin,
have a look at the tables on the subscriber. It is possible that you are
publishing an article to a subscriber that is itself publishing the article.
By default, replication will try to drop the tabl;e on the subscriber but
will be prevented from doing so. If the error message doesn't mention the
tablename, have a look at: http://support.microsoft.com/?id=312292
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||If Paul's suggestion does not help, it could be that the tables on the
subsciber are inadvertly makrked as replicated. IF the subscribing database
had at one time set up for replication or if the database has been restored
from another server where the database was published, this can happen.
If this is the case then you can use the steps in the following article to
resolve the problem:
PRB: You receive error 3724 when you drop a non-replicated object
http://support.microsoft.com/default.aspx?scid=KB;[LN];326352
Rand
This posting is provided "as is" with no warranties and confers no rights.

Saturday, February 25, 2012

a question for setup experts please

hello,
i have sql server 2000 on my local machine (with enterprise manager etc).
i want to host a website (on a dedicated server) which talks to sql server,
but i dont want to buy another license for the server machine that i am
going to host on (too much money!).
my question is:
is there a way around this? ie: is there a free engine or something that i
can install on my webserver which just stores the datafiles so my webpages
will work.
ideally i would like to DTS data to and from the live server, and also use
my local enterprise manager to view/update data on the live server?
is this possible?
thanksDepending on your requirements, you could deploy MSDE.
Not sure what this has to do with alt.photography though...
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
> hello,
> i have sql server 2000 on my local machine (with enterprise manager etc).
> i want to host a website (on a dedicated server) which talks to sql
server,
> but i dont want to buy another license for the server machine that i am
> going to host on (too much money!).
> my question is:
> is there a way around this? ie: is there a free engine or something that
i
> can install on my webserver which just stores the datafiles so my webpages
> will work.
> ideally i would like to DTS data to and from the live server, and also use
> my local enterprise manager to view/update data on the live server?
> is this possible?
> thanks
>|||lol, yeah the alt.photography was a bit of a mistake!
Can you tell me more about MSDE please, and whether it will meet my
requirements mentioned below.
Thanks.
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> Depending on your requirements, you could deploy MSDE.
> Not sure what this has to do with alt.photography though...
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "tracy" <tracyy@.spamfreenyf.com> wrote in message
> news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
etc).
> server,
that
> i
webpages
use
>|||http://www.microsoft.com/sql/techin...eskChooseEd.asp
http://www.microsoft.com/sql/msde/
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:r5aXb.7185$ul3.128@.news-binary.blueyonder.co.uk...
> lol, yeah the alt.photography was a bit of a mistake!
> Can you tell me more about MSDE please, and whether it will meet my
> requirements mentioned below.
> Thanks.
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> etc).
am
> that
> webpages
> use
>|||You could also post specific questions to *just*
microsoft.public.sqlserver.msde
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:r5aXb.7185$ul3.128@.news-binary.blueyonder.co.uk...
> lol, yeah the alt.photography was a bit of a mistake!
> Can you tell me more about MSDE please, and whether it will meet my
> requirements mentioned below.
> Thanks.
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> etc).
am
> that
> webpages
> use
>|||If you still have questions about licensing, there are some useful links
here:
317428 INF: Where to Find Information About SQL Server Licensing
http://support.microsoft.com/?id=317428
Keep in mind that you can buy a developer edition of SQL Server for $49 to
develop your application. If the SQL Server edition you already have is
either Standard or Enterprise you could move that edition to your web
server and use the developer edition on your client. But you cannot use the
developer edition on your website.
MSDE might be legal for your web server if you have the appropriate
redistribution rights. MSDE also has some limitations on size and number of
concurrently executing queries. Check out the MSDE roadmap on MSDN as well
as the links from the KB above.
http://msdn.microsoft.com/library/d...-us/dnmsde/html
/msderoadmap.asp
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

a question for setup experts please

hello,
i have sql server 2000 on my local machine (with enterprise manager etc).
i want to host a website (on a dedicated server) which talks to sql server,
but i dont want to buy another license for the server machine that i am
going to host on (too much money!).
my question is:
is there a way around this? ie: is there a free engine or something that i
can install on my webserver which just stores the datafiles so my webpages
will work.
ideally i would like to DTS data to and from the live server, and also use
my local enterprise manager to view/update data on the live server?
is this possible?
thanksDepending on your requirements, you could deploy MSDE.
Not sure what this has to do with alt.photography though...
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
> hello,
> i have sql server 2000 on my local machine (with enterprise manager etc).
> i want to host a website (on a dedicated server) which talks to sql
server,
> but i dont want to buy another license for the server machine that i am
> going to host on (too much money!).
> my question is:
> is there a way around this? ie: is there a free engine or something that
i
> can install on my webserver which just stores the datafiles so my webpages
> will work.
> ideally i would like to DTS data to and from the live server, and also use
> my local enterprise manager to view/update data on the live server?
> is this possible?
> thanks
>|||lol, yeah the alt.photography was a bit of a mistake!
Can you tell me more about MSDE please, and whether it will meet my
requirements mentioned below.
Thanks.
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> Depending on your requirements, you could deploy MSDE.
> Not sure what this has to do with alt.photography though...
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "tracy" <tracyy@.spamfreenyf.com> wrote in message
> news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
> > hello,
> >
> > i have sql server 2000 on my local machine (with enterprise manager
etc).
> >
> > i want to host a website (on a dedicated server) which talks to sql
> server,
> > but i dont want to buy another license for the server machine that i am
> > going to host on (too much money!).
> >
> > my question is:
> > is there a way around this? ie: is there a free engine or something
that
> i
> > can install on my webserver which just stores the datafiles so my
webpages
> > will work.
> >
> > ideally i would like to DTS data to and from the live server, and also
use
> > my local enterprise manager to view/update data on the live server?
> >
> > is this possible?
> >
> > thanks
> >
> >
>|||http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp
http://www.microsoft.com/sql/msde/
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:r5aXb.7185$ul3.128@.news-binary.blueyonder.co.uk...
> lol, yeah the alt.photography was a bit of a mistake!
> Can you tell me more about MSDE please, and whether it will meet my
> requirements mentioned below.
> Thanks.
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> > Depending on your requirements, you could deploy MSDE.
> >
> > Not sure what this has to do with alt.photography though...
> >
> > --
> > Aaron Bertrand
> > SQL Server MVP
> > http://www.aspfaq.com/
> >
> >
> >
> >
> > "tracy" <tracyy@.spamfreenyf.com> wrote in message
> > news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
> > > hello,
> > >
> > > i have sql server 2000 on my local machine (with enterprise manager
> etc).
> > >
> > > i want to host a website (on a dedicated server) which talks to sql
> > server,
> > > but i dont want to buy another license for the server machine that i
am
> > > going to host on (too much money!).
> > >
> > > my question is:
> > > is there a way around this? ie: is there a free engine or something
> that
> > i
> > > can install on my webserver which just stores the datafiles so my
> webpages
> > > will work.
> > >
> > > ideally i would like to DTS data to and from the live server, and also
> use
> > > my local enterprise manager to view/update data on the live server?
> > >
> > > is this possible?
> > >
> > > thanks
> > >
> > >
> >
> >
>|||You could also post specific questions to *just*
microsoft.public.sqlserver.msde
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:r5aXb.7185$ul3.128@.news-binary.blueyonder.co.uk...
> lol, yeah the alt.photography was a bit of a mistake!
> Can you tell me more about MSDE please, and whether it will meet my
> requirements mentioned below.
> Thanks.
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> > Depending on your requirements, you could deploy MSDE.
> >
> > Not sure what this has to do with alt.photography though...
> >
> > --
> > Aaron Bertrand
> > SQL Server MVP
> > http://www.aspfaq.com/
> >
> >
> >
> >
> > "tracy" <tracyy@.spamfreenyf.com> wrote in message
> > news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
> > > hello,
> > >
> > > i have sql server 2000 on my local machine (with enterprise manager
> etc).
> > >
> > > i want to host a website (on a dedicated server) which talks to sql
> > server,
> > > but i dont want to buy another license for the server machine that i
am
> > > going to host on (too much money!).
> > >
> > > my question is:
> > > is there a way around this? ie: is there a free engine or something
> that
> > i
> > > can install on my webserver which just stores the datafiles so my
> webpages
> > > will work.
> > >
> > > ideally i would like to DTS data to and from the live server, and also
> use
> > > my local enterprise manager to view/update data on the live server?
> > >
> > > is this possible?
> > >
> > > thanks
> > >
> > >
> >
> >
>

a question for setup experts please

hello,
i have sql server 2000 on my local machine (with enterprise manager etc).
i want to host a website (on a dedicated server) which talks to sql server,
but i dont want to buy another license for the server machine that i am
going to host on (too much money!).
my question is:
is there a way around this? ie: is there a free engine or something that i
can install on my webserver which just stores the datafiles so my webpages
will work.
ideally i would like to DTS data to and from the live server, and also use
my local enterprise manager to view/update data on the live server?
is this possible?
thanksDepending on your requirements, you could deploy MSDE.
Not sure what this has to do with alt.photography though...
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
> hello,
> i have sql server 2000 on my local machine (with enterprise manager etc).
> i want to host a website (on a dedicated server) which talks to sql
server,
> but i dont want to buy another license for the server machine that i am
> going to host on (too much money!).
> my question is:
> is there a way around this? ie: is there a free engine or something that
i
> can install on my webserver which just stores the datafiles so my webpages
> will work.
> ideally i would like to DTS data to and from the live server, and also use
> my local enterprise manager to view/update data on the live server?
> is this possible?
> thanks
>|||lol, yeah the alt.photography was a bit of a mistake!
Can you tell me more about MSDE please, and whether it will meet my
requirements mentioned below.
Thanks.
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> Depending on your requirements, you could deploy MSDE.
> Not sure what this has to do with alt.photography though...
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "tracy" <tracyy@.spamfreenyf.com> wrote in message
> news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
etc).
> server,
that
> i
webpages
use
>|||http://www.microsoft.com/sql/techin...eskChooseEd.asp
http://www.microsoft.com/sql/msde/
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:r5aXb.7185$ul3.128@.news-binary.blueyonder.co.uk...
> lol, yeah the alt.photography was a bit of a mistake!
> Can you tell me more about MSDE please, and whether it will meet my
> requirements mentioned below.
> Thanks.
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> etc).
am
> that
> webpages
> use
>|||You could also post specific questions to *just*
microsoft.public.sqlserver.msde
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:r5aXb.7185$ul3.128@.news-binary.blueyonder.co.uk...
> lol, yeah the alt.photography was a bit of a mistake!
> Can you tell me more about MSDE please, and whether it will meet my
> requirements mentioned below.
> Thanks.
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> etc).
am
> that
> webpages
> use
>

Thursday, February 16, 2012

A previous restore operation was interrupted and did not complete processing on file

Hi

I am new to Forum. So not sure if i am posting my problem uner the right topic.

We have a sql server 2005 enterprise edition 4 way cluster on windows 2003 advance server.

I am logshipping these database to a different server at a different location.

My logshipping went fine until one the cluster server failed and the server instance failed over to another node.

The backup that happened around that time got copied over to the secondary by the copy job.

The log file that got copied to the secondary server tried restoring and i think it failed int he middle of restoring it.

(You would think that the sql would knoe if the backup is in complete and will move on to the next file. Not sure what happened there.)

There is no indication of the *.TUF file in the directory where i have the log files.

I tried restoring it manually and i got the following error

Msg 4319, Level 16, State 3, Line 1

A previous restore operation was interrupted and did not complete processing on file 'sessionlog1'. Either restore the backup set that was interrupted or restart the restore sequence.

Msg 3013, Level 16, State 1, Line 1

RESTORE LOG is terminating abnormally.

I looked in the msdb..log_shipping_secondary_databases and looked for the last file that it restored and tried restoring it again with the following restore command by removing and adding some of the keywords that you see after the "WITH" clause.

MSFT do not recommand to use continne_after_error unless its absolutley necessary. I stilll get the above error.

restore log sessiondata

from disk = 'I:\sql13qasm\logs\sessiondata\sessiondata_20070901124516.trn'

with restart, CONTINUE_AFTER_ERROR, norecovery

When i add the restart int he with clause,

The restart-checkpoint file 'J:\Microsoft SQL Server\MSSQL.5\MSSQL\Backup\sessiondata.CKP' was not found. The RESTORE command will continue from the beginning as if RESTART had not been specified.

Msg 4319, Level 16, State 1, Line 1

A previous restore operation was interrupted and did not complete processing on file 'sessionlog1'. Either restore the backup set that was interrupted or restart the restore sequence.

Msg 3013, Level 16, State 1, Line 1

RESTORE LOG is terminating abnormally.

I checked it the backup directory and i can't locate the .CKP file.

Does anyone ever come accross this issue?

Is there anyother way i could recover this DB in a standby or norecovery mode.

Any kind of help to resolve this issue (beside copy the full backup and redo the whole log-shipping process again) would be appreciated. sicne my primary and secondary server are totally ina different location, i need to ship a tape, if i need a full backup. This is the 3rd time its happening on that cluster. its frustrating to ship a tape everytime this happens.

I think the log backup chain has been broken. Try doing a differential and log backup and restoring those on the secondary. If that doesn't work I think you'll need to go the full backup route again.

I'm not an expert on log shipping though - maybe someone else can chime in here?

|||

I can't take a differential now, since full back job happened already, after the failure.

:-S

A point in time backup with SQL Server 2000 Enterprise Manager

I'm having a problem testing a point in time backup. Here
is what I was trying:
1) I created a complete database backup to a file
D:\TEMP.DAT (of a database named
PHCS) (Time - 10:45)
2) I went and made some changes to the PHCS database at
10:49:10
3) I went and made some more changes to the PHCS database
at 10:50:50
4) I backed up the transaction log database (also into
D:\TEMP.DAT, appending).
(Time - 10:52)
5) I went to restore the database backed up at 10:45 and
left it unoperational
6) I went to restore the transaction log created at 10:52
and tried to specify a time
of 10:50:00. I wanted to restore the changes made in step
2, but not step 3.
He restore me the hole last transaction log i selected
an don't stop between step 2 and 3 !!
Many thanks for your help
DanielDid you use STOPAT..?
Here's the example from SQL BOL
-- Restore the database backup.
RESTORE DATABASE MyNwind
FROM MyNwind_1, MyNwind_2
WITH NORECOVERY
GO
RESTORE LOG MyNwind
FROM MyNwind_log1
WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
GO
HTH
Ryan Waight, MCDBA, MCSE
"Ischi" <daniel_ischi@.hotmail.com> wrote in message
news:0def01c38d87$06a78890$a101280a@.phx.gbl...
> I'm having a problem testing a point in time backup. Here
> is what I was trying:
> 1) I created a complete database backup to a file
> D:\TEMP.DAT (of a database named
> PHCS) (Time - 10:45)
> 2) I went and made some changes to the PHCS database at
> 10:49:10
> 3) I went and made some more changes to the PHCS database
> at 10:50:50
> 4) I backed up the transaction log database (also into
> D:\TEMP.DAT, appending).
> (Time - 10:52)
> 5) I went to restore the database backed up at 10:45 and
> left it unoperational
> 6) I went to restore the transaction log created at 10:52
> and tried to specify a time
> of 10:50:00. I wanted to restore the changes made in step
> 2, but not step 3.
> He restore me the hole last transaction log i selected
> an don't stop between step 2 and 3 !!
> Many thanks for your help
> Daniel
>|||Hello
No i use the SQL Enterprise Manager not the Query
Analycer. I know the statement in Qury Analycer.
Thaks and best regards.
Daniel
>--Original Message--
>Did you use STOPAT..?
>Here's the example from SQL BOL
>-- Restore the database backup.
>RESTORE DATABASE MyNwind
> FROM MyNwind_1, MyNwind_2
> WITH NORECOVERY
>GO
>RESTORE LOG MyNwind
> FROM MyNwind_log1
> WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
>GO
>
>--
>HTH
>Ryan Waight, MCDBA, MCSE
>"Ischi" <daniel_ischi@.hotmail.com> wrote in message
>news:0def01c38d87$06a78890$a101280a@.phx.gbl...
>> I'm having a problem testing a point in time backup.
Here
>> is what I was trying:
>> 1) I created a complete database backup to a file
>> D:\TEMP.DAT (of a database named
>> PHCS) (Time - 10:45)
>> 2) I went and made some changes to the PHCS database at
>> 10:49:10
>> 3) I went and made some more changes to the PHCS
database
>> at 10:50:50
>> 4) I backed up the transaction log database (also into
>> D:\TEMP.DAT, appending).
>> (Time - 10:52)
>> 5) I went to restore the database backed up at 10:45
and
>> left it unoperational
>> 6) I went to restore the transaction log created at
10:52
>> and tried to specify a time
>> of 10:50:00. I wanted to restore the changes made in
step
>> 2, but not step 3.
>> He restore me the hole last transaction log i selected
>> an don't stop between step 2 and 3 !!
>> Many thanks for your help
>> Daniel
>
>.
>|||To do it within Enterprise Manager :-
Right Click DB
All Tasks
Restore DataBase
Tick the Box "Point in Time Restore"
Specify the time you wish to stop at.
--
HTH
Ryan Waight, MCDBA, MCSE
"Ischi" <daniel_ischi@.hotmail.com> wrote in message
news:0cde01c38d90$dcd9bc90$a301280a@.phx.gbl...
> Hello
> No i use the SQL Enterprise Manager not the Query
> Analycer. I know the statement in Qury Analycer.
> Thaks and best regards.
> Daniel
> >--Original Message--
> >Did you use STOPAT..?
> >
> >Here's the example from SQL BOL
> >
> >-- Restore the database backup.
> >RESTORE DATABASE MyNwind
> > FROM MyNwind_1, MyNwind_2
> > WITH NORECOVERY
> >GO
> >RESTORE LOG MyNwind
> > FROM MyNwind_log1
> > WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
> >GO
> >
> >
> >
> >--
> >HTH
> >Ryan Waight, MCDBA, MCSE
> >
> >"Ischi" <daniel_ischi@.hotmail.com> wrote in message
> >news:0def01c38d87$06a78890$a101280a@.phx.gbl...
> >> I'm having a problem testing a point in time backup.
> Here
> >> is what I was trying:
> >>
> >> 1) I created a complete database backup to a file
> >> D:\TEMP.DAT (of a database named
> >> PHCS) (Time - 10:45)
> >> 2) I went and made some changes to the PHCS database at
> >> 10:49:10
> >> 3) I went and made some more changes to the PHCS
> database
> >> at 10:50:50
> >> 4) I backed up the transaction log database (also into
> >> D:\TEMP.DAT, appending).
> >> (Time - 10:52)
> >> 5) I went to restore the database backed up at 10:45
> and
> >> left it unoperational
> >> 6) I went to restore the transaction log created at
> 10:52
> >> and tried to specify a time
> >> of 10:50:00. I wanted to restore the changes made in
> step
> >> 2, but not step 3.
> >>
> >> He restore me the hole last transaction log i selected
> >> an don't stop between step 2 and 3 !!
> >>
> >> Many thanks for your help
> >>
> >> Daniel
> >>
> >
> >
> >.
> >