|
Disk Configuration Best Practices
Our insurance agency management system runs on SQL, and we'll be upgrading
to a new version of the system this summer. Their minimum specs require a
new server, and I have questions about the optimal disk configuration for a
new SQL server. Our server vendor (Dell) recommended running the OS on a
RAID1 se ...
Fri, 14 Jan 2005 13:40:01 -0600
|
move transaction logs for master/model/tempdb
I am configuring a new database server that has a RAID 1 array for the
transaction logs and a RAID 10 array for the data files.
During the SQL install process you are allowed to specify the location for
all datafiles but there is no way to specify one location for log files and a
second for data files. Th ...
Fri, 14 Jan 2005 11:37:04 -0800
|
adventure works database 2005
How do install the adventure works database if I've
already done the 2005 install. Also are there differences
between the 2000 version of AW and the 2005 version. Can I
just do a backup and restore off a 2000 machine. Please
enlighten me.
Bryan ...
Fri, 14 Jan 2005 11:05:15 -0800
|
SQL service logon account change problem.
Hello.
We have an SQL server that has been runing with the Domain Admin as logon
account for the service and everything was running fine.
Then we have changed the logon user name to another user that is Local Admin
on the SQL server and then the problem started.
As the server starts with the /PAE option , ...
Fri, 14 Jan 2005 10:05:46 +0100
|
SP3a upgrade (from sp2) fails due to ISPALUSER function...
Any ideas, any pointer would be greatly appreciated.
I checked on news groups one of the posting regarding this issue, says
patrol agent may cause this. But I do not have patrol on this server.
Creating procedure sp_MSrepl_PAL_rolecheck
Msg 195, Level 15, State 10, Server SERVERNAME, Procedure
sp_MSrep ...
Thu, 13 Jan 2005 08:51:01 -0800
|
SP3a upgrade (from sp2) fails due to ISPALUSER function...
Any ideas, any pointer would be greatly appreciated.
I checked on news groups one of the posting regarding this issue, says
patrol agent may cause this. But I do not have patrol on this server.
Creating procedure sp_MSrepl_PAL_rolecheck
Msg 195, Level 15, State 10, Server SERVERNAME, Procedure
sp_MSrep ...
Thu, 13 Jan 2005 08:43:04 -0800
|
Trouble connecting Win2k clients to SQL Server 2000
Some background: I've recently installed a new server running SQL Server
2000, which came bundled with Microsoft SBS. The existing network is a
simple workgroup, and the SBS server defaults to a domain - it will not
allow you to install it as a workgroup..
The WinXP clients can "see" and log into the serve ...
Thu, 13 Jan 2005 09:03:37 -0500
|
Restore database
I'm new to sql. i need to restore a data base that was in one server to
another server. but when i try to do it i get obdc error 42000. i'm using sql
2000. the error states that i should use move instead of restore. our old
server died during the holidays and i'm setting up the new one. the old
server was 2 ...
Thu, 13 Jan 2005 05:57:04 -0800
|
How to change owner of msdb and model to sa
Is there any other method that I can change the own to sa for msdb and model?
For instance, register as 'sa' then detach/attach msdb and model? Their
current owner is service account "serviceSQL". We want "sa" to be owner. As
far as I know, we can't use sp_changedbowner to change msdb and model owner:
>
> ...
Wed, 12 Jan 2005 09:47:08 -0800
|
Querying across databases on same server
I know that a heterogeneous query joining tables from two different servers
has performance penalties but is the same true when joining tables from two
different databases on the same SQL Server 2000 instance?
We are looking at setting up a Data Warehouse using DTS on a SQL Server box
and I'm wondering about ...
Wed, 12 Jan 2005 09:28:57 -0600
|
SQL server configuration backup
Hi
Anybody knows how to document (or find out or backup) SQL server (not
specific db) configuration ?
TIA
Jan
...
Wed, 12 Jan 2005 15:31:10 +0100
|
SQL server 2000/2005 install menu sounds!
Not a huge deal, just an annoyance(and a sign of an unprofessional-
acting install program). I went to re-install SQL server 2000 client
tools on a new Windows XP Pro system, and even though I have my sound
scheme in control panel set to NO SOUNDS, the installer played castanet
and whooshing sounds when I m ...
Tue, 11 Jan 2005 11:27:26 -0800
|
Software for connecting to a remote SQL Server
Hi All,
I would like to be able to connect to a remote SQL Server and fire arbitrary
queries, browse tables, and so forth. Very much li ...
Tue, 11 Jan 2005 18:45:52 GMT
|
Memory Question
I have Windows 2003 Enterprise Server with SQL 2000 Enterprise Editon.
The server is a Quad 3.2 system with 7GB of ram.
Right now I have in the boot.ini both the /PAE and the /3GB switch.
AWE is dissabled at the moment.
When I look at memory under properties in SQL Enterprise Manager, for the
SQL server i ...
Tue, 11 Jan 2005 10:09:02 -0800
|
Cannot connect across Internet
I am attempting to connect to a named instance of SS 2000 across the
Internet using Enterprise Manager. The machine running SS is behind a NAT
router. According to BOL I should be able to connect if I forward the TCP
port that SS is using (1061 in my case) and UDP port 1434 to the SS
machine. However, I can ...
Tue, 11 Jan 2005 06:50:24 -0800
|