OpenXML Identity Insert: databases

Showing posts with label databases. Show all posts

Wednesday, March 21, 2012

Optimization Job fails

Hi everyone,
We have more than 100 databases on one SQL Server instance and all databases
are backed up and optimised in the nightly maintenance plan.
I copied a new database in this instance that has some computed columns in
few tables. Now, I'm getting this error in daily maintenance plan's
optimization job that it failed because "Quoted_Identifier" is OFF.
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL
Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET
options have incorrect settings: 'QUOTED_IDENTIFIER'.
Any idea/help to overcome this situation. I have some other databases with
computed columns and have same set of database options. There is no problem
with those databases. Only one database is causing this. Any idea ?
Thanks in advance.Sqlmaint.exe does not set quoted_identified on by default. You should create
a T-SQL job which sets this option. See
http://support.microsoft.com/default.aspx?scid=kb;en-us;301292 for a similar
problem.
Adrian
"Ahmed" <Ahmed@.discussions.microsoft.com> wrote in message
news:1E48F884-3DBD-465E-BDB9-0D0B110BA832@.microsoft.com...
> Hi everyone,
> We have more than 100 databases on one SQL Server instance and all
> databases
> are backed up and optimised in the nightly maintenance plan.
> I copied a new database in this instance that has some computed columns in
> few tables. Now, I'm getting this error in daily maintenance plan's
> optimization job that it failed because "Quoted_Identifier" is OFF.
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC
> SQL
> Server Driver][SQL Server]UPDATE STATISTICS failed because the following
> SET
> options have incorrect settings: 'QUOTED_IDENTIFIER'.
> Any idea/help to overcome this situation. I have some other databases with
> computed columns and have same set of database options. There is no
> problem
> with those databases. Only one database is causing this. Any idea ?
> Thanks in advance.
>

Optimization Job fails

Hi everyone,
We have more than 100 databases on one SQL Server instance and all databases
are backed up and optimised in the nightly maintenance plan.
I copied a new database in this instance that has some computed columns in
few tables. Now, I'm getting this error in daily maintenance plan's
optimization job that it failed because "Quoted_Identifier" is OFF.
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL
Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET
options have incorrect settings: 'QUOTED_IDENTIFIER'.
Any idea/help to overcome this situation. I have some other databases with
computed columns and have same set of database options. There is no problem
with those databases. Only one database is causing this. Any idea ?
Thanks in advance.
Sqlmaint.exe does not set quoted_identified on by default. You should create
a T-SQL job which sets this option. See
http://support.microsoft.com/default...b;en-us;301292 for a similar
problem.
Adrian
"Ahmed" <Ahmed@.discussions.microsoft.com> wrote in message
news:1E48F884-3DBD-465E-BDB9-0D0B110BA832@.microsoft.com...
> Hi everyone,
> We have more than 100 databases on one SQL Server instance and all
> databases
> are backed up and optimised in the nightly maintenance plan.
> I copied a new database in this instance that has some computed columns in
> few tables. Now, I'm getting this error in daily maintenance plan's
> optimization job that it failed because "Quoted_Identifier" is OFF.
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC
> SQL
> Server Driver][SQL Server]UPDATE STATISTICS failed because the following
> SET
> options have incorrect settings: 'QUOTED_IDENTIFIER'.
> Any idea/help to overcome this situation. I have some other databases with
> computed columns and have same set of database options. There is no
> problem
> with those databases. Only one database is causing this. Any idea ?
> Thanks in advance.
>

Optimization Job fails

Hi everyone,
We have more than 100 databases on one SQL Server instance and all databases
are backed up and optimised in the nightly maintenance plan.
I copied a new database in this instance that has some computed columns in
few tables. Now, I'm getting this error in daily maintenance plan's
optimization job that it failed because "Quoted_Identifier" is OFF.
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]UPDATE STATISTICS failed because the following
SET
options have incorrect settings: 'QUOTED_IDENTIFIER'.
Any idea/help to overcome this situation. I have some other databases with
computed columns and have same set of database options. There is no problem
with those databases. Only one database is causing this. Any idea ?
Thanks in advance.Sqlmaint.exe does not set quoted_identified on by default. You should create
a T-SQL job which sets this option. See
http://support.microsoft.com/defaul...kb;en-us;301292 for a similar
problem.
Adrian
"Ahmed" <Ahmed@.discussions.microsoft.com> wrote in message
news:1E48F884-3DBD-465E-BDB9-0D0B110BA832@.microsoft.com...
> Hi everyone,
> We have more than 100 databases on one SQL Server instance and all
> databases
> are backed up and optimised in the nightly maintenance plan.
> I copied a new database in this instance that has some computed columns in
> few tables. Now, I'm getting this error in daily maintenance plan's
> optimization job that it failed because "Quoted_Identifier" is OFF.
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft]
[ODBC
> SQL
> Server Driver][SQL Server]UPDATE STATISTICS failed because the followi
ng
> SET
> options have incorrect settings: 'QUOTED_IDENTIFIER'.
> Any idea/help to overcome this situation. I have some other databases with
> computed columns and have same set of database options. There is no
> problem
> with those databases. Only one database is causing this. Any idea ?
> Thanks in advance.
>

Tuesday, March 20, 2012

Optimization and Integrity question

Hi,
I have set up a database maintenance plan for all the databases on a server
that takes care of the Optimization and Integrity every week on the weekends.
However, it's been failing consistently for the past couple of weeks. This is
how it's been set up:
FOR OPTIMIZATIONS
Reorganize data and index pages
Reorganize pages with the original amount of free space
and for INTEGRITY CHECKS
Check Database Integrity
Include Indexes
This is the message in the error log file for optimizations:
(null)
(null)
[16] Database TestMS: Index Rebuild (leaving 100%% free space)...
(null)
(null)
(null)
Rebuilding indexes for table 'tblData'
(null)
(null)
** Execution Time: 0 hrs, 0 mins, 1 secs **
(null)
(null)
End of maintenance plan 'DB Maintenance Plan1' on 4/23/2007 9:48:31 PM
(null)
SQLMAINT.EXE Process Exit Code: 1 (Failed)
(null)
Msg 22029, Sev 16: sqlmaint.exe failed. [SQLSTATE 42000]
and this is the message in the error log file for Integrity:
(null)
(null)
[16] Database TestMS: Check Data and Index Linkage...
(null)
(null)
** Execution Time: 0 hrs, 0 mins, 1 secs **
(null)
(null)
End of maintenance plan 'DB Maintenance Plan1' on 4/23/2007 9:56:25 PM
(null)
SQLMAINT.EXE Process Exit Code: 1 (Failed)
(null)
Msg 22029, Sev 16: sqlmaint.exe failed. [SQLSTATE 42000]
Any help will be greatly appreciated. Thanks.These are just some ideas:
1)Check to see none of the dbs upon which you are attempting this
maintenance plan are either : corrupt or off line
2)Check the compatibility levels are to low
3)Hard disk full
--
Jack Vamvas
___________________________________
Need an IT job? <a href="http://links.10026.com/?link=uk/">http://www.itjobfeed.com">uk it jobs</a>
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:C9D6FB45-77F3-418F-8508-0439665AFFE4@.microsoft.com...
> Hi,
> I have set up a database maintenance plan for all the databases on a
> server
> that takes care of the Optimization and Integrity every week on the
> weekends.
> However, it's been failing consistently for the past couple of weeks. This
> is
> how it's been set up:
> FOR OPTIMIZATIONS
> Reorganize data and index pages
> Reorganize pages with the original amount of free space
> and for INTEGRITY CHECKS
> Check Database Integrity
> Include Indexes
> This is the message in the error log file for optimizations:
>
> (null)
> (null)
> [16] Database TestMS: Index Rebuild (leaving 100%% free space)...
>
> (null)
> (null)
> (null)
> Rebuilding indexes for table 'tblData'
> (null)
> (null)
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>
> (null)
> (null)
> End of maintenance plan 'DB Maintenance Plan1' on 4/23/2007 9:48:31 PM
>
> (null)
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>
> (null)
> Msg 22029, Sev 16: sqlmaint.exe failed. [SQLSTATE 42000]
>
> and this is the message in the error log file for Integrity:
>
> (null)
> (null)
> [16] Database TestMS: Check Data and Index Linkage...
>
> (null)
> (null)
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>
> (null)
> (null)
> End of maintenance plan 'DB Maintenance Plan1' on 4/23/2007 9:56:25 PM
>
> (null)
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>
> (null)
> Msg 22029, Sev 16: sqlmaint.exe failed. [SQLSTATE 42000]
> Any help will be greatly appreciated. Thanks.
>

Optimization and Integrity question

Hi,
I have set up a database maintenance plan for all the databases on a server
that takes care of the Optimization and Integrity every week on the weekends
.
However, it's been failing consistently for the past couple of weeks. This i
s
how it's been set up:
FOR OPTIMIZATIONS
Reorganize data and index pages
Reorganize pages with the original amount of free space
and for INTEGRITY CHECKS
Check Database Integrity
Include Indexes
This is the message in the error log file for optimizations:
(null)
(null)
[16] Database TestMS: Index Rebuild (leaving 100%% free space)...
(null)
(null)
(null)
Rebuilding indexes for table 'tblData'
(null)
(null)
** Execution Time: 0 hrs, 0 mins, 1 secs **
(null)
(null)
End of maintenance plan 'DB Maintenance Plan1' on 4/23/2007 9:48:31 PM
(null)
SQLMAINT.EXE Process Exit Code: 1 (Failed)
(null)
Msg 22029, Sev 16: sqlmaint.exe failed. [SQLSTATE 42000]
and this is the message in the error log file for Integrity:
(null)
(null)
[16] Database TestMS: Check Data and Index Linkage...
(null)
(null)
** Execution Time: 0 hrs, 0 mins, 1 secs **
(null)
(null)
End of maintenance plan 'DB Maintenance Plan1' on 4/23/2007 9:56:25 PM
(null)
SQLMAINT.EXE Process Exit Code: 1 (Failed)
(null)
Msg 22029, Sev 16: sqlmaint.exe failed. [SQLSTATE 42000]
Any help will be greatly appreciated. Thanks.These are just some ideas:
1)Check to see none of the dbs upon which you are attempting this
maintenance plan are either : corrupt or off line
2)Check the compatibility levels are to low
3)Hard disk full
Jack Vamvas
___________________________________
Need an IT job? <a href="http://links.10026.com/?link=http://www.itjobfeed.com">uk it jobs</a>
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:C9D6FB45-77F3-418F-8508-0439665AFFE4@.microsoft.com...
> Hi,
> I have set up a database maintenance plan for all the databases on a
> server
> that takes care of the Optimization and Integrity every week on the
> weekends.
> However, it's been failing consistently for the past couple of weeks. This
> is
> how it's been set up:
> FOR OPTIMIZATIONS
> Reorganize data and index pages
> Reorganize pages with the original amount of free space
> and for INTEGRITY CHECKS
> Check Database Integrity
> Include Indexes
> This is the message in the error log file for optimizations:
>
> (null)
> (null)
> [16] Database TestMS: Index Rebuild (leaving 100%% free space)...
>
> (null)
> (null)
> (null)
> Rebuilding indexes for table 'tblData'
> (null)
> (null)
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>
> (null)
> (null)
> End of maintenance plan 'DB Maintenance Plan1' on 4/23/2007 9:48:31 PM
>
> (null)
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>
> (null)
> Msg 22029, Sev 16: sqlmaint.exe failed. [SQLSTATE 42000]
>
> and this is the message in the error log file for Integrity:
>
> (null)
> (null)
> [16] Database TestMS: Check Data and Index Linkage...
>
> (null)
> (null)
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>
> (null)
> (null)
> End of maintenance plan 'DB Maintenance Plan1' on 4/23/2007 9:56:25 PM
>
> (null)
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>
> (null)
> Msg 22029, Sev 16: sqlmaint.exe failed. [SQLSTATE 42000]
> Any help will be greatly appreciated. Thanks.
>

Optimization and Integrity Error

Is there any way to run an optimization and integrity check against the
master and msdb databases? Below are the log files. Thanks!
- Gabe
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'SRVDB1' as 'RRG\rrg-sqlserver' (trusted)
Starting maintenance plan 'System Databases - Optimizations and Integrity'
on 6/2/2007 2:00:01 AM
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODBC SQL
Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in database
'MASTER'.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
[1] Database master: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL
Server Driver][SQL Server]Repair statement not processed. Database needs to
be in single user mode.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
processed. Database needs to be in single user mode.
** Execution Time: 0 hrs, 0 mins, 1 secs **
[2] Database model: Check Data and Index Linkage...
** Execution Time: 0 hrs, 0 mins, 1 secs **
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL
Server Driver][SQL Server]Database state cannot be changed while other users
are using the database 'msdb'
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
[3] Database msdb: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL
Server Driver][SQL Server]Repair statement not processed. Database needs to
be in single user mode.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
processed. Database needs to be in single user mode.
** Execution Time: 0 hrs, 0 mins, 1 secs **
Deleting old text reports... 0 file(s) deleted.
End of maintenance plan 'System Databases - Optimizations and Integrity' on
6/2/2007 2:00:01 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)Gabe,
Sure, but you need to turn off the "repair minor problems" option.
http://support.microsoft.com/kb/290622
RLF
"Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
news:uTngsk6pHHA.3892@.TK2MSFTNGP05.phx.gbl...
> Is there any way to run an optimization and integrity check against the
> master and msdb databases? Below are the log files. Thanks!
> - Gabe
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'SRVDB1' as 'RRG\rrg-sqlserver' (trusted)
> Starting maintenance plan 'System Databases - Optimizations and Integrity'
> on 6/2/2007 2:00:01 AM
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODBC
> SQL Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in
> database 'MASTER'.
> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
> [1] Database master: Check Data and Index Linkage...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC
> SQL Server Driver][SQL Server]Repair statement not processed. Database
> needs to be in single user mode.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
> processed. Database needs to be in single user mode.
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> [2] Database model: Check Data and Index Linkage...
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC
> SQL Server Driver][SQL Server]Database state cannot be changed while other
> users are using the database 'msdb'
> [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
> failed.
> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
> [3] Database msdb: Check Data and Index Linkage...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC
> SQL Server Driver][SQL Server]Repair statement not processed. Database
> needs to be in single user mode.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
> processed. Database needs to be in single user mode.
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> Deleting old text reports... 0 file(s) deleted.
> End of maintenance plan 'System Databases - Optimizations and Integrity'
> on 6/2/2007 2:00:01 AM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>|||Thanks!!
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:%23qevkq6pHHA.4872@.TK2MSFTNGP03.phx.gbl...
> Gabe,
> Sure, but you need to turn off the "repair minor problems" option.
> http://support.microsoft.com/kb/290622
> RLF
> "Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
> news:uTngsk6pHHA.3892@.TK2MSFTNGP05.phx.gbl...
>> Is there any way to run an optimization and integrity check against the
>> master and msdb databases? Below are the log files. Thanks!
>> - Gabe
>> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
>> 'SRVDB1' as 'RRG\rrg-sqlserver' (trusted)
>> Starting maintenance plan 'System Databases - Optimizations and
>> Integrity' on 6/2/2007 2:00:01 AM
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in
>> database 'MASTER'.
>> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command
>> failed.
>> [1] Database master: Check Data and Index Linkage...
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Repair statement not processed. Database
>> needs to be in single user mode.
>> The following errors were found:
>> [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
>> processed. Database needs to be in single user mode.
>> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>> [2] Database model: Check Data and Index Linkage...
>> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Database state cannot be changed while
>> other users are using the database 'msdb'
>> [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
>> failed.
>> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command
>> failed.
>> [3] Database msdb: Check Data and Index Linkage...
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Repair statement not processed. Database
>> needs to be in single user mode.
>> The following errors were found:
>> [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
>> processed. Database needs to be in single user mode.
>> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>> Deleting old text reports... 0 file(s) deleted.
>> End of maintenance plan 'System Databases - Optimizations and Integrity'
>> on 6/2/2007 2:00:01 AM
>> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>>
>

Optimization and integrity check errors

At an installation of SharePointPortal Server 2003 were created automatically
3 databases.
The jobs for optimizations and integrity check for one of these databases
produce always errors:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL
Server Driver] [SQL Server]DBCC failed because the following SET options have
incorrect settings: 'QUOTED_IDENTIFIER'
I changed repeatedly QUOTED_IDENTIFIER, but the errors appeared again.
I used directly the DBCC statements for all tables of the database and I
became no errors.
What can I do?
Thank you in advance for your help
Andreas Marner
Sounds like you have a computed column or an Indexed view in the database.
There is a bug with the MP that does not allow it to handle these very well.
I recommend you create your own scheduled job to issue the backups and
reindexing for at least those db's.
Andrew J. Kelly SQL MVP
"Marner" <marner@.discussions.microsoft.com> wrote in message
news:6F859E50-AE75-4587-95F8-F4697BF4FD6F@.microsoft.com...
> At an installation of SharePointPortal Server 2003 were created
automatically
> 3 databases.
> The jobs for optimizations and integrity check for one of these databases
> produce always errors:
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC
SQL
> Server Driver] [SQL Server]DBCC failed because the following SET options
have
> incorrect settings: 'QUOTED_IDENTIFIER'
> I changed repeatedly QUOTED_IDENTIFIER, but the errors appeared again.
> I used directly the DBCC statements for all tables of the database and I
> became no errors.
> What can I do?
> Thank you in advance for your help
> Andreas Marner

Optimization and integrity check errors

At an installation of SharePointPortal Server 2003 were created automatically
3 databases.
The jobs for optimizations and integrity check for one of these databases
produce always errors:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL
Server Driver] [SQL Server]DBCC failed because the following SET options have
incorrect settings: 'QUOTED_IDENTIFIER'
I changed repeatedly QUOTED_IDENTIFIER, but the errors appeared again.
I used directly the DBCC statements for all tables of the database and I
became no errors.
What can I do?
Thank you in advance for your help
Andreas MarnerSounds like you have a computed column or an Indexed view in the database.
There is a bug with the MP that does not allow it to handle these very well.
I recommend you create your own scheduled job to issue the backups and
reindexing for at least those db's.
--
Andrew J. Kelly SQL MVP
"Marner" <marner@.discussions.microsoft.com> wrote in message
news:6F859E50-AE75-4587-95F8-F4697BF4FD6F@.microsoft.com...
> At an installation of SharePointPortal Server 2003 were created
automatically
> 3 databases.
> The jobs for optimizations and integrity check for one of these databases
> produce always errors:
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC
SQL
> Server Driver] [SQL Server]DBCC failed because the following SET options
have
> incorrect settings: 'QUOTED_IDENTIFIER'
> I changed repeatedly QUOTED_IDENTIFIER, but the errors appeared again.
> I used directly the DBCC statements for all tables of the database and I
> became no errors.
> What can I do?
> Thank you in advance for your help
> Andreas Marner

Monday, March 12, 2012

Optimal Physical Layer config SQL Server on IBM xSeries 345 server

Hi all, I am building a new IBM xSeries 345 server and we plan consolidate
most of the SQL Servers databases on it (~40). I am trying to figure out the
best configuration for the disk subsystem for both reasonable performance and
disk cost savings and reduced down time. The server may have upto 6 X 73.4
GB SCSI disks. Can anyone suggest any ideas?
DISK 1 and
DISK 2 as RAID 1 â' System & Tlog
DISK 3 and
DISK 4 as RAID 1 - DATA
DISK 5 and
DISK 6 as RAID 1 â' DATA
---
DISK 1 and
DISK 2 as RAID 1 System & Tempdb
DISK 3 and
DISK 4 as RAID 1 â' Tlogs
DISK 5 and
DISK 6 as AID 1 â' DATA
---
Thanks."Ruski" <Ruski@.discussions.microsoft.com> wrote in message
news:493C572F-C196-4301-B2D7-4AD665B2A48C@.microsoft.com...
> Hi all, I am building a new IBM xSeries 345 server and we plan consolidate
> most of the SQL Servers databases on it (~40). I am trying to figure out
> the
> best configuration for the disk subsystem for both reasonable performance
> and
> disk cost savings and reduced down time. The server may have upto 6 X
> 73.4
> GB SCSI disks. Can anyone suggest any ideas?
> DISK 1 and
> DISK 2 as RAID 1 - System & Tlog
> DISK 3 and
> DISK 4 as RAID 1 - DATA
> DISK 5 and
> DISK 6 as RAID 1 - DATA
> ---
> DISK 1 and
> DISK 2 as RAID 1 System & Tempdb
> DISK 3 and
> DISK 4 as RAID 1 - Tlogs
> DISK 5 and
> DISK 6 as AID 1 - DATA
> ---
>
Physical optimization like this mostly involves aranging the spindles to
maximize the number of spindes used and minimize the contention for
spindles. However with 40 databases and 40 different workloads on the
server you will probably not be able to optimize the physical layout much.
BTW, I wouldn't consolodate onto the x345 if I could help it because it's a
32-bit machine. The newer x346 can run 64bit Windows and SQL Server 2005.
This will let you use much more memory, and minimize how much your workload
utilizes the disks.
David|||I second that emotion.
I'd also like to add that many writes wind up being cached and first written
into the transaction log... the point being that you could probably do all
your data on one RAID-5 array and have more actual space as a result or keep
one remaining disk as a spare.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:O4b2YHzJGHA.1676@.TK2MSFTNGP09.phx.gbl...
>
> Physical optimization like this mostly involves aranging the spindles to
> maximize the number of spindes used and minimize the contention for
> spindles. However with 40 databases and 40 different workloads on the
> server you will probably not be able to optimize the physical layout much.
>

optimal location for database files on SAN?

Hi, we have 2 sql servers that will have all their system databases/user
databases/log files located to a san. what is the best configuration?
note: sql1 performs transactional replication to sql2 (which is used for
reporting):
we have 2 x RAID 1 and 1 x RAID 5. I was thinking:
RAID 1: sql2 user + system data files
RAID 1: Logs (from both sql1 and sql2)
RAID 5: sql1 user + system data files
if I could get access to another RAID 1 how would this sound:
RAID 1: sql2 user + system data files
RAID 1: Logs (from both sql1 and sql2)
RAID 1: tempdb (from both sql1 and sql2)
RAID 5: sql1 user + system data files
Would both servers share the same tempdb? or would there be two instances?
since sql1 replicates to sql2, having all the logs on the same RAID 1 would
increase replication speed?
Any help most appreciated!
thanks, john
i will have access to initially 9 hdd's to build my config, but i might
possibly get a hold of more. any help most appreciated! ciao john
"john r" <johnr@.trailer.com> wrote in message
news:uSqTyAS6FHA.2364@.TK2MSFTNGP12.phx.gbl...
> Hi, we have 2 sql servers that will have all their system databases/user
> databases/log files located to a san. what is the best configuration?
> note: sql1 performs transactional replication to sql2 (which is used for
> reporting):
> we have 2 x RAID 1 and 1 x RAID 5. I was thinking:
> RAID 1: sql2 user + system data files
> RAID 1: Logs (from both sql1 and sql2)
> RAID 5: sql1 user + system data files
> if I could get access to another RAID 1 how would this sound:
> RAID 1: sql2 user + system data files
> RAID 1: Logs (from both sql1 and sql2)
> RAID 1: tempdb (from both sql1 and sql2)
> RAID 5: sql1 user + system data files
> Would both servers share the same tempdb? or would there be two instances?
> since sql1 replicates to sql2, having all the logs on the same RAID 1
> would increase replication speed?
> Any help most appreciated!
> thanks, john
>
|||I am not sure if I hit enter or lost the page. I tried an earlier response
Anyway, I suggest Mirroring your OS drive and a Binaries Drive witht the SAN
used for all the data files.
I like mirroring, but that is a bias others will contest.
Without knowing your SAN, I can't say much more. Some SANs don't give you
enough control to worry about RAID levels.
The real question is how many LUNs to the SAN?
Joseph R.P. Maloney, CSP,CCP,CDP
"john r" wrote:

> i will have access to initially 9 hdd's to build my config, but i might
> possibly get a hold of more. any help most appreciated! ciao john
>
> "john r" <johnr@.trailer.com> wrote in message
> news:uSqTyAS6FHA.2364@.TK2MSFTNGP12.phx.gbl...
>
>
|||The primary question for me is how many LUNs do you have.
I like Raid 0+1 (mirroring) rather than Raid-5 and all. Personal bias.
I would look to configure as follows:
Logical C: Mirror, OS files
Logical D: Mirror, Application (including SS) binaries
Logical E; SAN-data and log files.
This presumes 1 LUN, probably fiber, to the SAN.
As I said, I like mirroring. Without knowing which SAN you are using,
though, it is difficult to give advice (foot in mouth?) there. Some SANS do
not give you
Joseph R.P. Maloney, CSP,CCP,CDP
"john r" wrote:

> i will have access to initially 9 hdd's to build my config, but i might
> possibly get a hold of more. any help most appreciated! ciao john
>
> "john r" <johnr@.trailer.com> wrote in message
> news:uSqTyAS6FHA.2364@.TK2MSFTNGP12.phx.gbl...
>
>
|||I believe it is going to depend on the size of your databases and what they
are used for. Are they creating a lot of temp tables in the temp database?
if so, then temp needs two RAID1 volumes, 1 for data, 1 for logs.
Also, whatever config you end up with, separate the log files from the data
files.
Another thing to consider if you have it available is to use RAID1 or RAID10
on your databases. RAID5 is too expensive on the write operation for your
heavily used databases.
I hope this helps.
"john r" <johnr@.trailer.com> wrote in message
news:uSqTyAS6FHA.2364@.TK2MSFTNGP12.phx.gbl...
> Hi, we have 2 sql servers that will have all their system databases/user
> databases/log files located to a san. what is the best configuration?
> note: sql1 performs transactional replication to sql2 (which is used for
> reporting):
> we have 2 x RAID 1 and 1 x RAID 5. I was thinking:
> RAID 1: sql2 user + system data files
> RAID 1: Logs (from both sql1 and sql2)
> RAID 5: sql1 user + system data files
> if I could get access to another RAID 1 how would this sound:
> RAID 1: sql2 user + system data files
> RAID 1: Logs (from both sql1 and sql2)
> RAID 1: tempdb (from both sql1 and sql2)
> RAID 5: sql1 user + system data files
> Would both servers share the same tempdb? or would there be two instances?
> since sql1 replicates to sql2, having all the logs on the same RAID 1
> would increase replication speed?
> Any help most appreciated!
> thanks, john
>

optimal location for database files on SAN?

Hi, we have 2 sql servers that will have all their system databases/user
databases/log files located to a san. what is the best configuration?
note: sql1 performs transactional replication to sql2 (which is used for
reporting):
we have 2 x RAID 1 and 1 x RAID 5. I was thinking:
RAID 1: sql2 user + system data files
RAID 1: Logs (from both sql1 and sql2)
RAID 5: sql1 user + system data files
if I could get access to another RAID 1 how would this sound:
RAID 1: sql2 user + system data files
RAID 1: Logs (from both sql1 and sql2)
RAID 1: tempdb (from both sql1 and sql2)
RAID 5: sql1 user + system data files
Would both servers share the same tempdb? or would there be two instances?
since sql1 replicates to sql2, having all the logs on the same RAID 1 would
increase replication speed?
Any help most appreciated!
thanks, johni will have access to initially 9 hdd's to build my config, but i might
possibly get a hold of more. any help most appreciated! ciao john
"john r" <johnr@.trailer.com> wrote in message
news:uSqTyAS6FHA.2364@.TK2MSFTNGP12.phx.gbl...
> Hi, we have 2 sql servers that will have all their system databases/user
> databases/log files located to a san. what is the best configuration?
> note: sql1 performs transactional replication to sql2 (which is used for
> reporting):
> we have 2 x RAID 1 and 1 x RAID 5. I was thinking:
> RAID 1: sql2 user + system data files
> RAID 1: Logs (from both sql1 and sql2)
> RAID 5: sql1 user + system data files
> if I could get access to another RAID 1 how would this sound:
> RAID 1: sql2 user + system data files
> RAID 1: Logs (from both sql1 and sql2)
> RAID 1: tempdb (from both sql1 and sql2)
> RAID 5: sql1 user + system data files
> Would both servers share the same tempdb? or would there be two instances?
> since sql1 replicates to sql2, having all the logs on the same RAID 1
> would increase replication speed?
> Any help most appreciated!
> thanks, john
>|||I am not sure if I hit enter or lost the page. I tried an earlier response
Anyway, I suggest Mirroring your OS drive and a Binaries Drive witht the SAN
used for all the data files.
I like mirroring, but that is a bias others will contest.
Without knowing your SAN, I can't say much more. Some SANs don't give you
enough control to worry about RAID levels.
The real question is how many LUNs to the SAN?
--
Joseph R.P. Maloney, CSP,CCP,CDP
"john r" wrote:
> i will have access to initially 9 hdd's to build my config, but i might
> possibly get a hold of more. any help most appreciated! ciao john
>
> "john r" <johnr@.trailer.com> wrote in message
> news:uSqTyAS6FHA.2364@.TK2MSFTNGP12.phx.gbl...
> > Hi, we have 2 sql servers that will have all their system databases/user
> > databases/log files located to a san. what is the best configuration?
> >
> > note: sql1 performs transactional replication to sql2 (which is used for
> > reporting):
> >
> > we have 2 x RAID 1 and 1 x RAID 5. I was thinking:
> >
> > RAID 1: sql2 user + system data files
> > RAID 1: Logs (from both sql1 and sql2)
> > RAID 5: sql1 user + system data files
> >
> > if I could get access to another RAID 1 how would this sound:
> >
> > RAID 1: sql2 user + system data files
> > RAID 1: Logs (from both sql1 and sql2)
> > RAID 1: tempdb (from both sql1 and sql2)
> > RAID 5: sql1 user + system data files
> >
> > Would both servers share the same tempdb? or would there be two instances?
> >
> > since sql1 replicates to sql2, having all the logs on the same RAID 1
> > would increase replication speed?
> >
> > Any help most appreciated!
> > thanks, john
> >
>
>|||The primary question for me is how many LUNs do you have.
I like Raid 0+1 (mirroring) rather than Raid-5 and all. Personal bias.
I would look to configure as follows:
Logical C: Mirror, OS files
Logical D: Mirror, Application (including SS) binaries
Logical E; SAN-data and log files.
This presumes 1 LUN, probably fiber, to the SAN.
As I said, I like mirroring. Without knowing which SAN you are using,
though, it is difficult to give advice (foot in mouth?) there. Some SANS do
not give you
--
Joseph R.P. Maloney, CSP,CCP,CDP
"john r" wrote:
> i will have access to initially 9 hdd's to build my config, but i might
> possibly get a hold of more. any help most appreciated! ciao john
>
> "john r" <johnr@.trailer.com> wrote in message
> news:uSqTyAS6FHA.2364@.TK2MSFTNGP12.phx.gbl...
> > Hi, we have 2 sql servers that will have all their system databases/user
> > databases/log files located to a san. what is the best configuration?
> >
> > note: sql1 performs transactional replication to sql2 (which is used for
> > reporting):
> >
> > we have 2 x RAID 1 and 1 x RAID 5. I was thinking:
> >
> > RAID 1: sql2 user + system data files
> > RAID 1: Logs (from both sql1 and sql2)
> > RAID 5: sql1 user + system data files
> >
> > if I could get access to another RAID 1 how would this sound:
> >
> > RAID 1: sql2 user + system data files
> > RAID 1: Logs (from both sql1 and sql2)
> > RAID 1: tempdb (from both sql1 and sql2)
> > RAID 5: sql1 user + system data files
> >
> > Would both servers share the same tempdb? or would there be two instances?
> >
> > since sql1 replicates to sql2, having all the logs on the same RAID 1
> > would increase replication speed?
> >
> > Any help most appreciated!
> > thanks, john
> >
>
>|||I believe it is going to depend on the size of your databases and what they
are used for. Are they creating a lot of temp tables in the temp database?
if so, then temp needs two RAID1 volumes, 1 for data, 1 for logs.
Also, whatever config you end up with, separate the log files from the data
files.
Another thing to consider if you have it available is to use RAID1 or RAID10
on your databases. RAID5 is too expensive on the write operation for your
heavily used databases.
I hope this helps.
"john r" <johnr@.trailer.com> wrote in message
news:uSqTyAS6FHA.2364@.TK2MSFTNGP12.phx.gbl...
> Hi, we have 2 sql servers that will have all their system databases/user
> databases/log files located to a san. what is the best configuration?
> note: sql1 performs transactional replication to sql2 (which is used for
> reporting):
> we have 2 x RAID 1 and 1 x RAID 5. I was thinking:
> RAID 1: sql2 user + system data files
> RAID 1: Logs (from both sql1 and sql2)
> RAID 5: sql1 user + system data files
> if I could get access to another RAID 1 how would this sound:
> RAID 1: sql2 user + system data files
> RAID 1: Logs (from both sql1 and sql2)
> RAID 1: tempdb (from both sql1 and sql2)
> RAID 5: sql1 user + system data files
> Would both servers share the same tempdb? or would there be two instances?
> since sql1 replicates to sql2, having all the logs on the same RAID 1
> would increase replication speed?
> Any help most appreciated!
> thanks, john
>

optimal location for database files on SAN?

Hi, we have 2 sql servers that will have all their system databases/user
databases/log files located to a san. what is the best configuration?
note: sql1 performs transactional replication to sql2 (which is used for
reporting):
we have 2 x RAID 1 and 1 x RAID 5. I was thinking:
RAID 1: sql2 user + system data files
RAID 1: Logs (from both sql1 and sql2)
RAID 5: sql1 user + system data files
if I could get access to another RAID 1 how would this sound:
RAID 1: sql2 user + system data files
RAID 1: Logs (from both sql1 and sql2)
RAID 1: tempdb (from both sql1 and sql2)
RAID 5: sql1 user + system data files
Would both servers share the same tempdb? or would there be two instances?
since sql1 replicates to sql2, having all the logs on the same RAID 1 would
increase replication speed?
Any help most appreciated!
thanks, johni will have access to initially 9 hdd's to build my config, but i might
possibly get a hold of more. any help most appreciated! ciao john
"john r" <johnr@.trailer.com> wrote in message
news:uSqTyAS6FHA.2364@.TK2MSFTNGP12.phx.gbl...
> Hi, we have 2 sql servers that will have all their system databases/user
> databases/log files located to a san. what is the best configuration?
> note: sql1 performs transactional replication to sql2 (which is used for
> reporting):
> we have 2 x RAID 1 and 1 x RAID 5. I was thinking:
> RAID 1: sql2 user + system data files
> RAID 1: Logs (from both sql1 and sql2)
> RAID 5: sql1 user + system data files
> if I could get access to another RAID 1 how would this sound:
> RAID 1: sql2 user + system data files
> RAID 1: Logs (from both sql1 and sql2)
> RAID 1: tempdb (from both sql1 and sql2)
> RAID 5: sql1 user + system data files
> Would both servers share the same tempdb? or would there be two instances?
> since sql1 replicates to sql2, having all the logs on the same RAID 1
> would increase replication speed?
> Any help most appreciated!
> thanks, john
>|||I am not sure if I hit enter or lost the page. I tried an earlier response
Anyway, I suggest Mirroring your OS drive and a Binaries Drive witht the SAN
used for all the data files.
I like mirroring, but that is a bias others will contest.
Without knowing your SAN, I can't say much more. Some SANs don't give you
enough control to worry about RAID levels.
The real question is how many LUNs to the SAN?
--
Joseph R.P. Maloney, CSP,CCP,CDP
"john r" wrote:

> i will have access to initially 9 hdd's to build my config, but i might
> possibly get a hold of more. any help most appreciated! ciao john
>
> "john r" <johnr@.trailer.com> wrote in message
> news:uSqTyAS6FHA.2364@.TK2MSFTNGP12.phx.gbl...
>
>|||The primary question for me is how many LUNs do you have.
I like Raid 0+1 (mirroring) rather than Raid-5 and all. Personal bias.
I would look to configure as follows:
Logical C: Mirror, OS files
Logical D: Mirror, Application (including SS) binaries
Logical E; SAN-data and log files.
This presumes 1 LUN, probably fiber, to the SAN.
As I said, I like mirroring. Without knowing which SAN you are using,
though, it is difficult to give advice (foot in mouth?) there. Some SANS do
not give you
--
Joseph R.P. Maloney, CSP,CCP,CDP
"john r" wrote:

> i will have access to initially 9 hdd's to build my config, but i might
> possibly get a hold of more. any help most appreciated! ciao john
>
> "john r" <johnr@.trailer.com> wrote in message
> news:uSqTyAS6FHA.2364@.TK2MSFTNGP12.phx.gbl...
>
>|||I believe it is going to depend on the size of your databases and what they
are used for. Are they creating a lot of temp tables in the temp database?
if so, then temp needs two RAID1 volumes, 1 for data, 1 for logs.
Also, whatever config you end up with, separate the log files from the data
files.
Another thing to consider if you have it available is to use RAID1 or RAID10
on your databases. RAID5 is too expensive on the write operation for your
heavily used databases.
I hope this helps.
"john r" <johnr@.trailer.com> wrote in message
news:uSqTyAS6FHA.2364@.TK2MSFTNGP12.phx.gbl...
> Hi, we have 2 sql servers that will have all their system databases/user
> databases/log files located to a san. what is the best configuration?
> note: sql1 performs transactional replication to sql2 (which is used for
> reporting):
> we have 2 x RAID 1 and 1 x RAID 5. I was thinking:
> RAID 1: sql2 user + system data files
> RAID 1: Logs (from both sql1 and sql2)
> RAID 5: sql1 user + system data files
> if I could get access to another RAID 1 how would this sound:
> RAID 1: sql2 user + system data files
> RAID 1: Logs (from both sql1 and sql2)
> RAID 1: tempdb (from both sql1 and sql2)
> RAID 5: sql1 user + system data files
> Would both servers share the same tempdb? or would there be two instances?
> since sql1 replicates to sql2, having all the logs on the same RAID 1
> would increase replication speed?
> Any help most appreciated!
> thanks, john
>

Friday, March 9, 2012

Opinions needed

Good luck!
Luis
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:unxbQIJ$DHA.2664@.TK2MSFTNGP09.phx.gbl...
> How many users? How much data? How's your budget? How's your experience
> with SQL Server and/or Access?
> Either can do what you've told us, but you've not told us enough. :-)
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> "Shawn Johnson" <sejohnson77@.yahoo.com> wrote in message
> news:%23mxZQkI$DHA.2040@.TK2MSFTNGP12.phx.gbl...
> fields).
Our
delimited
output
I
>|||I will be the only user to output the reports to send to my carriers
As far as how much data is concerned, it depends on the region we are
delivering to, sometimes 20000 all the way up to 250000
Budget is whatever it takes (Software or training) to get the job done
properly.
My experiance with SQL and Access is just as an admin. (Adding and removing
fields for a CRM application and other small admin tasks, nothing to
complex) but I guess I would consider myself a fairly quick study. I do
have some time on my side since we are getting our existing route lists from
another "routing" company. We are merely positioning ourselves to takeover
in several months.
Let me know if you have any other Qs
Shawn J
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:unxbQIJ$DHA.2664@.TK2MSFTNGP09.phx.gbl...
> How many users? How much data? How's your budget? How's your experience
> with SQL Server and/or Access?
> Either can do what you've told us, but you've not told us enough. :-)
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> "Shawn Johnson" <sejohnson77@.yahoo.com> wrote in message
> news:%23mxZQkI$DHA.2040@.TK2MSFTNGP12.phx.gbl...
> fields).
Our
delimited
output
I
>|||Do you think Access can handle up to 350000 different customer records?
"Nico De Greef" <ndg@.denco.be> wrote in message
news:OsRinnI$DHA.3232@.TK2MSFTNGP10.phx.gbl...
> If it's a multi-user application you should use SQL Server.
> If it's just a single user import and print application, Access probably
> will do.
> --
> Nico De Greef
> Belgium
> Freelance Software Architect
> MCP, MCSD, .NET certified
> "Shawn Johnson" <sejohnson77@.yahoo.com> wrote in message
> news:%23mxZQkI$DHA.2040@.TK2MSFTNGP12.phx.gbl...
> fields).
Our
delimited
output
I
>|||I don't think Access is optimized for handling that amount of records.
You are the only user using the tool, it could be a little overkill to buy a
server and a SQL Server license just for your import and print task.
You could also use SQL Desktop Edition, it is also limited on the multi user
side but is closer to SQL Server than Access. You won't need a separate
server for this one.
If you should ever need to upgrade to SQL Server it is easier to start from
SQL Server desktop then from Access.
I never use Access, but only because I have the hardware available to run
SQL Server.
Based on your info I would start with SQL Desktop Edition and a reporting
tool of your choice.
Can Access handle the reporting part of the job ? One answer: test it.
Nico De Greef
Belgium
Freelance Software Architect
MCP, MCSD, .NET certified
"Shawn Johnson" <sejohnson77@.yahoo.com> wrote in message
news:OKpluIK$DHA.712@.tk2msftngp13.phx.gbl...
> Do you think Access can handle up to 350000 different customer records?
> "Nico De Greef" <ndg@.denco.be> wrote in message
> news:OsRinnI$DHA.3232@.TK2MSFTNGP10.phx.gbl...
> Our
> delimited
> output
which
> I
are
why
>|||This is just my guess that you will be doing more
development in future, most Access applications end up
being migrated to sql server anyway. So I would recommend
to use sql server from the start.

>--Original Message--
>I will be the only user to output the reports to send to
my carriers
>As far as how much data is concerned, it depends on the
region we are
>delivering to, sometimes 20000 all the way up to 250000
>Budget is whatever it takes (Software or training) to get
the job done
>properly.
>My experiance with SQL and Access is just as an admin.
(Adding and removing
>fields for a CRM application and other small admin tasks,
nothing to
>complex) but I guess I would consider myself a fairly
quick study. I do
>have some time on my side since we are getting our
existing route lists from
>another "routing" company. We are merely positioning
ourselves to takeover
>in several months.
>Let me know if you have any other Qs
>Shawn J
>
>
>"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote
in message
>news:unxbQIJ$DHA.2664@.TK2MSFTNGP09.phx.gbl...
How's your experience
us enough. :-)
have a basic
database (Tables and
create route lists for
clients customers.
>Our
tab or comma
>delimited
into SQL and then
>output
routes.
geographical area which
>I
(Since postal codes are
coverage)
with Crystal, why
features in Access?
>
>.
>

Opinions needed

I am somewhat new to database technologies, I only have a basic
understanding of relational databases.
I need to figure out the best way to set up a database (Tables and fields).
Crystal reports will be used for reporting.
I am in the distribution business and I need to create route lists for
people who will go out and deliver catalogs to our clients customers. Our
client will send me their database of customers via tab or comma delimited
file. What I then need to do is import this file into SQL and then output
some nice looking reports for our carriers delivery routes.
The routes will be based on streets in a logical geographical area which I
hope I will be able to organize by postal code. (Since postal codes are
already organized for optimal delivery time and coverage)
I should add that I'm not even sure I need to use SQL with Crystal, why
wouldn't I use Access and just use the reporting features in Access?
Any help will be appreciated.
Shawn JohnsonIf it's a multi-user application you should use SQL Server.
If it's just a single user import and print application, Access probably
will do.
--
Nico De Greef
Belgium
Freelance Software Architect
MCP, MCSD, .NET certified
"Shawn Johnson" <sejohnson77@.yahoo.com> wrote in message
news:%23mxZQkI$DHA.2040@.TK2MSFTNGP12.phx.gbl...
> I am somewhat new to database technologies, I only have a basic
> understanding of relational databases.
> I need to figure out the best way to set up a database (Tables and
fields).
> Crystal reports will be used for reporting.
> I am in the distribution business and I need to create route lists for
> people who will go out and deliver catalogs to our clients customers. Our
> client will send me their database of customers via tab or comma delimited
> file. What I then need to do is import this file into SQL and then output
> some nice looking reports for our carriers delivery routes.
> The routes will be based on streets in a logical geographical area which I
> hope I will be able to organize by postal code. (Since postal codes are
> already organized for optimal delivery time and coverage)
> I should add that I'm not even sure I need to use SQL with Crystal, why
> wouldn't I use Access and just use the reporting features in Access?
> Any help will be appreciated.
> Shawn Johnson
>|||How many users? How much data? How's your budget? How's your experience
with SQL Server and/or Access?
Either can do what you've told us, but you've not told us enough. :-)
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Shawn Johnson" <sejohnson77@.yahoo.com> wrote in message
news:%23mxZQkI$DHA.2040@.TK2MSFTNGP12.phx.gbl...
> I am somewhat new to database technologies, I only have a basic
> understanding of relational databases.
> I need to figure out the best way to set up a database (Tables and
fields).
> Crystal reports will be used for reporting.
> I am in the distribution business and I need to create route lists for
> people who will go out and deliver catalogs to our clients customers. Our
> client will send me their database of customers via tab or comma delimited
> file. What I then need to do is import this file into SQL and then output
> some nice looking reports for our carriers delivery routes.
> The routes will be based on streets in a logical geographical area which I
> hope I will be able to organize by postal code. (Since postal codes are
> already organized for optimal delivery time and coverage)
> I should add that I'm not even sure I need to use SQL with Crystal, why
> wouldn't I use Access and just use the reporting features in Access?
> Any help will be appreciated.
> Shawn Johnson
>|||I will interject a little bit of my prferences and expertise on
this...Crystal is a much more robust of a reprting tool than Access. If you
are just developing reports so that users can print them out etc...you can
import everything into Access, and use access as the reporting tool and
create a few nifty little buttons and forms to make it all user friendly
etc...However, one great point that was mentioned was if you are going to
have many people connect to this database and do thier own importing and
reporting and manipulation and you plan on developing an application to
interface with this...Then SQL is the way to go, using crystal reports to
interface with the data. Well crystal won't change the data, but it will
dress up the reports real perty like! :)
Good luck!
Luis
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:unxbQIJ$DHA.2664@.TK2MSFTNGP09.phx.gbl...
> How many users? How much data? How's your budget? How's your experience
> with SQL Server and/or Access?
> Either can do what you've told us, but you've not told us enough. :-)
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> "Shawn Johnson" <sejohnson77@.yahoo.com> wrote in message
> news:%23mxZQkI$DHA.2040@.TK2MSFTNGP12.phx.gbl...
> > I am somewhat new to database technologies, I only have a basic
> > understanding of relational databases.
> >
> > I need to figure out the best way to set up a database (Tables and
> fields).
> > Crystal reports will be used for reporting.
> >
> > I am in the distribution business and I need to create route lists for
> > people who will go out and deliver catalogs to our clients customers.
Our
> > client will send me their database of customers via tab or comma
delimited
> > file. What I then need to do is import this file into SQL and then
output
> > some nice looking reports for our carriers delivery routes.
> >
> > The routes will be based on streets in a logical geographical area which
I
> > hope I will be able to organize by postal code. (Since postal codes are
> > already organized for optimal delivery time and coverage)
> >
> > I should add that I'm not even sure I need to use SQL with Crystal, why
> > wouldn't I use Access and just use the reporting features in Access?
> >
> > Any help will be appreciated.
> >
> > Shawn Johnson
> >
> >
>|||I will be the only user to output the reports to send to my carriers
As far as how much data is concerned, it depends on the region we are
delivering to, sometimes 20000 all the way up to 250000
Budget is whatever it takes (Software or training) to get the job done
properly.
My experiance with SQL and Access is just as an admin. (Adding and removing
fields for a CRM application and other small admin tasks, nothing to
complex) but I guess I would consider myself a fairly quick study. I do
have some time on my side since we are getting our existing route lists from
another "routing" company. We are merely positioning ourselves to takeover
in several months.
Let me know if you have any other Qs
Shawn J
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:unxbQIJ$DHA.2664@.TK2MSFTNGP09.phx.gbl...
> How many users? How much data? How's your budget? How's your experience
> with SQL Server and/or Access?
> Either can do what you've told us, but you've not told us enough. :-)
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> "Shawn Johnson" <sejohnson77@.yahoo.com> wrote in message
> news:%23mxZQkI$DHA.2040@.TK2MSFTNGP12.phx.gbl...
> > I am somewhat new to database technologies, I only have a basic
> > understanding of relational databases.
> >
> > I need to figure out the best way to set up a database (Tables and
> fields).
> > Crystal reports will be used for reporting.
> >
> > I am in the distribution business and I need to create route lists for
> > people who will go out and deliver catalogs to our clients customers.
Our
> > client will send me their database of customers via tab or comma
delimited
> > file. What I then need to do is import this file into SQL and then
output
> > some nice looking reports for our carriers delivery routes.
> >
> > The routes will be based on streets in a logical geographical area which
I
> > hope I will be able to organize by postal code. (Since postal codes are
> > already organized for optimal delivery time and coverage)
> >
> > I should add that I'm not even sure I need to use SQL with Crystal, why
> > wouldn't I use Access and just use the reporting features in Access?
> >
> > Any help will be appreciated.
> >
> > Shawn Johnson
> >
> >
>|||Do you think Access can handle up to 350000 different customer records?
"Nico De Greef" <ndg@.denco.be> wrote in message
news:OsRinnI$DHA.3232@.TK2MSFTNGP10.phx.gbl...
> If it's a multi-user application you should use SQL Server.
> If it's just a single user import and print application, Access probably
> will do.
> --
> Nico De Greef
> Belgium
> Freelance Software Architect
> MCP, MCSD, .NET certified
> "Shawn Johnson" <sejohnson77@.yahoo.com> wrote in message
> news:%23mxZQkI$DHA.2040@.TK2MSFTNGP12.phx.gbl...
> > I am somewhat new to database technologies, I only have a basic
> > understanding of relational databases.
> >
> > I need to figure out the best way to set up a database (Tables and
> fields).
> > Crystal reports will be used for reporting.
> >
> > I am in the distribution business and I need to create route lists for
> > people who will go out and deliver catalogs to our clients customers.
Our
> > client will send me their database of customers via tab or comma
delimited
> > file. What I then need to do is import this file into SQL and then
output
> > some nice looking reports for our carriers delivery routes.
> >
> > The routes will be based on streets in a logical geographical area which
I
> > hope I will be able to organize by postal code. (Since postal codes are
> > already organized for optimal delivery time and coverage)
> >
> > I should add that I'm not even sure I need to use SQL with Crystal, why
> > wouldn't I use Access and just use the reporting features in Access?
> >
> > Any help will be appreciated.
> >
> > Shawn Johnson
> >
> >
>|||I don't think Access is optimized for handling that amount of records.
You are the only user using the tool, it could be a little overkill to buy a
server and a SQL Server license just for your import and print task.
You could also use SQL Desktop Edition, it is also limited on the multi user
side but is closer to SQL Server than Access. You won't need a separate
server for this one.
If you should ever need to upgrade to SQL Server it is easier to start from
SQL Server desktop then from Access.
I never use Access, but only because I have the hardware available to run
SQL Server.
Based on your info I would start with SQL Desktop Edition and a reporting
tool of your choice.
Can Access handle the reporting part of the job ? One answer: test it.
--
Nico De Greef
Belgium
Freelance Software Architect
MCP, MCSD, .NET certified
"Shawn Johnson" <sejohnson77@.yahoo.com> wrote in message
news:OKpluIK$DHA.712@.tk2msftngp13.phx.gbl...
> Do you think Access can handle up to 350000 different customer records?
> "Nico De Greef" <ndg@.denco.be> wrote in message
> news:OsRinnI$DHA.3232@.TK2MSFTNGP10.phx.gbl...
> > If it's a multi-user application you should use SQL Server.
> > If it's just a single user import and print application, Access probably
> > will do.
> >
> > --
> > Nico De Greef
> > Belgium
> > Freelance Software Architect
> > MCP, MCSD, .NET certified
> >
> > "Shawn Johnson" <sejohnson77@.yahoo.com> wrote in message
> > news:%23mxZQkI$DHA.2040@.TK2MSFTNGP12.phx.gbl...
> > > I am somewhat new to database technologies, I only have a basic
> > > understanding of relational databases.
> > >
> > > I need to figure out the best way to set up a database (Tables and
> > fields).
> > > Crystal reports will be used for reporting.
> > >
> > > I am in the distribution business and I need to create route lists for
> > > people who will go out and deliver catalogs to our clients customers.
> Our
> > > client will send me their database of customers via tab or comma
> delimited
> > > file. What I then need to do is import this file into SQL and then
> output
> > > some nice looking reports for our carriers delivery routes.
> > >
> > > The routes will be based on streets in a logical geographical area
which
> I
> > > hope I will be able to organize by postal code. (Since postal codes
are
> > > already organized for optimal delivery time and coverage)
> > >
> > > I should add that I'm not even sure I need to use SQL with Crystal,
why
> > > wouldn't I use Access and just use the reporting features in Access?
> > >
> > > Any help will be appreciated.
> > >
> > > Shawn Johnson
> > >
> > >
> >
> >
>|||This is just my guess that you will be doing more
development in future, most Access applications end up
being migrated to sql server anyway. So I would recommend
to use sql server from the start.
>--Original Message--
>I will be the only user to output the reports to send to
my carriers
>As far as how much data is concerned, it depends on the
region we are
>delivering to, sometimes 20000 all the way up to 250000
>Budget is whatever it takes (Software or training) to get
the job done
>properly.
>My experiance with SQL and Access is just as an admin.
(Adding and removing
>fields for a CRM application and other small admin tasks,
nothing to
>complex) but I guess I would consider myself a fairly
quick study. I do
>have some time on my side since we are getting our
existing route lists from
>another "routing" company. We are merely positioning
ourselves to takeover
>in several months.
>Let me know if you have any other Qs
>Shawn J
>
>
>"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote
in message
>news:unxbQIJ$DHA.2664@.TK2MSFTNGP09.phx.gbl...
>> How many users? How much data? How's your budget?
How's your experience
>> with SQL Server and/or Access?
>> Either can do what you've told us, but you've not told
us enough. :-)
>> --
>> Kevin Hill
>> President
>> 3NF Consulting
>> www.3nf-inc.com/NewsGroups.htm
>> "Shawn Johnson" <sejohnson77@.yahoo.com> wrote in message
>> news:%23mxZQkI$DHA.2040@.TK2MSFTNGP12.phx.gbl...
>> > I am somewhat new to database technologies, I only
have a basic
>> > understanding of relational databases.
>> >
>> > I need to figure out the best way to set up a
database (Tables and
>> fields).
>> > Crystal reports will be used for reporting.
>> >
>> > I am in the distribution business and I need to
create route lists for
>> > people who will go out and deliver catalogs to our
clients customers.
>Our
>> > client will send me their database of customers via
tab or comma
>delimited
>> > file. What I then need to do is import this file
into SQL and then
>output
>> > some nice looking reports for our carriers delivery
routes.
>> >
>> > The routes will be based on streets in a logical
geographical area which
>I
>> > hope I will be able to organize by postal code.
(Since postal codes are
>> > already organized for optimal delivery time and
coverage)
>> >
>> > I should add that I'm not even sure I need to use SQL
with Crystal, why
>> > wouldn't I use Access and just use the reporting
features in Access?
>> >
>> > Any help will be appreciated.
>> >
>> > Shawn Johnson
>> >
>> >
>>
>
>.
>

Wednesday, March 7, 2012

Operational but able to restore additional transaction logs

I have databases which have been left in the operational, but able to restore
additional transaction logs mode. I had done this last week thinking I could
easily setup log shipping that day. Tonight's backup will be the first full
backup corresponding with transaction log backups. The full backup will need
to run against this database which currently shows (loading) as its state.
Should this be removed or fixed somehow - at this point, I cannot delete, or
restore, or anything else including go to the properties to reset the state
because the database is not in the databases collection for this server...
so, what do I do now?
Regards,
Jamie
Wow, I figured that one out. I checked the sysdatabases as I had tried to
detach the database that was indicated as loading. Detaching removes it
from the sysdatabases. I only needed to refresh the Enterprise Manager.
Regards,
Jamie
"thejamie" wrote:

> I have databases which have been left in the operational, but able to restore
> additional transaction logs mode. I had done this last week thinking I could
> easily setup log shipping that day. Tonight's backup will be the first full
> backup corresponding with transaction log backups. The full backup will need
> to run against this database which currently shows (loading) as its state.
> Should this be removed or fixed somehow - at this point, I cannot delete, or
> restore, or anything else including go to the properties to reset the state
> because the database is not in the databases collection for this server...
> so, what do I do now?
> --
> Regards,
> Jamie

Wednesday, March 21, 2012

Optimization Job fails

Optimization Job fails

Optimization Job fails

Tuesday, March 20, 2012

Optimization and Integrity question

Optimization and Integrity question

Optimization and Integrity Error

Optimization and Integrity Error

Optimization and Integrity Error

Optimization and Integrity Error

Optimization and integrity check errors

Optimization and integrity check errors

Monday, March 12, 2012

Optimal Physical Layer config SQL Server on IBM xSeries 345 server

optimal location for database files on SAN?

optimal location for database files on SAN?

optimal location for database files on SAN?

Friday, March 9, 2012

Opinions needed

Opinions needed

Wednesday, March 7, 2012

Operational but able to restore additional transaction logs

OpenXML Identity Insert

Blog Archive

About Me