Database Sizing

I need to convert a hierarchical database and a Siebel
Relational database to SQL a Relational database. I
currently have two databases list below:
29,151,892 MB = hierarchical database
8,222,178 MB = Siebel Relational database
About what size of a database would this be in SQL?Hi,
Storage depends up on the way you are going to redesign when you move it to
SQL Server. If it is going to be Siebel to SQL Server direct
loading then the storage will be almost identical, but whn you create
indexes the storawill go high. So I recommend you to have atleast double the
size of
current database projecting the data growth as well.
For the Hierarchical database you might require a new relationa redesin.
This will re-use the storage and may not require more space. So probably you
can have 1.5 times of current size to hold the indexes and new data.
All these are just assumptions. To get it almost correct value you have to
do some small calculations based on the books online topic "Estimating the
Size of a Table".
--
Thanks
Hari
MCDBA
"Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:2a07601c46542$92b74df0$a301280a@.phx.gbl...
> I need to convert a hierarchical database and a Siebel
> Relational database to SQL a Relational database. I
> currently have two databases list below:
> 29,151,892 MB = hierarchical database
> 8,222,178 MB = Siebel Relational database
> About what size of a database would this be in SQL?
>

Database setting

. The BPA recommend that the model database setting for the items below be set to on. I can accomplish this task through the query analyzer and run the set command. (Set ANSI_NULLS on). The response is positive but when I re-run the report the setting are back off.

Why?

QUOTED_IDENTIFIER
ANSI_NULLS
ANSI_WARNINGS
ANSI_PADDING
ANSI_NULL_DFLT_ON
CONCAT_NULL_YIELDS_NULLDon't the setting only last for the scope of the session?

That's why they have to be coded inside the sporcs?

I'll have to look a more defenitive answer...but I'll just be fgetting from BOL|||Garry,

Those settings are only taking effect for that single session i.e. within Query Analyzer.

To make any permanent changes to the model database, you need to right click it in Query Analyzer and check the options under properties. You should save a copy of the database first in case you should find that you need to return to the default settings.

Please note carefully this article in case you need to reattach your model database:

http://support.microsoft.com/?id=224071

We would advise leaving the model database at default settings.

Use the following from Query Analyzer to check the settings:
Sp_helpdb
And also check for databaseproperty in Books Online
Syntax
DATABASEPROPERTY( database , property )

USE master

SELECT DATABASEPROPERTY('model', 'IsANSINullDEFAULT')|||Well its up to you, but most people would leave the model database alone. It depends on your particular needs more than anything else. Remember the model database is only a template used to create new databases, so if you are bringing databases to this machine from another server, then the model database settings will have no effect.

Any conflict here is due to ANSI compatibility levels. SQL Server does not always default to the ANSI compatible levels.

Please review this article for a note on the various database settings and their effects:-

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_03_6ohf.asp

These two commands give you information on your current connection details, and on the database settings that may be configured respectively:-

sp_dboption

dbcc useroptions|||why did you post the question if you already had the answer?|||Perhaps it was a rhetorical question?

Read the top of his posts. He was just copying information from MicroCoughed.sql

Database Restore Error - URGENT

I am trying to restore a database sent from a client and getting the below
error in the process:
Server: Msg 3270, Level 16, State 1, Line 1
An internal consistency error occurred. Contact Technical Support for
assistance.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Any ideas why ?.
It is a SQL Server 2000 backup going into another SQL Server 2000 server.
Thanks.DXC,
If their database is in an inconsistent state, the backup will carry that
state to you. They should run DBCC CHECKDB on their database to try to
determine what is wrong, fix it if possible, then send you a new backup.
RLF
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:267D80B1-6158-43C5-9252-46B8BCD169DE@.microsoft.com...
>I am trying to restore a database sent from a client and getting the below
> error in the process:
> Server: Msg 3270, Level 16, State 1, Line 1
> An internal consistency error occurred. Contact Technical Support for
> assistance.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Any ideas why ?.
> It is a SQL Server 2000 backup going into another SQL Server 2000 server.
> Thanks.|||Russell, Thanks for the quick reply...........Also, I get the following
message when I run RESTORE VERIFYONLY.
Server: Msg 3242, Level 16, State 2, Line 1
The file on device 'D:\MTTBRP7_db_200802182100.BAK' is not a valid Microsoft
Tape Format backup set.
Server: Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
"Russell Fields" wrote:
> DXC,
> If their database is in an inconsistent state, the backup will carry that
> state to you. They should run DBCC CHECKDB on their database to try to
> determine what is wrong, fix it if possible, then send you a new backup.
> RLF
> "DXC" <DXC@.discussions.microsoft.com> wrote in message
> news:267D80B1-6158-43C5-9252-46B8BCD169DE@.microsoft.com...
> >I am trying to restore a database sent from a client and getting the below
> > error in the process:
> >
> > Server: Msg 3270, Level 16, State 1, Line 1
> > An internal consistency error occurred. Contact Technical Support for
> > assistance.
> > Server: Msg 3013, Level 16, State 1, Line 1
> > RESTORE DATABASE is terminating abnormally.
> >
> > Any ideas why ?.
> >
> > It is a SQL Server 2000 backup going into another SQL Server 2000 server.
> >
> > Thanks.
>
>|||DXC,
Sorry, I don't really know, but here are a couple of posts that might help
you think of something. (I don't suppose that this backup is from SQL
Server 6.5 or earlier, is it?)
http://msdn2.microsoft.com/en-us/library/aa238234(SQL.80).aspx
http://support.microsoft.com/?kbid=905616
http://www.webservertalk.com/archive132-2004-7-330939.html
RLF
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:8803F9CE-B0A1-4E5B-A39F-BF73DFDBC1C0@.microsoft.com...
> Russell, Thanks for the quick reply...........Also, I get the following
> message when I run RESTORE VERIFYONLY.
> Server: Msg 3242, Level 16, State 2, Line 1
> The file on device 'D:\MTTBRP7_db_200802182100.BAK' is not a valid
> Microsoft
> Tape Format backup set.
> Server: Msg 3013, Level 16, State 1, Line 1
> VERIFY DATABASE is terminating abnormally.
>
> "Russell Fields" wrote:
>> DXC,
>> If their database is in an inconsistent state, the backup will carry that
>> state to you. They should run DBCC CHECKDB on their database to try to
>> determine what is wrong, fix it if possible, then send you a new backup.
>> RLF
>> "DXC" <DXC@.discussions.microsoft.com> wrote in message
>> news:267D80B1-6158-43C5-9252-46B8BCD169DE@.microsoft.com...
>> >I am trying to restore a database sent from a client and getting the
>> >below
>> > error in the process:
>> >
>> > Server: Msg 3270, Level 16, State 1, Line 1
>> > An internal consistency error occurred. Contact Technical Support for
>> > assistance.
>> > Server: Msg 3013, Level 16, State 1, Line 1
>> > RESTORE DATABASE is terminating abnormally.
>> >
>> > Any ideas why ?.
>> >
>> > It is a SQL Server 2000 backup going into another SQL Server 2000
>> > server.
>> >
>> > Thanks.
>>|||No it is not. It is from SQL Server 2000 server............Thanks......
"Russell Fields" wrote:
> DXC,
> Sorry, I don't really know, but here are a couple of posts that might help
> you think of something. (I don't suppose that this backup is from SQL
> Server 6.5 or earlier, is it?)
> http://msdn2.microsoft.com/en-us/library/aa238234(SQL.80).aspx
> http://support.microsoft.com/?kbid=905616
> http://www.webservertalk.com/archive132-2004-7-330939.html
> RLF
> "DXC" <DXC@.discussions.microsoft.com> wrote in message
> news:8803F9CE-B0A1-4E5B-A39F-BF73DFDBC1C0@.microsoft.com...
> > Russell, Thanks for the quick reply...........Also, I get the following
> > message when I run RESTORE VERIFYONLY.
> >
> > Server: Msg 3242, Level 16, State 2, Line 1
> > The file on device 'D:\MTTBRP7_db_200802182100.BAK' is not a valid
> > Microsoft
> > Tape Format backup set.
> > Server: Msg 3013, Level 16, State 1, Line 1
> > VERIFY DATABASE is terminating abnormally.
> >
> >
> > "Russell Fields" wrote:
> >
> >> DXC,
> >>
> >> If their database is in an inconsistent state, the backup will carry that
> >> state to you. They should run DBCC CHECKDB on their database to try to
> >> determine what is wrong, fix it if possible, then send you a new backup.
> >>
> >> RLF
> >>
> >> "DXC" <DXC@.discussions.microsoft.com> wrote in message
> >> news:267D80B1-6158-43C5-9252-46B8BCD169DE@.microsoft.com...
> >> >I am trying to restore a database sent from a client and getting the
> >> >below
> >> > error in the process:
> >> >
> >> > Server: Msg 3270, Level 16, State 1, Line 1
> >> > An internal consistency error occurred. Contact Technical Support for
> >> > assistance.
> >> > Server: Msg 3013, Level 16, State 1, Line 1
> >> > RESTORE DATABASE is terminating abnormally.
> >> >
> >> > Any ideas why ?.
> >> >
> >> > It is a SQL Server 2000 backup going into another SQL Server 2000
> >> > server.
> >> >
> >> > Thanks.
> >>
> >>
> >>
>
>|||DXC,
I don't know what else to do except get another backup from them. Were you
able to do that and did it work?
RLF
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:FFA04E40-48DA-4590-9832-EC44415EFFDB@.microsoft.com...
> No it is not. It is from SQL Server 2000
> server............Thanks......
> "Russell Fields" wrote:
>> DXC,
>> Sorry, I don't really know, but here are a couple of posts that might
>> help
>> you think of something. (I don't suppose that this backup is from SQL
>> Server 6.5 or earlier, is it?)
>> http://msdn2.microsoft.com/en-us/library/aa238234(SQL.80).aspx
>> http://support.microsoft.com/?kbid=905616
>> http://www.webservertalk.com/archive132-2004-7-330939.html
>> RLF
>> "DXC" <DXC@.discussions.microsoft.com> wrote in message
>> news:8803F9CE-B0A1-4E5B-A39F-BF73DFDBC1C0@.microsoft.com...
>> > Russell, Thanks for the quick reply...........Also, I get the
>> > following
>> > message when I run RESTORE VERIFYONLY.
>> >
>> > Server: Msg 3242, Level 16, State 2, Line 1
>> > The file on device 'D:\MTTBRP7_db_200802182100.BAK' is not a valid
>> > Microsoft
>> > Tape Format backup set.
>> > Server: Msg 3013, Level 16, State 1, Line 1
>> > VERIFY DATABASE is terminating abnormally.
>> >
>> >
>> > "Russell Fields" wrote:
>> >
>> >> DXC,
>> >>
>> >> If their database is in an inconsistent state, the backup will carry
>> >> that
>> >> state to you. They should run DBCC CHECKDB on their database to try
>> >> to
>> >> determine what is wrong, fix it if possible, then send you a new
>> >> backup.
>> >>
>> >> RLF
>> >>
>> >> "DXC" <DXC@.discussions.microsoft.com> wrote in message
>> >> news:267D80B1-6158-43C5-9252-46B8BCD169DE@.microsoft.com...
>> >> >I am trying to restore a database sent from a client and getting the
>> >> >below
>> >> > error in the process:
>> >> >
>> >> > Server: Msg 3270, Level 16, State 1, Line 1
>> >> > An internal consistency error occurred. Contact Technical Support
>> >> > for
>> >> > assistance.
>> >> > Server: Msg 3013, Level 16, State 1, Line 1
>> >> > RESTORE DATABASE is terminating abnormally.
>> >> >
>> >> > Any ideas why ?.
>> >> >
>> >> > It is a SQL Server 2000 backup going into another SQL Server 2000
>> >> > server.
>> >> >
>> >> > Thanks.
>> >>
>> >>
>> >>
>>

Database Resoration Error

Hi
I am getting the below error message when I restore the database.
Error Message
==========
Could not find stored procedure 'dbo_ss.dbo.sp_MSremovedbreplication'.
Could not adjust the replication state of database 'db_sss'. The database wa
s successfully
restored, however its replication state is inderminate. See the Troubleshoot
ing Replication secion in SQL Server Books Online.
RESTORE DATABASE successfully processed 10201 pages in 38.883 secounds(2.466
MB/sec
SQL Server Edition
============
MSDE with SP3
Operating System
============
Windows 2000 ProfessionalStupid question, but did you go through the troubleshooting section, as per
the error message recommendation? If that didn't help, I recommend you post
to the replication group.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Balaji Prabhu.T" <anonymous@.discussions.microsoft.com> wrote in message
news:36AF45C6-BB29-411B-A6AD-9ADF6599E830@.microsoft.com...
> Hi
> I am getting the below error message when I restore the database.
> Error Message
> ==========
> Could not find stored procedure 'dbo_ss.dbo.sp_MSremovedbreplication'.
> Could not adjust the replication state of database 'db_sss'. The database
was successfully
> restored, however its replication state is inderminate. See the
Troubleshooting Replication secion in SQL Server Books Online.
> RESTORE DATABASE successfully processed 10201 pages in 38.883
secounds(2.466MB/sec
> SQL Server Edition
> ============
> MSDE with SP3
> Operating System
> ============
> Windows 2000 Professional
>

Database remove/delete

How can I remove/delete a database.

I try (below) but not work:

Dim wServer As New Server(strSqlName)

wServer.Databases("DataBaseName").Drop()

Thanks,

Try defining a Database object first, as in this sample:

Dim srv1 As Server
srv1 = New Server("MyServer")
'Define a Database object variable
Dim db1 As Database
'Reference the database
db1 = srv1.Databases("Test_Database")
Console.WriteLine(db1.CreateDate)
'Remove the database.
db1.Drop()

I've tested this and it works.

|||

Thanks Allen.

Very good.

I am tested too and it works very well.

Marsenne