Database Unit Testing: package

Showing posts with label package. Show all posts

Wednesday, March 21, 2012

Database Setup Package/Installation

Hi Folks,
I've created a SQL Server database and converted it to Oracle (an app we
made supports MSSQL and Oracle) and I'd like to be able to provide a
"server-side" installation that clients can run on their database server
that would automatically create the MSSQL or Oracle database, the tables,
index, relationships, etc. and insert the needed data for a "new" database.
I have very little experience in the realm of database setup & installation.
Has anyone ever done this before and if so, what product/technology did you
use? I've been searching the newsgroups and haven't found much useful info
on the topic. Am I looking in the wrong place?
Thanks,
Jason-- Jason wrote: --
>> Hi Folks,
> I've created a SQL Server database and converted it to Oracle (an app we
> made supports MSSQL and Oracle) and I'd like to be able to provide a
> "server-side" installation that clients can run on their database server
> that would automatically create the MSSQL or Oracle database, the tables,
> index, relationships, etc. and insert the needed data for a "new" database.
--
Hi Jason,
This is a fairly trivial exercise. Have a look at the sample *.sql scripts that automatically creates the sample Northwind and Pubs database when you install SQL Server. They will give you some idea on how to automatically create a database and objects within that database.
The files are instnwnd.sql and instpubs.sql to install Northwind and Pubs, respectively. The files can be found on your <drive>:\Program Files\Microsoft SQL Server\MSSQL\Install folder
Hope this helps,
-Eric CÃ¡rdenas
SQL Server support|||You could, from your install program, either spawn OSQL with your script file (see Eric's post) as
input parameter. Or you can write your own app which reads the file and execute the TSQL statements
in the script file. Or you could, of course, embed the various CREATE statements inside your setup
programs source code.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Jason" <jasonmauss_nospam@.vsdotnetguru.com> wrote in message
news:%23KeLsTSuDHA.2244@.TK2MSFTNGP09.phx.gbl...
> Hi Folks,
> I've created a SQL Server database and converted it to Oracle (an app we
> made supports MSSQL and Oracle) and I'd like to be able to provide a
> "server-side" installation that clients can run on their database server
> that would automatically create the MSSQL or Oracle database, the tables,
> index, relationships, etc. and insert the needed data for a "new" database.
> I have very little experience in the realm of database setup & installation.
> Has anyone ever done this before and if so, what product/technology did you
> use? I've been searching the newsgroups and haven't found much useful info
> on the topic. Am I looking in the wrong place?
> Thanks,
> Jason
>|||I would probably
1. Script out Your DB. This will enable you to create a blank version of
your DB somewhere else.
2. Have your standing data in text files and use BULK INSERT or bcp
statements to load it into the tables.
3. Use osql to load the scripts you have created.
(mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\co
prompt.chm::/cp_osql_1wxl.htm)
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Jason" <jasonmauss_nospam@.vsdotnetguru.com> wrote in message
news:%23KeLsTSuDHA.2244@.TK2MSFTNGP09.phx.gbl...
> Hi Folks,
> I've created a SQL Server database and converted it to Oracle (an app
we
> made supports MSSQL and Oracle) and I'd like to be able to provide a
> "server-side" installation that clients can run on their database server
> that would automatically create the MSSQL or Oracle database, the tables,
> index, relationships, etc. and insert the needed data for a "new"
database.
> I have very little experience in the realm of database setup &
installation.
> Has anyone ever done this before and if so, what product/technology did
you
> use? I've been searching the newsgroups and haven't found much useful info
> on the topic. Am I looking in the wrong place?
> Thanks,
> Jason
>|||Thanks for the responses from everyone. I'm aware I can provide someone with
.sql scripts...what I'm more interested in though is an installation I can
provide that goes something like this:
User runs Setup.exe to luanch the setup.
During Setup, one of the screens prompts them to enter the db information
(name of the server, un/pw)
Then setup takes that information and runs the DDL scripts against the
server they provided.
Are there any products (like Wise or Installshield maybe) that help automate
the creation of setups to do this or am I looking at needing to write my own
custom setup program?
Jason
"Eric Cardenas" <anonymous@.discussions.microsoft.com> wrote in message
news:BE41F8CB-4DBA-439D-A034-32CF737D0ED0@.microsoft.com...
> -- Jason wrote: --
> >> Hi Folks,
> > I've created a SQL Server database and converted it to Oracle (an app
we
> > made supports MSSQL and Oracle) and I'd like to be able to provide a
> > "server-side" installation that clients can run on their database
server
> > that would automatically create the MSSQL or Oracle database, the
tables,
> > index, relationships, etc. and insert the needed data for a "new"
database.
> --
> Hi Jason,
> This is a fairly trivial exercise. Have a look at the sample *.sql scripts
that automatically creates the sample Northwind and Pubs database when you
install SQL Server. They will give you some idea on how to automatically
create a database and objects within that database.
> The files are instnwnd.sql and instpubs.sql to install Northwind and Pubs,
respectively. The files can be found on your <drive>:\Program
Files\Microsoft SQL Server\MSSQL\Install folder
> Hope this helps,
> -Eric Cárdenas
> SQL Server support
>

Database Setup Package/Installation

quote:

>Hi Folks,
> I've created a SQL Server database and converted it to Oracle (an app w
e
>made supports MSSQL and Oracle) and I'd like to be able to provide a
>"server-side" installation that clients can run on their database server
>that would automatically create the MSSQL or Oracle database, the tables,
>index, relationships, etc. and insert the needed data for a "new" database.
>I have very little experience in the realm of database setup & installation
.
>Has anyone ever done this before and if so, what product/technology did you
>use? I've been searching the newsgroups and haven't found much useful info
>on the topic. Am I looking in the wrong place?
>Thanks,
>Jason
>

|||You could, from your install program, either spawn OSQL with your script fil
e (see Eric's post) as
input parameter. Or you can write your own app which reads the file and exec
ute the TSQL statements
in the script file. Or you could, of course, embed the various CREATE statem
ents inside your setup
programs source code.
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Jason" <jasonmauss_nospam@.vsdotnetguru.com> wrote in message
news:%23KeLsTSuDHA.2244@.TK2MSFTNGP09.phx.gbl...

quote:

> Hi Folks,
> I've created a SQL Server database and converted it to Oracle (an app
we
> made supports MSSQL and Oracle) and I'd like to be able to provide a
> "server-side" installation that clients can run on their database server
> that would automatically create the MSSQL or Oracle database, the tables,
> index, relationships, etc. and insert the needed data for a "new" database
.
> I have very little experience in the realm of database setup & installatio
n.
> Has anyone ever done this before and if so, what product/technology did yo
u
> use? I've been searching the newsgroups and haven't found much useful info
> on the topic. Am I looking in the wrong place?
> Thanks,
> Jason
>

|||I would probably
1. Script out Your DB. This will enable you to create a blank version of
your DB somewhere else.
2. Have your standing data in text files and use BULK INSERT or bcp
statements to load it into the tables.
3. Use osql to load the scripts you have created.
(mk:@.MSITStore:C:\Program%20Files\Micros
oft%20SQL%20Server\80\Tools\Books\co
prompt.chm::/cp_osql_1wxl.htm)
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Jason" <jasonmauss_nospam@.vsdotnetguru.com> wrote in message
news:%23KeLsTSuDHA.2244@.TK2MSFTNGP09.phx.gbl...

quote:

> Hi Folks,
> I've created a SQL Server database and converted it to Oracle (an app

quote:

> made supports MSSQL and Oracle) and I'd like to be able to provide a
> "server-side" installation that clients can run on their database server
> that would automatically create the MSSQL or Oracle database, the tables,
> index, relationships, etc. and insert the needed data for a "new"

database.

quote:

> I have very little experience in the realm of database setup &

installation.

quote:

> Has anyone ever done this before and if so, what product/technology did

you

quote:

> use? I've been searching the newsgroups and haven't found much useful info
> on the topic. Am I looking in the wrong place?
> Thanks,
> Jason
>

|||Thanks for the responses from everyone. I'm aware I can provide someone with
.sql scripts...what I'm more interested in though is an installation I can
provide that goes something like this:
User runs Setup.exe to luanch the setup.
During Setup, one of the screens prompts them to enter the db information
(name of the server, un/pw)
Then setup takes that information and runs the DDL scripts against the
server they provided.
Are there any products (like Wise or Installshield maybe) that help automate
the creation of setups to do this or am I looking at needing to write my own
custom setup program?
Jason
"Eric Cardenas" <anonymous@.discussions.microsoft.com> wrote in message
news:BE41F8CB-4DBA-439D-A034-32CF737D0ED0@.microsoft.com...

quote:

> -- Jason wrote: --
we[QUOTE]
server[QUOTE]
tables,[QUOTE]
database.[QUOTE]
> --
> Hi Jason,
> This is a fairly trivial exercise. Have a look at the sample *.sql scripts

that automatically creates the sample Northwind and Pubs database when you
install SQL Server. They will give you some idea on how to automatically
create a database and objects within that database.

quote:

> The files are instnwnd.sql and instpubs.sql to install Northwind and Pubs,

respectively. The files can be found on your <drive>:\Program
Files\Microsoft SQL Server\MSSQL\Install folder

quote:

> Hope this helps,
> -Eric Crdenas
> SQL Server support
>

Thursday, March 8, 2012

Database restore fixes problem - why?

We are using a SQL Server 7.0 database for a financial software package that
we use. Every year we run into problems with the software package not
working properly on a certain function. The solution to fixing the problem
we have discovered is to simply back-up the database and then restore it.
After doing the restore of the database, the problem is fixed. Does anyone
have any idea why? And, if so, can you tell me what could be down to prevent
the problem in the first place? What is it about a restore that would change
something enough to make it suddenly start working correctly? Thanks for
anything you can offer. This is driving me nuts.
JeffJeff
You did not say what is the problem?
"Jeff" <Jeff@.discussions.microsoft.com> wrote in message
news:F67A59F9-DCA9-4830-9C24-1E9096A26360@.microsoft.com...
> We are using a SQL Server 7.0 database for a financial software package
> that
> we use. Every year we run into problems with the software package not
> working properly on a certain function. The solution to fixing the
> problem
> we have discovered is to simply back-up the database and then restore it.
> After doing the restore of the database, the problem is fixed. Does
> anyone
> have any idea why? And, if so, can you tell me what could be down to
> prevent
> the problem in the first place? What is it about a restore that would
> change
> something enough to make it suddenly start working correctly? Thanks for
> anything you can offer. This is driving me nuts.
> Jeff|||Uri,
The specific problem is within the financial sotfware - when we do a year
end close the software creates a batch of transactions then the next step is
to "post" those transactions. The software creates the batch OK, but when we
try to post the batch it just crashes the program without giving any error
messages.
After the restore, everything works as it should.
"Uri Dimant" wrote:
> Jeff
> You did not say what is the problem?
>
> "Jeff" <Jeff@.discussions.microsoft.com> wrote in message
> news:F67A59F9-DCA9-4830-9C24-1E9096A26360@.microsoft.com...
> > We are using a SQL Server 7.0 database for a financial software package
> > that
> > we use. Every year we run into problems with the software package not
> > working properly on a certain function. The solution to fixing the
> > problem
> > we have discovered is to simply back-up the database and then restore it.
> > After doing the restore of the database, the problem is fixed. Does
> > anyone
> > have any idea why? And, if so, can you tell me what could be down to
> > prevent
> > the problem in the first place? What is it about a restore that would
> > change
> > something enough to make it suddenly start working correctly? Thanks for
> > anything you can offer. This is driving me nuts.
> >
> > Jeff
>
>|||Jeff,
without understand what your financial system does and without any errors
whatsoever, you can imagine that this is a needle in a haystack response!
If this happens everytime without fail, I suggest replicating it in you test
environment and profiling what happens to start with.
Immy
"Jeff" <Jeff@.discussions.microsoft.com> wrote in message
news:19173B07-D12D-445E-A433-D5A5F0666FD0@.microsoft.com...
> Uri,
> The specific problem is within the financial sotfware - when we do a year
> end close the software creates a batch of transactions then the next step
> is
> to "post" those transactions. The software creates the batch OK, but when
> we
> try to post the batch it just crashes the program without giving any error
> messages.
> After the restore, everything works as it should.
> "Uri Dimant" wrote:
>> Jeff
>> You did not say what is the problem?
>>
>> "Jeff" <Jeff@.discussions.microsoft.com> wrote in message
>> news:F67A59F9-DCA9-4830-9C24-1E9096A26360@.microsoft.com...
>> > We are using a SQL Server 7.0 database for a financial software package
>> > that
>> > we use. Every year we run into problems with the software package not
>> > working properly on a certain function. The solution to fixing the
>> > problem
>> > we have discovered is to simply back-up the database and then restore
>> > it.
>> > After doing the restore of the database, the problem is fixed. Does
>> > anyone
>> > have any idea why? And, if so, can you tell me what could be down to
>> > prevent
>> > the problem in the first place? What is it about a restore that would
>> > change
>> > something enough to make it suddenly start working correctly? Thanks
>> > for
>> > anything you can offer. This is driving me nuts.
>> >
>> > Jeff
>>|||Jeff
I still don't undertsand how does it relate to SQL Server? Is it possible
that the problem is in software program?
>but when we
> try to post the batch it just crashes the program without giving any error
> messages.
What does it mean? The program tries to insert the data into a table and
then it crashes?
"Jeff" <Jeff@.discussions.microsoft.com> wrote in message
news:19173B07-D12D-445E-A433-D5A5F0666FD0@.microsoft.com...
> Uri,
> The specific problem is within the financial sotfware - when we do a year
> end close the software creates a batch of transactions then the next step
> is
> to "post" those transactions. The software creates the batch OK, but when
> we
> try to post the batch it just crashes the program without giving any error
> messages.
> After the restore, everything works as it should.
> "Uri Dimant" wrote:
>> Jeff
>> You did not say what is the problem?
>>
>> "Jeff" <Jeff@.discussions.microsoft.com> wrote in message
>> news:F67A59F9-DCA9-4830-9C24-1E9096A26360@.microsoft.com...
>> > We are using a SQL Server 7.0 database for a financial software package
>> > that
>> > we use. Every year we run into problems with the software package not
>> > working properly on a certain function. The solution to fixing the
>> > problem
>> > we have discovered is to simply back-up the database and then restore
>> > it.
>> > After doing the restore of the database, the problem is fixed. Does
>> > anyone
>> > have any idea why? And, if so, can you tell me what could be down to
>> > prevent
>> > the problem in the first place? What is it about a restore that would
>> > change
>> > something enough to make it suddenly start working correctly? Thanks
>> > for
>> > anything you can offer. This is driving me nuts.
>> >
>> > Jeff
>>|||Uri,
It's possible that it is within the software, but what I'm wondering is -
what is it about a SQL database restore that would cause the same software
code to go from not working to working all of a sudden? What changes occur
to the database when a restore is done?
I realize this is a tough one to answer, I was just hoping that you might
have some ideas as to why the restore would "fix" things.
"Uri Dimant" wrote:
> Jeff
> I still don't undertsand how does it relate to SQL Server? Is it possible
> that the problem is in software program?
> >but when we
> > try to post the batch it just crashes the program without giving any error
> > messages.
> What does it mean? The program tries to insert the data into a table and
> then it crashes?
>
> "Jeff" <Jeff@.discussions.microsoft.com> wrote in message
> news:19173B07-D12D-445E-A433-D5A5F0666FD0@.microsoft.com...
> > Uri,
> >
> > The specific problem is within the financial sotfware - when we do a year
> > end close the software creates a batch of transactions then the next step
> > is
> > to "post" those transactions. The software creates the batch OK, but when
> > we
> > try to post the batch it just crashes the program without giving any error
> > messages.
> >
> > After the restore, everything works as it should.
> >
> > "Uri Dimant" wrote:
> >
> >> Jeff
> >> You did not say what is the problem?
> >>
> >>
> >>
> >> "Jeff" <Jeff@.discussions.microsoft.com> wrote in message
> >> news:F67A59F9-DCA9-4830-9C24-1E9096A26360@.microsoft.com...
> >> > We are using a SQL Server 7.0 database for a financial software package
> >> > that
> >> > we use. Every year we run into problems with the software package not
> >> > working properly on a certain function. The solution to fixing the
> >> > problem
> >> > we have discovered is to simply back-up the database and then restore
> >> > it.
> >> > After doing the restore of the database, the problem is fixed. Does
> >> > anyone
> >> > have any idea why? And, if so, can you tell me what could be down to
> >> > prevent
> >> > the problem in the first place? What is it about a restore that would
> >> > change
> >> > something enough to make it suddenly start working correctly? Thanks
> >> > for
> >> > anything you can offer. This is driving me nuts.
> >> >
> >> > Jeff
> >>
> >>
> >>
>
>|||Jeff
I see that you would not want to "reveal" more info about your business
requirements , it is ok , however we will no be able to help you much if you
cannot provide more info
RESTORE operations does simple thing , it reads all datapages/data from the
.BAK file and create a new database assume you want to create a new one
If you had a proper database backup and then your software dod some mistake
, you can come back to the previous state of the database to restore it. It
does not fix anything
"Jeff" <Jeff@.discussions.microsoft.com> wrote in message
news:15F36608-14B2-456F-9032-C99B53A6D93B@.microsoft.com...
> Uri,
> It's possible that it is within the software, but what I'm wondering is -
> what is it about a SQL database restore that would cause the same software
> code to go from not working to working all of a sudden? What changes
> occur
> to the database when a restore is done?
> I realize this is a tough one to answer, I was just hoping that you might
> have some ideas as to why the restore would "fix" things.
> "Uri Dimant" wrote:
>> Jeff
>> I still don't undertsand how does it relate to SQL Server? Is it possible
>> that the problem is in software program?
>> >but when we
>> > try to post the batch it just crashes the program without giving any
>> > error
>> > messages.
>> What does it mean? The program tries to insert the data into a table and
>> then it crashes?
>>
>> "Jeff" <Jeff@.discussions.microsoft.com> wrote in message
>> news:19173B07-D12D-445E-A433-D5A5F0666FD0@.microsoft.com...
>> > Uri,
>> >
>> > The specific problem is within the financial sotfware - when we do a
>> > year
>> > end close the software creates a batch of transactions then the next
>> > step
>> > is
>> > to "post" those transactions. The software creates the batch OK, but
>> > when
>> > we
>> > try to post the batch it just crashes the program without giving any
>> > error
>> > messages.
>> >
>> > After the restore, everything works as it should.
>> >
>> > "Uri Dimant" wrote:
>> >
>> >> Jeff
>> >> You did not say what is the problem?
>> >>
>> >>
>> >>
>> >> "Jeff" <Jeff@.discussions.microsoft.com> wrote in message
>> >> news:F67A59F9-DCA9-4830-9C24-1E9096A26360@.microsoft.com...
>> >> > We are using a SQL Server 7.0 database for a financial software
>> >> > package
>> >> > that
>> >> > we use. Every year we run into problems with the software package
>> >> > not
>> >> > working properly on a certain function. The solution to fixing the
>> >> > problem
>> >> > we have discovered is to simply back-up the database and then
>> >> > restore
>> >> > it.
>> >> > After doing the restore of the database, the problem is fixed. Does
>> >> > anyone
>> >> > have any idea why? And, if so, can you tell me what could be down
>> >> > to
>> >> > prevent
>> >> > the problem in the first place? What is it about a restore that
>> >> > would
>> >> > change
>> >> > something enough to make it suddenly start working correctly?
>> >> > Thanks
>> >> > for
>> >> > anything you can offer. This is driving me nuts.
>> >> >
>> >> > Jeff
>> >>
>> >>
>> >>
>>|||Uri,
It's not so much that I don't want to "reveal" anything, it's just that I
don't know exactly what the software is doing as it hits the database. It's
a third party software, and they have no idea why just doing a restore works.
So I thought I would pose the question to someone more knowledgable on the
SQL database side.
Somethings that I was thinking might be going on (keep in mind I am in no
way an expect on any of this) - maybe there is a bad sector on the disk, and
doing the restore ends up writing the data necessary for the Year End process
to complete correctly to a different sector of the disk. Or maybe something
like - the restore causes indexes to be updated, or causes page files to be
readjusted or anything like that.
"Uri Dimant" wrote:
> Jeff
> I see that you would not want to "reveal" more info about your business
> requirements , it is ok , however we will no be able to help you much if you
> cannot provide more info
> RESTORE operations does simple thing , it reads all datapages/data from the
> ..BAK file and create a new database assume you want to create a new one
> If you had a proper database backup and then your software dod some mistake
> , you can come back to the previous state of the database to restore it. It
> does not fix anything
>
>
> "Jeff" <Jeff@.discussions.microsoft.com> wrote in message
> news:15F36608-14B2-456F-9032-C99B53A6D93B@.microsoft.com...
> > Uri,
> >
> > It's possible that it is within the software, but what I'm wondering is -
> > what is it about a SQL database restore that would cause the same software
> > code to go from not working to working all of a sudden? What changes
> > occur
> > to the database when a restore is done?
> >
> > I realize this is a tough one to answer, I was just hoping that you might
> > have some ideas as to why the restore would "fix" things.
> >
> > "Uri Dimant" wrote:
> >
> >> Jeff
> >> I still don't undertsand how does it relate to SQL Server? Is it possible
> >> that the problem is in software program?
> >>
> >> >but when we
> >> > try to post the batch it just crashes the program without giving any
> >> > error
> >> > messages.
> >>
> >> What does it mean? The program tries to insert the data into a table and
> >> then it crashes?
> >>
> >>
> >> "Jeff" <Jeff@.discussions.microsoft.com> wrote in message
> >> news:19173B07-D12D-445E-A433-D5A5F0666FD0@.microsoft.com...
> >> > Uri,
> >> >
> >> > The specific problem is within the financial sotfware - when we do a
> >> > year
> >> > end close the software creates a batch of transactions then the next
> >> > step
> >> > is
> >> > to "post" those transactions. The software creates the batch OK, but
> >> > when
> >> > we
> >> > try to post the batch it just crashes the program without giving any
> >> > error
> >> > messages.
> >> >
> >> > After the restore, everything works as it should.
> >> >
> >> > "Uri Dimant" wrote:
> >> >
> >> >> Jeff
> >> >> You did not say what is the problem?
> >> >>
> >> >>
> >> >>
> >> >> "Jeff" <Jeff@.discussions.microsoft.com> wrote in message
> >> >> news:F67A59F9-DCA9-4830-9C24-1E9096A26360@.microsoft.com...
> >> >> > We are using a SQL Server 7.0 database for a financial software
> >> >> > package
> >> >> > that
> >> >> > we use. Every year we run into problems with the software package
> >> >> > not
> >> >> > working properly on a certain function. The solution to fixing the
> >> >> > problem
> >> >> > we have discovered is to simply back-up the database and then
> >> >> > restore
> >> >> > it.
> >> >> > After doing the restore of the database, the problem is fixed. Does
> >> >> > anyone
> >> >> > have any idea why? And, if so, can you tell me what could be down
> >> >> > to
> >> >> > prevent
> >> >> > the problem in the first place? What is it about a restore that
> >> >> > would
> >> >> > change
> >> >> > something enough to make it suddenly start working correctly?
> >> >> > Thanks
> >> >> > for
> >> >> > anything you can offer. This is driving me nuts.
> >> >> >
> >> >> > Jeff
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||"Jeff" <Jeff@.discussions.microsoft.com> wrote in message
news:15F36608-14B2-456F-9032-C99B53A6D93B@.microsoft.com...
> Uri,
> It's possible that it is within the software, but what I'm wondering is -
> what is it about a SQL database restore that would cause the same software
> code to go from not working to working all of a sudden? What changes
> occur
> to the database when a restore is done?
> I realize this is a tough one to answer, I was just hoping that you might
> have some ideas as to why the restore would "fix" things.
>
Well a restore will finish rolling forward or backwards any pending
transactions depending on where they were.
It's possible your financial app posts some large transaction and never sees
it complete and hence locks up.
In any event I think you need to take it up with the financial app vendor.
One option though is to run profiler and record what the app is doing and
seeing if there's anything strange going on there.
And are you sure the app is locking up, or simply waiting for a huge
transaction to commit on the SQL side?
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com|||There are likely other steps you can take before the restore
that can help you track down what the issues are -
have you run DBCC checks when you hit this?
Are you checking for open transactions?
Are you monitoring with profiler? Are you executing sp_who2,
checking sysprocesses, checking wait stats, locking,
blocking, etc?
Those would probably be the first steps anyway and you'd
want to go from there - depending on the results.
-Sue
On Tue, 20 Feb 2007 06:22:50 -0800, Jeff
<Jeff@.discussions.microsoft.com> wrote:
>Uri,
>It's possible that it is within the software, but what I'm wondering is -
>what is it about a SQL database restore that would cause the same software
>code to go from not working to working all of a sudden? What changes occur
>to the database when a restore is done?
>I realize this is a tough one to answer, I was just hoping that you might
>have some ideas as to why the restore would "fix" things.
>"Uri Dimant" wrote:
>> Jeff
>> I still don't undertsand how does it relate to SQL Server? Is it possible
>> that the problem is in software program?
>> >but when we
>> > try to post the batch it just crashes the program without giving any error
>> > messages.
>> What does it mean? The program tries to insert the data into a table and
>> then it crashes?
>>
>> "Jeff" <Jeff@.discussions.microsoft.com> wrote in message
>> news:19173B07-D12D-445E-A433-D5A5F0666FD0@.microsoft.com...
>> > Uri,
>> >
>> > The specific problem is within the financial sotfware - when we do a year
>> > end close the software creates a batch of transactions then the next step
>> > is
>> > to "post" those transactions. The software creates the batch OK, but when
>> > we
>> > try to post the batch it just crashes the program without giving any error
>> > messages.
>> >
>> > After the restore, everything works as it should.
>> >
>> > "Uri Dimant" wrote:
>> >
>> >> Jeff
>> >> You did not say what is the problem?
>> >>
>> >>
>> >>
>> >> "Jeff" <Jeff@.discussions.microsoft.com> wrote in message
>> >> news:F67A59F9-DCA9-4830-9C24-1E9096A26360@.microsoft.com...
>> >> > We are using a SQL Server 7.0 database for a financial software package
>> >> > that
>> >> > we use. Every year we run into problems with the software package not
>> >> > working properly on a certain function. The solution to fixing the
>> >> > problem
>> >> > we have discovered is to simply back-up the database and then restore
>> >> > it.
>> >> > After doing the restore of the database, the problem is fixed. Does
>> >> > anyone
>> >> > have any idea why? And, if so, can you tell me what could be down to
>> >> > prevent
>> >> > the problem in the first place? What is it about a restore that would
>> >> > change
>> >> > something enough to make it suddenly start working correctly? Thanks
>> >> > for
>> >> > anything you can offer. This is driving me nuts.
>> >> >
>> >> > Jeff
>> >>
>> >>
>> >>
>>

Wednesday, March 21, 2012

Database Setup Package/Installation

Database Setup Package/Installation

Thursday, March 8, 2012

Database restore fixes problem - why?

Database restore fixes problem - why?

Database restore fixes problem - why?

Database Unit Testing

Blog Archive

About Me