Database in recovery

Our server ran out of disk space during a stored procedure process. We were able to free up some space, stopped all SQL services, restarted all SQL services and now SQL Management Studio shows the database to be in recovery. Is there a way to monitor this to ensure progress is being made and to estimate when it might complete?

I don't know it can be checked programatically but you can sql error log where you recovery progress will be recorded.

Looks like you guys shutdown the servers in the middle of big transaction....

There will no other option than waiting to recover...

|||

There is a way, via T-SQL to view process progress but apparently not via GUI. The database did eventually recover and we have submitted for a new server as it ran out of disk space during a stored procedure run.

Thanks!

Database Documentation

If someone can provide a good guideline for finding
Database centric documentation, which would include naming
convention, Design & Pattern, Process & Procedure and such.
This guide would be something like MSF, but with more
details in planning, implementation, development,
deployment, maintenance, and troubleshooting.
Thanks in advance.from the Operational side , there is some good stuff in the SQL Ops guide as
per below
http://support.microsoft.com/defaul...kb;en-us;829024
also below, which is based around MSF anyway
http://www.microsoft.com/resources/...se/default.mspx
cheers,
Andy.
"TO" <anonymous@.discussions.microsoft.com> wrote in message
news:143001c48c3a$6214ab10$a601280a@.phx.gbl...
> If someone can provide a good guideline for finding
> Database centric documentation, which would include naming
> convention, Design & Pattern, Process & Procedure and such.
> This guide would be something like MSF, but with more
> details in planning, implementation, development,
> deployment, maintenance, and troubleshooting.
> Thanks in advance.

Database Documentation

If someone can provide a good guideline for finding
Database centric documentation, which would include naming
convention, Design & Pattern, Process & Procedure and such.
This guide would be something like MSF, but with more
details in planning, implementation, development,
deployment, maintenance, and troubleshooting.
Thanks in advance.from the Operational side , there is some good stuff in the SQL Ops guide as
per below
http://support.microsoft.com/default.aspx?scid=kb;en-us;829024
also below, which is based around MSF anyway
http://www.microsoft.com/resources/practices/database/default.mspx
cheers,
Andy.
"TO" <anonymous@.discussions.microsoft.com> wrote in message
news:143001c48c3a$6214ab10$a601280a@.phx.gbl...
> If someone can provide a good guideline for finding
> Database centric documentation, which would include naming
> convention, Design & Pattern, Process & Procedure and such.
> This guide would be something like MSF, but with more
> details in planning, implementation, development,
> deployment, maintenance, and troubleshooting.
> Thanks in advance.

Database Documentation

If someone can provide a good guideline for finding
Database centric documentation, which would include naming
convention, Design & Pattern, Process & Procedure and such.
This guide would be something like MSF, but with more
details in planning, implementation, development,
deployment, maintenance, and troubleshooting.
Thanks in advance.
from the Operational side , there is some good stuff in the SQL Ops guide as
per below
http://support.microsoft.com/default...b;en-us;829024
also below, which is based around MSF anyway
http://www.microsoft.com/resources/p...e/default.mspx
cheers,
Andy.
"TO" <anonymous@.discussions.microsoft.com> wrote in message
news:143001c48c3a$6214ab10$a601280a@.phx.gbl...
> If someone can provide a good guideline for finding
> Database centric documentation, which would include naming
> convention, Design & Pattern, Process & Procedure and such.
> This guide would be something like MSF, but with more
> details in planning, implementation, development,
> deployment, maintenance, and troubleshooting.
> Thanks in advance.

database diagrams

Hello all,

I upsized an access backend to sql 2005. In the process, the relationships were lost. When I go to the database in Sql, right click on database diagrams, all I get is refresh and a link to go to learn about database diagrams. How can I recreate the diagrams?

Thanks

You'd be better asking the question here: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=84&SiteID=1

-Jamie

Database Design Question

I am right now in process of designing a database for hosting business. Now
just like other hosting companies even this hosting companies has its
different web hosting packages. But besides that the company is going to
provide a feature to customer where in they can select/customize the package
wherein they might want to add one of two additional feature that are not a
part of the standard package.
I have designed most of that tables but i am confused on how exactly should
i design the "User Defined Package" table.
There are one of the two things that i can do.
1) Have a column "customerid" (integer datatype) that will be referencing
to the customer table and have a "featureid" (integer datatype) column that
would be referencing "Features" table.
The problem here is that it would be easily be managable from programming
aspect but there wil be redundancy factor since if a same customer takes 5
additional features then there would be 5 rows with same customer id and
separate featureid and this is just for one customer. If there is a large
customer base it could create space issues as well.
2) Have a column "customerid" (integer datatype) that will be referencing
to the customer table and have another column featureids (varchar datatype)
that would have all the additional feature ids seperated by a deliminator.
There won't be redundancy in this case but would make things little bit
complicated from programming aspect since everything new additional feature
to to be added or edited or to be removed will require some work in the
code.
Which method should i go for that would be helpful not just now but also in
future as the customer base increases.
I do not have anything else in mind. If there is any other solution to this
all the suggestions are welcomed.
Thank you
Niel
Niel wrote:
> I am right now in process of designing a database for hosting business. Now
> just like other hosting companies even this hosting companies has its
> different web hosting packages. But besides that the company is going to
> provide a feature to customer where in they can select/customize the package
> wherein they might want to add one of two additional feature that are not a
> part of the standard package.
> I have designed most of that tables but i am confused on how exactly should
> i design the "User Defined Package" table.
> There are one of the two things that i can do.
> 1) Have a column "customerid" (integer datatype) that will be referencing
> to the customer table and have a "featureid" (integer datatype) column that
> would be referencing "Features" table.
> The problem here is that it would be easily be managable from programming
> aspect but there wil be redundancy factor since if a same customer takes 5
> additional features then there would be 5 rows with same customer id and
> separate featureid and this is just for one customer. If there is a large
> customer base it could create space issues as well.
> 2) Have a column "customerid" (integer datatype) that will be referencing
> to the customer table and have another column featureids (varchar datatype)
> that would have all the additional feature ids seperated by a deliminator.
> There won't be redundancy in this case but would make things little bit
> complicated from programming aspect since everything new additional feature
> to to be added or edited or to be removed will require some work in the
> code.
> Which method should i go for that would be helpful not just now but also in
> future as the customer base increases.
> I do not have anything else in mind. If there is any other solution to this
> all the suggestions are welcomed.
> Thank you
> Niel
I recommend you study some books or take a course on database design
theory before you go further. Your option 2 is a textbook example of
how NOT to do it.
Your first option sounds right to me from the point of view of
scalability and integrity. Of course I haven't had the opportunity to
analyse your business requirements, I only have your narrative to go
on. That's why newsgroups are a poor place to get database design
advice.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
|||Thanks for the suggestion david,
I'll go ahead and have a look at few book for reference. Can you advise me
on any good places/tutorials on website that i can go through to get a clear
concept on this.
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1143574016.274320.221210@.v46g2000cwv.googlegr oups.com...[vbcol=seagreen]
> Niel wrote:
Now[vbcol=seagreen]
package[vbcol=seagreen]
not a[vbcol=seagreen]
should[vbcol=seagreen]
referencing[vbcol=seagreen]
that[vbcol=seagreen]
programming[vbcol=seagreen]
5[vbcol=seagreen]
large[vbcol=seagreen]
referencing[vbcol=seagreen]
datatype)[vbcol=seagreen]
deliminator.[vbcol=seagreen]
feature[vbcol=seagreen]
in[vbcol=seagreen]
this
> I recommend you study some books or take a course on database design
> theory before you go further. Your option 2 is a textbook example of
> how NOT to do it.
> Your first option sounds right to me from the point of view of
> scalability and integrity. Of course I haven't had the opportunity to
> analyse your business requirements, I only have your narrative to go
> on. That's why newsgroups are a poor place to get database design
> advice.
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>

Database Design Question

I am right now in process of designing a database for hosting business. Now
just like other hosting companies even this hosting companies has its
different web hosting packages. But besides that the company is going to
provide a feature to customer where in they can select/customize the package
wherein they might want to add one of two additional feature that are not a
part of the standard package.
I have designed most of that tables but i am confused on how exactly should
i design the "User Defined Package" table.
There are one of the two things that i can do.
1) Have a column "customerid" (integer datatype) that will be referencing
to the customer table and have a "featureid" (integer datatype) column that
would be referencing "Features" table.
The problem here is that it would be easily be managable from programming
aspect but there wil be redundancy factor since if a same customer takes 5
additional features then there would be 5 rows with same customer id and
separate featureid and this is just for one customer. If there is a large
customer base it could create space issues as well.
2) Have a column "customerid" (integer datatype) that will be referencing
to the customer table and have another column featureids (varchar datatype)
that would have all the additional feature ids seperated by a deliminator.
There won't be redundancy in this case but would make things little bit
complicated from programming aspect since everything new additional feature
to to be added or edited or to be removed will require some work in the
code.
Which method should i go for that would be helpful not just now but also in
future as the customer base increases.
I do not have anything else in mind. If there is any other solution to this
all the suggestions are welcomed.
Thank you
NielNiel wrote:
> I am right now in process of designing a database for hosting business. No
w
> just like other hosting companies even this hosting companies has its
> different web hosting packages. But besides that the company is going to
> provide a feature to customer where in they can select/customize the packa
ge
> wherein they might want to add one of two additional feature that are not
a
> part of the standard package.
> I have designed most of that tables but i am confused on how exactly shoul
d
> i design the "User Defined Package" table.
> There are one of the two things that i can do.
> 1) Have a column "customerid" (integer datatype) that will be referencing
> to the customer table and have a "featureid" (integer datatype) column tha
t
> would be referencing "Features" table.
> The problem here is that it would be easily be managable from programming
> aspect but there wil be redundancy factor since if a same customer takes 5
> additional features then there would be 5 rows with same customer id and
> separate featureid and this is just for one customer. If there is a large
> customer base it could create space issues as well.
> 2) Have a column "customerid" (integer datatype) that will be referencing
> to the customer table and have another column featureids (varchar datatype
)
> that would have all the additional feature ids seperated by a deliminator.
> There won't be redundancy in this case but would make things little bit
> complicated from programming aspect since everything new additional featur
e
> to to be added or edited or to be removed will require some work in the
> code.
> Which method should i go for that would be helpful not just now but also i
n
> future as the customer base increases.
> I do not have anything else in mind. If there is any other solution to thi
s
> all the suggestions are welcomed.
> Thank you
> Niel
I recommend you study some books or take a course on database design
theory before you go further. Your option 2 is a textbook example of
how NOT to do it.
Your first option sounds right to me from the point of view of
scalability and integrity. Of course I haven't had the opportunity to
analyse your business requirements, I only have your narrative to go
on. That's why newsgroups are a poor place to get database design
advice.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Thanks for the suggestion david,
I'll go ahead and have a look at few book for reference. Can you advise me
on any good places/tutorials on website that i can go through to get a clear
concept on this.
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1143574016.274320.221210@.v46g2000cwv.googlegroups.com...
> Niel wrote:
Now[vbcol=seagreen]
package[vbcol=seagreen]
not a[vbcol=seagreen]
should[vbcol=seagreen]
referencing[vbcol=seagreen]
that[vbcol=seagreen]
programming[vbcol=seagreen]
5[vbcol=seagreen]
large[vbcol=seagreen]
referencing[vbcol=seagreen]
datatype)[vbcol=seagreen]
deliminator.[vbcol=seagreen]
feature[vbcol=seagreen]
in[vbcol=seagreen]
this[vbcol=seagreen]
> I recommend you study some books or take a course on database design
> theory before you go further. Your option 2 is a textbook example of
> how NOT to do it.
> Your first option sounds right to me from the point of view of
> scalability and integrity. Of course I haven't had the opportunity to
> analyse your business requirements, I only have your narrative to go
> on. That's why newsgroups are a poor place to get database design
> advice.
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>

Database design question

I'm in the process of designing a database and would like some
suggestion on how to architect it.

I have 3 'objects', frequency, task, skill.

For each task there is a frequency however for some tasks there are a
number of different skills, each of which have different frequencies,
so, for example, imagine frequencies being time in minutes. Each task
has to be done a certain number of times but certain tasks have varied
skill levels and each skill level has different frequencies associated
with it.

Task 1, Freq 5min
Task 2, Freq 10min
Task 3, Skill 1, Freq 5min
Task 3, Skill 2, Freq 15min
Task 4, Skill 1, Freq 10min
Task 4, Skill 2, Freq 15min
Task 4, Skill 3, Freq 20min

The problems is that the freq / skill is dependent on the task. I'm
having trouble deciding how to build this database.

I could just hard code the Tasks/Skill in a table so that I have

TaskID PK
Task
Freq

and have records like:

1 Task1 5
2 Task2 10
3 Task3Skill1 5
4 Task3Skill2 15

but I don't like it because it is not easily maintained - in case
freq/skills change.

Does anyone have any ideas. The important information is the
frequency as it will be used to build timetables.>> I have 3 'objects', frequency, task, skill. <<

Basic question - in your business model are these separate entities or
attributes of an entity? What are the dependencies among them? The answer to
these questions lay the foundation for the table design.

>> I could just hard code the Tasks/Skill in a table ... <<

That violates 1NF (assuming tasks & skills are different attributes) and
based on my interpretation of your requirements would cause an update/delete
anomaly. Generally database design cannot be accomplished using Newsgroup
responses since it requires a comprehensive understanding of your underlying
business model, rules & requirements. However, based on a series of
assumptions, here is one way of SQL representation :

CREATE TABLE Tasks (
Task_id INT NOT NULL PRIMARY KEY,
Details VARCHAR(30) NOT NULL,
...);

CREATE TABLE Skills (
Skill_id INT NOT NULL PRIMARY KEY,
Decription VARCHAR(40) NOT NULL,
...);

CREATE TABLE TaskSkills (
Task_id INT NOT NULL
REFERENCES Tasks(Task_id),
Skill_id INT NOT NULL
REFERENCES Skills(Skill_id),
Freq INT NOT NULL
PRIMARY KEY(Task_id, Skill_id));

--
- Anith
( Please reply to newsgroups only )

Database design question

Hi there

I'm in the process of creating an order database that contains tables for products and an order table that contains information for orders. Should the order table have a xref to the products table to show what products are associated or should there be a separate table to show what products are associated for the order (ie a orderProduct table) that would also contain pricing. The reason for my question is for tracking order history. If the price of a product changes and the order table is associated with the product id then old orders will have the new pricing which is incorrect. Would it be better to when an order is place copy the values of price and the product info to an other table?

Thanks

Good thinking. Separate table. OrderProducts. OrderID FK, ProductID FK, OrderPrice. OrderPrice is the price at the time of the order.

Incidentally, can anyone delete a product if your customer discontinues it? If so, you might want to think about a YesNo/bit column to flag a discontinued product for suppression rather than wiping it from the database.

|||

I would recommend that you do that, for exactly the reason you state. I have worked with MS Commerce Server 2000 and it had a similar database design. Here is a simplified example from my vague memory:

Order
OrderID (primary key)
OrderNumber (human readable order number)
CustomerID (foreign key to customer)
Date
SubTotal
Tax
Shipping
GrandTotal

Product
ProductID (primary key)
Active
SKU
Name
Description
Price

OrderItem
SKU
Name
Price
Quantity
Total

The idea is that any field that could change throughout the lifetime of a product should be stored with the order in order to record exactly what they ordered. You may even think about moving the Price for Products out into a ProductPrice table like the following.

Product
ProductID
SKU
Name
Description

ProductPrice
ProductID (foreign key to product)
EffectiveDate (date this price becomes effective)
Price

This design allows you to change prices ahead of time and specify when they become effective. To get the current price you would select the ProductPrice with the highest EffectiveDate that is greater than or equal to today's date. This may be totally unnecessary though, it's just an idea.

Mark

|||thanks for the replies guys that does help clarify things. I'm currently having the same type of issues with a room booking database design. I want to have tenants book certain rooms for specified time intervals. The tenants can book rooms (rooms are stored in a table) and select things like room setup (configurations are stored in a table). All the tables have an active flag on then. I also have a bookings table but unsure as to how to store the rooms and configurations that are selected. Should i be using ids in the booking table? What happens if the rooms become inactive down the road and the client was to view past bookings? Do i leave out the check on the active flags and show the rooms anyway? I believe that i need the room ids in order to validate new bookings against what is already booked. If the admins want to edit bookings and say a room or configuration that was previously active is now inactive would i force the admin to select a new configuration? tables such as room and room configuration do not have an interface to change values or inactivate them, i'm just wondering for the future if they say they want to add a room and remove a room then past bookings will get affected.

Database Design Question

I am right now in process of designing a database for hosting business. Now
just like other hosting companies even this hosting companies has its
different web hosting packages. But besides that the company is going to
provide a feature to customer where in they can select/customize the package
wherein they might want to add one of two additional feature that are not a
part of the standard package.
I have designed most of that tables but i am confused on how exactly should
i design the "User Defined Package" table.
There are one of the two things that i can do.
1) Have a column "customerid" (integer datatype) that will be referencing
to the customer table and have a "featureid" (integer datatype) column that
would be referencing "Features" table.
The problem here is that it would be easily be managable from programming
aspect but there wil be redundancy factor since if a same customer takes 5
additional features then there would be 5 rows with same customer id and
separate featureid and this is just for one customer. If there is a large
customer base it could create space issues as well.
2) Have a column "customerid" (integer datatype) that will be referencing
to the customer table and have another column featureids (varchar datatype)
that would have all the additional feature ids seperated by a deliminator.
There won't be redundancy in this case but would make things little bit
complicated from programming aspect since everything new additional feature
to to be added or edited or to be removed will require some work in the
code.
Which method should i go for that would be helpful not just now but also in
future as the customer base increases.
I do not have anything else in mind. If there is any other solution to this
all the suggestions are welcomed.
Thank you
NielNiel wrote:
> I am right now in process of designing a database for hosting business. Now
> just like other hosting companies even this hosting companies has its
> different web hosting packages. But besides that the company is going to
> provide a feature to customer where in they can select/customize the package
> wherein they might want to add one of two additional feature that are not a
> part of the standard package.
> I have designed most of that tables but i am confused on how exactly should
> i design the "User Defined Package" table.
> There are one of the two things that i can do.
> 1) Have a column "customerid" (integer datatype) that will be referencing
> to the customer table and have a "featureid" (integer datatype) column that
> would be referencing "Features" table.
> The problem here is that it would be easily be managable from programming
> aspect but there wil be redundancy factor since if a same customer takes 5
> additional features then there would be 5 rows with same customer id and
> separate featureid and this is just for one customer. If there is a large
> customer base it could create space issues as well.
> 2) Have a column "customerid" (integer datatype) that will be referencing
> to the customer table and have another column featureids (varchar datatype)
> that would have all the additional feature ids seperated by a deliminator.
> There won't be redundancy in this case but would make things little bit
> complicated from programming aspect since everything new additional feature
> to to be added or edited or to be removed will require some work in the
> code.
> Which method should i go for that would be helpful not just now but also in
> future as the customer base increases.
> I do not have anything else in mind. If there is any other solution to this
> all the suggestions are welcomed.
> Thank you
> Niel
I recommend you study some books or take a course on database design
theory before you go further. Your option 2 is a textbook example of
how NOT to do it.
Your first option sounds right to me from the point of view of
scalability and integrity. Of course I haven't had the opportunity to
analyse your business requirements, I only have your narrative to go
on. That's why newsgroups are a poor place to get database design
advice.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Thanks for the suggestion david,
I'll go ahead and have a look at few book for reference. Can you advise me
on any good places/tutorials on website that i can go through to get a clear
concept on this.
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1143574016.274320.221210@.v46g2000cwv.googlegroups.com...
> Niel wrote:
> > I am right now in process of designing a database for hosting business.
Now
> > just like other hosting companies even this hosting companies has its
> > different web hosting packages. But besides that the company is going to
> > provide a feature to customer where in they can select/customize the
package
> > wherein they might want to add one of two additional feature that are
not a
> > part of the standard package.
> > I have designed most of that tables but i am confused on how exactly
should
> > i design the "User Defined Package" table.
> > There are one of the two things that i can do.
> >
> > 1) Have a column "customerid" (integer datatype) that will be
referencing
> > to the customer table and have a "featureid" (integer datatype) column
that
> > would be referencing "Features" table.
> > The problem here is that it would be easily be managable from
programming
> > aspect but there wil be redundancy factor since if a same customer takes
5
> > additional features then there would be 5 rows with same customer id and
> > separate featureid and this is just for one customer. If there is a
large
> > customer base it could create space issues as well.
> >
> > 2) Have a column "customerid" (integer datatype) that will be
referencing
> > to the customer table and have another column featureids (varchar
datatype)
> > that would have all the additional feature ids seperated by a
deliminator.
> > There won't be redundancy in this case but would make things little bit
> > complicated from programming aspect since everything new additional
feature
> > to to be added or edited or to be removed will require some work in the
> > code.
> >
> > Which method should i go for that would be helpful not just now but also
in
> > future as the customer base increases.
> >
> > I do not have anything else in mind. If there is any other solution to
this
> > all the suggestions are welcomed.
> >
> > Thank you
> > Niel
> I recommend you study some books or take a course on database design
> theory before you go further. Your option 2 is a textbook example of
> how NOT to do it.
> Your first option sounds right to me from the point of view of
> scalability and integrity. Of course I haven't had the opportunity to
> analyse your business requirements, I only have your narrative to go
> on. That's why newsgroups are a poor place to get database design
> advice.
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>

Database design issue

Hello folks,

We are developing a datamart to which data comes from different sources (SQL, Sybase, Excel, MDB). There is going to be a refresh process that will do the retrieval.
In the source tables, there are columns that can be nullable.
In the destinaton tables, we are planning to convert all nullable to NOT Null, so that the indexing can be applied and the retrieval will be faster.

But then what default value can we give it for data types Varchar, Numeric and Date.

Is it fine to give Spaces(1) for Varchar and zero for numneric. What do we give for date?

If anyone can give an insight into these questions, i really appreciate it.

Thank you,
VenugopalYou can give '' for the varchar.

Be very careful though as you will be losing information as there will now be no difference between a null and empty string or null and zero numeric. These differences may be meaningful in the source which will now be lost.|||You can index a column that allows NULL values. Only the primary key is not allowed to take NULL values.

blindman|||In the destinaton tables, we are planning to convert all nullable to NOT Null, so that the indexing can be applied and the retrieval will be faster.


Eh?

Columns that contain NULLs can certainly be indexed; they just can't be a primary key. There is no speed issue involved.

The database schema must reflect the requirements of your data. If the original data can contain NULL values, then the repository database must do so also. There is no value whatsoever that you can substitute for "the absence of any value," which is what NULL is.|||And it can't be a unique index...DB2 has an option that allows it, but It doesn'r seems so with SQL Server...unless I'm missing it (WHAT? AGAIN?)

USE Northwind
GO

CREATE TABLE myTable99 (Col1 int, col2 char(10))
GO

CREATE INDEX myIndex1 ON myTable99 (Col1)
GO

INSERT INTO myTable99(Col1, Col2)
SELECT 1, 'A' UNION ALL
SELECT 2, 'B' UNION ALL
SELECT Null, 'C' UNION ALL
SELECT Null, 'D'

SELECT * FROM myTable99
GO

CREATE UNIQUE INDEX myIndex2 ON myTable99 (Col2)
GO

INSERT INTO myTable99(Col1, Col2)
SELECT 1, 'E' UNION ALL
SELECT 2, 'F' UNION ALL
SELECT Null, Null
GO

SELECT * FROM myTable99
GO

INSERT INTO myTable99(Col1, Col2)
SELECT 3, Null
GO

DROP TABLE myTable99
GO

Database Design - 3000+ users

We are in the process to develop a new VB6/SQL 2000 application (do
not ask why not .net, our company policy is to use VB6), which will
have over 3000 users to access the database (50GB data) and perform
heavy add/update on one table. Without the privilege to have a
better/faster server, we have to design database tables in a way to
increase the performance (on updates).
My boss wants to partition the data into different databases based on
defferent users groups (for examples, use users' department). Since
the data now on different databases, the updates for different user
groups would be faster. My concern is that these different databases
will hard to maintain. For example, a same query/stored procedure will
either reside on different
databases or coded with logic to go to different databases before
executing a update. It may better to have one database with multiple
(same structure) tables to store data for different user groups, then
use a (partitioned) view to link all tables (with check constraint
based on user's department number). When update, it would go to
different tables (hence reduce the traffic to tables and increase the
performance).
Thank you in advance for your suggestions.
Yang ZhongWhat makes you think since you have several db's the updates will be faster?
All the databases share the same resources and it doesn't sound like they
will be updating the same row anyway.
--
Andrew J. Kelly SQL MVP
"yang zhong" <Yang_Zhong@.bcbstx.com> wrote in message
news:44d12b2d.0408171318.74348665@.posting.google.com...
> We are in the process to develop a new VB6/SQL 2000 application (do
> not ask why not .net, our company policy is to use VB6), which will
> have over 3000 users to access the database (50GB data) and perform
> heavy add/update on one table. Without the privilege to have a
> better/faster server, we have to design database tables in a way to
> increase the performance (on updates).
> My boss wants to partition the data into different databases based on
> defferent users groups (for examples, use users' department). Since
> the data now on different databases, the updates for different user
> groups would be faster. My concern is that these different databases
> will hard to maintain. For example, a same query/stored procedure will
> either reside on different
> databases or coded with logic to go to different databases before
> executing a update. It may better to have one database with multiple
> (same structure) tables to store data for different user groups, then
> use a (partitioned) view to link all tables (with check constraint
> based on user's department number). When update, it would go to
> different tables (hence reduce the traffic to tables and increase the
> performance).
> Thank you in advance for your suggestions.
> Yang Zhong|||(a) Do these users only access the data that they Insert/Update/Delete? Or,
can they access the data created by other user groups ~ different database?
(b) "perform heavy add/update on one table. Without the privilege to have a".
What kind (vertical / industry) of application is it ? (Different user
groups all updating a single table)
(c) Since all your databases (based on the different user groups) will
reside in one server - there will be no performance benefit when you use
partitioned views.
BUT, is it posisble to have each user group's database sitting on a
different physical disk with its own controller? If YES, then you will get
some of the performance benfits of a partitioned view.
Cheers!|||Since SQL can do row level locking, I suspect there will not be a lot of
locking issues for updates, (assuming single row updates), on a properly
indexed table where the Primary Key is used in the where clause.
Therefore, there may be no reason to go to all of the trouble you are
talking about.
It is certainly worth doing some testing to see!
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"yang zhong" <Yang_Zhong@.bcbstx.com> wrote in message
news:44d12b2d.0408171318.74348665@.posting.google.com...
> We are in the process to develop a new VB6/SQL 2000 application (do
> not ask why not .net, our company policy is to use VB6), which will
> have over 3000 users to access the database (50GB data) and perform
> heavy add/update on one table. Without the privilege to have a
> better/faster server, we have to design database tables in a way to
> increase the performance (on updates).
> My boss wants to partition the data into different databases based on
> defferent users groups (for examples, use users' department). Since
> the data now on different databases, the updates for different user
> groups would be faster. My concern is that these different databases
> will hard to maintain. For example, a same query/stored procedure will
> either reside on different
> databases or coded with logic to go to different databases before
> executing a update. It may better to have one database with multiple
> (same structure) tables to store data for different user groups, then
> use a (partitioned) view to link all tables (with check constraint
> based on user's department number). When update, it would go to
> different tables (hence reduce the traffic to tables and increase the
> performance).
> Thank you in advance for your suggestions.
> Yang Zhong

Database Design - 3000+ users

We are in the process to develop a new VB6/SQL 2000 application (do
not ask why not .net, our company policy is to use VB6), which will
have over 3000 users to access the database (50GB data) and perform
heavy add/update on one table. Without the privilege to have a
better/faster server, we have to design database tables in a way to
increase the performance (on updates).
My boss wants to partition the data into different databases based on
defferent users groups (for examples, use users' department). Since
the data now on different databases, the updates for different user
groups would be faster. My concern is that these different databases
will hard to maintain. For example, a same query/stored procedure will
either reside on different
databases or coded with logic to go to different databases before
executing a update. It may better to have one database with multiple
(same structure) tables to store data for different user groups, then
use a (partitioned) view to link all tables (with check constraint
based on user's department number). When update, it would go to
different tables (hence reduce the traffic to tables and increase the
performance).
Thank you in advance for your suggestions.
Yang Zhong
What makes you think since you have several db's the updates will be faster?
All the databases share the same resources and it doesn't sound like they
will be updating the same row anyway.
Andrew J. Kelly SQL MVP
"yang zhong" <Yang_Zhong@.bcbstx.com> wrote in message
news:44d12b2d.0408171318.74348665@.posting.google.c om...
> We are in the process to develop a new VB6/SQL 2000 application (do
> not ask why not .net, our company policy is to use VB6), which will
> have over 3000 users to access the database (50GB data) and perform
> heavy add/update on one table. Without the privilege to have a
> better/faster server, we have to design database tables in a way to
> increase the performance (on updates).
> My boss wants to partition the data into different databases based on
> defferent users groups (for examples, use users' department). Since
> the data now on different databases, the updates for different user
> groups would be faster. My concern is that these different databases
> will hard to maintain. For example, a same query/stored procedure will
> either reside on different
> databases or coded with logic to go to different databases before
> executing a update. It may better to have one database with multiple
> (same structure) tables to store data for different user groups, then
> use a (partitioned) view to link all tables (with check constraint
> based on user's department number). When update, it would go to
> different tables (hence reduce the traffic to tables and increase the
> performance).
> Thank you in advance for your suggestions.
> Yang Zhong
|||Since SQL can do row level locking, I suspect there will not be a lot of
locking issues for updates, (assuming single row updates), on a properly
indexed table where the Primary Key is used in the where clause.
Therefore, there may be no reason to go to all of the trouble you are
talking about.
It is certainly worth doing some testing to see!
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"yang zhong" <Yang_Zhong@.bcbstx.com> wrote in message
news:44d12b2d.0408171318.74348665@.posting.google.c om...
> We are in the process to develop a new VB6/SQL 2000 application (do
> not ask why not .net, our company policy is to use VB6), which will
> have over 3000 users to access the database (50GB data) and perform
> heavy add/update on one table. Without the privilege to have a
> better/faster server, we have to design database tables in a way to
> increase the performance (on updates).
> My boss wants to partition the data into different databases based on
> defferent users groups (for examples, use users' department). Since
> the data now on different databases, the updates for different user
> groups would be faster. My concern is that these different databases
> will hard to maintain. For example, a same query/stored procedure will
> either reside on different
> databases or coded with logic to go to different databases before
> executing a update. It may better to have one database with multiple
> (same structure) tables to store data for different user groups, then
> use a (partitioned) view to link all tables (with check constraint
> based on user's department number). When update, it would go to
> different tables (hence reduce the traffic to tables and increase the
> performance).
> Thank you in advance for your suggestions.
> Yang Zhong

Database Design - 3000+ users

We are in the process to develop a new VB6/SQL 2000 application (do
not ask why not .net, our company policy is to use VB6), which will
have over 3000 users to access the database (50GB data) and perform
heavy add/update on one table. Without the privilege to have a
better/faster server, we have to design database tables in a way to
increase the performance (on updates).
My boss wants to partition the data into different databases based on
defferent users groups (for examples, use users' department). Since
the data now on different databases, the updates for different user
groups would be faster. My concern is that these different databases
will hard to maintain. For example, a same query/stored procedure will
either reside on different
databases or coded with logic to go to different databases before
executing a update. It may better to have one database with multiple
(same structure) tables to store data for different user groups, then
use a (partitioned) view to link all tables (with check constraint
based on user's department number). When update, it would go to
different tables (hence reduce the traffic to tables and increase the
performance).
Thank you in advance for your suggestions.
Yang ZhongWhat makes you think since you have several db's the updates will be faster?
All the databases share the same resources and it doesn't sound like they
will be updating the same row anyway.
Andrew J. Kelly SQL MVP
"yang zhong" <Yang_Zhong@.bcbstx.com> wrote in message
news:44d12b2d.0408171318.74348665@.posting.google.com...
> We are in the process to develop a new VB6/SQL 2000 application (do
> not ask why not .net, our company policy is to use VB6), which will
> have over 3000 users to access the database (50GB data) and perform
> heavy add/update on one table. Without the privilege to have a
> better/faster server, we have to design database tables in a way to
> increase the performance (on updates).
> My boss wants to partition the data into different databases based on
> defferent users groups (for examples, use users' department). Since
> the data now on different databases, the updates for different user
> groups would be faster. My concern is that these different databases
> will hard to maintain. For example, a same query/stored procedure will
> either reside on different
> databases or coded with logic to go to different databases before
> executing a update. It may better to have one database with multiple
> (same structure) tables to store data for different user groups, then
> use a (partitioned) view to link all tables (with check constraint
> based on user's department number). When update, it would go to
> different tables (hence reduce the traffic to tables and increase the
> performance).
> Thank you in advance for your suggestions.
> Yang Zhong|||Since SQL can do row level locking, I suspect there will not be a lot of
locking issues for updates, (assuming single row updates), on a properly
indexed table where the Primary Key is used in the where clause.
Therefore, there may be no reason to go to all of the trouble you are
talking about.
It is certainly worth doing some testing to see!
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"yang zhong" <Yang_Zhong@.bcbstx.com> wrote in message
news:44d12b2d.0408171318.74348665@.posting.google.com...
> We are in the process to develop a new VB6/SQL 2000 application (do
> not ask why not .net, our company policy is to use VB6), which will
> have over 3000 users to access the database (50GB data) and perform
> heavy add/update on one table. Without the privilege to have a
> better/faster server, we have to design database tables in a way to
> increase the performance (on updates).
> My boss wants to partition the data into different databases based on
> defferent users groups (for examples, use users' department). Since
> the data now on different databases, the updates for different user
> groups would be faster. My concern is that these different databases
> will hard to maintain. For example, a same query/stored procedure will
> either reside on different
> databases or coded with logic to go to different databases before
> executing a update. It may better to have one database with multiple
> (same structure) tables to store data for different user groups, then
> use a (partitioned) view to link all tables (with check constraint
> based on user's department number). When update, it would go to
> different tables (hence reduce the traffic to tables and increase the
> performance).
> Thank you in advance for your suggestions.
> Yang Zhong

Database corrupted

Hello there
My database has been currupted: i'm getting error of:
SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
When i run checkdb i'm getting error:
Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
syscolumns, or systypes prevent further CHECKDB processing.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Now i'm restoring my old db. what can cause this error and how can i prevent
from having this error?This error occurs due to hardware failure in most cases . Have you looked
at sql server's log file ,any records?
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
> Hello there
> My database has been currupted: i'm getting error of:
> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
> When i run checkdb i'm getting error:
> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
> syscolumns, or systypes prevent further CHECKDB processing.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> Now i'm restoring my old db. what can cause this error and how can i
> prevent from having this error?
>|||How can i look for sql server log files?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
> This error occurs due to hardware failure in most cases . Have you looked
> at sql server's log file ,any records?
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
>> Hello there
>> My database has been currupted: i'm getting error of:
>> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
>> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
>> When i run checkdb i'm getting error:
>> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
>> syscolumns, or systypes prevent further CHECKDB processing.
>> DBCC execution completed. If DBCC printed error messages, contact your
>> system administrator.
>> Now i'm restoring my old db. what can cause this error and how can i
>> prevent from having this error?
>>
>|||C:\Program Files\Microsoft SQL Server\MSSQL\LOG
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
> How can i look for sql server log files?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
>> This error occurs due to hardware failure in most cases . Have you
>> looked at sql server's log file ,any records?
>>
>>
>> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
>> news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
>> Hello there
>> My database has been currupted: i'm getting error of:
>> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
>> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
>> When i run checkdb i'm getting error:
>> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
>> syscolumns, or systypes prevent further CHECKDB processing.
>> DBCC execution completed. If DBCC printed error messages, contact your
>> system administrator.
>> Now i'm restoring my old db. what can cause this error and how can i
>> prevent from having this error?
>>
>>
>|||Whell Uri
It worst then i thought.
there are more then 5000 text files with SQLDumpxxxx.text
And i'm getting many messages that many data has gone lost.
where can i start investigate it?
there is huge list of files on the LOG
and there are
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ORN1gytFHHA.4116@.TK2MSFTNGP05.phx.gbl...
> C:\Program Files\Microsoft SQL Server\MSSQL\LOG
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
>> How can i look for sql server log files?
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
>> This error occurs due to hardware failure in most cases . Have you
>> looked at sql server's log file ,any records?
>>
>>
>> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
>> news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
>> Hello there
>> My database has been currupted: i'm getting error of:
>> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
>> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
>> When i run checkdb i'm getting error:
>> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
>> syscolumns, or systypes prevent further CHECKDB processing.
>> DBCC execution completed. If DBCC printed error messages, contact your
>> system administrator.
>> Now i'm restoring my old db. what can cause this error and how can i
>> prevent from having this error?
>>
>>
>>
>|||Open the ERROR.LOG and lookup for specific date. It should be at the bottom
of the file
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:e4CM6EuFHHA.1804@.TK2MSFTNGP02.phx.gbl...
> Whell Uri
> It worst then i thought.
> there are more then 5000 text files with SQLDumpxxxx.text
> And i'm getting many messages that many data has gone lost.
> where can i start investigate it?
>
> there is huge list of files on the LOG
> and there are
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ORN1gytFHHA.4116@.TK2MSFTNGP05.phx.gbl...
>> C:\Program Files\Microsoft SQL Server\MSSQL\LOG
>>
>>
>> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
>> news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
>> How can i look for sql server log files?
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
>> This error occurs due to hardware failure in most cases . Have you
>> looked at sql server's log file ,any records?
>>
>>
>> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
>> news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
>> Hello there
>> My database has been currupted: i'm getting error of:
>> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
>> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
>> When i run checkdb i'm getting error:
>> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
>> syscolumns, or systypes prevent further CHECKDB processing.
>> DBCC execution completed. If DBCC printed error messages, contact your
>> system administrator.
>> Now i'm restoring my old db. what can cause this error and how can i
>> prevent from having this error?
>>
>>
>>
>>
>|||did you got the mail i send to you?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e3yy4NuFHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Open the ERROR.LOG and lookup for specific date. It should be at the
> bottom of the file
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:e4CM6EuFHHA.1804@.TK2MSFTNGP02.phx.gbl...
>> Whell Uri
>> It worst then i thought.
>> there are more then 5000 text files with SQLDumpxxxx.text
>> And i'm getting many messages that many data has gone lost.
>> where can i start investigate it?
>>
>> there is huge list of files on the LOG
>> and there are
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:ORN1gytFHHA.4116@.TK2MSFTNGP05.phx.gbl...
>> C:\Program Files\Microsoft SQL Server\MSSQL\LOG
>>
>>
>> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
>> news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
>> How can i look for sql server log files?
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
>> This error occurs due to hardware failure in most cases . Have you
>> looked at sql server's log file ,any records?
>>
>>
>> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
>> news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
>> Hello there
>> My database has been currupted: i'm getting error of:
>> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
>> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
>> When i run checkdb i'm getting error:
>> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
>> syscolumns, or systypes prevent further CHECKDB processing.
>> DBCC execution completed. If DBCC printed error messages, contact
>> your system administrator.
>> Now i'm restoring my old db. what can cause this error and how can i
>> prevent from having this error?
>>
>>
>>
>>
>>
>|||To avoid this in future make sure to check the hardware, might involve your
hardware vendor to check the drives on the server to see there is no
corruption.
Roy Goldhammer wrote:
>did you got the mail i send to you?
>> Open the ERROR.LOG and lookup for specific date. It should be at the
>> bottom of the file
>[quoted text clipped - 32 lines]
>>> Now i'm restoring my old db. what can cause this error and how can i
>>> prevent from having this error?

Database corrupted

Hello there
My database has been currupted: i'm getting error of:
SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
When i run checkdb i'm getting error:
Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
syscolumns, or systypes prevent further CHECKDB processing.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Now i'm restoring my old db. what can cause this error and how can i prevent
from having this error?
This error occurs due to hardware failure in most cases . Have you looked
at sql server's log file ,any records?
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
> Hello there
> My database has been currupted: i'm getting error of:
> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
> When i run checkdb i'm getting error:
> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
> syscolumns, or systypes prevent further CHECKDB processing.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> Now i'm restoring my old db. what can cause this error and how can i
> prevent from having this error?
>
|||How can i look for sql server log files?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
> This error occurs due to hardware failure in most cases . Have you looked
> at sql server's log file ,any records?
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
>
|||C:\Program Files\Microsoft SQL Server\MSSQL\LOG
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
> How can i look for sql server log files?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
>
|||Whell Uri
It worst then i thought.
there are more then 5000 text files with SQLDumpxxxx.text
And i'm getting many messages that many data has gone lost.
where can i start investigate it?
there is huge list of files on the LOG
and there are
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ORN1gytFHHA.4116@.TK2MSFTNGP05.phx.gbl...
> C:\Program Files\Microsoft SQL Server\MSSQL\LOG
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
>
|||Open the ERROR.LOG and lookup for specific date. It should be at the bottom
of the file
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:e4CM6EuFHHA.1804@.TK2MSFTNGP02.phx.gbl...
> Whell Uri
> It worst then i thought.
> there are more then 5000 text files with SQLDumpxxxx.text
> And i'm getting many messages that many data has gone lost.
> where can i start investigate it?
>
> there is huge list of files on the LOG
> and there are
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ORN1gytFHHA.4116@.TK2MSFTNGP05.phx.gbl...
>
|||did you got the mail i send to you?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e3yy4NuFHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Open the ERROR.LOG and lookup for specific date. It should be at the
> bottom of the file
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:e4CM6EuFHHA.1804@.TK2MSFTNGP02.phx.gbl...
>
|||To avoid this in future make sure to check the hardware, might involve your
hardware vendor to check the drives on the server to see there is no
corruption.
Roy Goldhammer wrote:[vbcol=seagreen]
>did you got the mail i send to you?
>[quoted text clipped - 32 lines]

Database corrupted

Hello there
My database has been currupted: i'm getting error of:
SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
When i run checkdb i'm getting error:
Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
syscolumns, or systypes prevent further CHECKDB processing.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Now i'm restoring my old db. what can cause this error and how can i prevent
from having this error?This error occurs due to hardware failure in most cases . Have you looked
at sql server's log file ,any records?
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
> Hello there
> My database has been currupted: i'm getting error of:
> SqlDumpExeptionHandler: Process 60 generated fatal exeption c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL server is termination the process
> When i run checkdb i'm getting error:
> Database 'PTS_Test' consistency errors in sysobjects, sysindexes,
> syscolumns, or systypes prevent further CHECKDB processing.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> Now i'm restoring my old db. what can cause this error and how can i
> prevent from having this error?
>|||How can i look for sql server log files?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
> This error occurs due to hardware failure in most cases . Have you looked
> at sql server's log file ,any records?
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:%23Z2LDitFHHA.1276@.TK2MSFTNGP04.phx.gbl...
>|||C:\Program Files\Microsoft SQL Server\MSSQL\LOG
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
> How can i look for sql server log files?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OJNdMltFHHA.320@.TK2MSFTNGP06.phx.gbl...
>|||Whell Uri
It worst then i thought.
there are more then 5000 text files with SQLDumpxxxx.text
And i'm getting many messages that many data has gone lost.
where can i start investigate it?
there is huge list of files on the LOG
and there are
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ORN1gytFHHA.4116@.TK2MSFTNGP05.phx.gbl...
> C:\Program Files\Microsoft SQL Server\MSSQL\LOG
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:OepdXttFHHA.5004@.TK2MSFTNGP03.phx.gbl...
>|||Open the ERROR.LOG and lookup for specific date. It should be at the bottom
of the file
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:e4CM6EuFHHA.1804@.TK2MSFTNGP02.phx.gbl...
> Whell Uri
> It worst then i thought.
> there are more then 5000 text files with SQLDumpxxxx.text
> And i'm getting many messages that many data has gone lost.
> where can i start investigate it?
>
> there is huge list of files on the LOG
> and there are
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ORN1gytFHHA.4116@.TK2MSFTNGP05.phx.gbl...
>|||did you got the mail i send to you?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e3yy4NuFHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Open the ERROR.LOG and lookup for specific date. It should be at the
> bottom of the file
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:e4CM6EuFHHA.1804@.TK2MSFTNGP02.phx.gbl...
>|||To avoid this in future make sure to check the hardware, might involve your
hardware vendor to check the drives on the server to see there is no
corruption.
Roy Goldhammer wrote:[vbcol=seagreen]
>did you got the mail i send to you?
>
>[quoted text clipped - 32 lines]