database data files setup
Thu, 21 Aug 2008 09:30:04 -0700
I Have a database that has 120G imported from other database. Now I am
planning to setup this databse. I want to use more file groups. Except file
groups, I wonder which is better if I use one file or more files in one file
group to handle it. e.g. 100g, do you think if I use one file for 100g or 5
files a ...
|
Can't connect to WS2008 SQL2008
Thu, 21 Aug 2008 06:42:02 -0700
I can't connect to an SQL2008 server on a WS2008 server.
I have set the server connections property to allow remote connections.
I have enabled the firewall port 1433 for TCP.
I have enabled the firewall port 1434 for UDP.
This is a named instance on a server without a default instance.
I can turn off the fi ...
|
Can't REstart the SQL Server Browser Service
Thu, 21 Aug 2008 06:13:01 -0700
I stopped the SQL Server Browser after developing a web site in VWD so I
could copy the database to the remote server. Now I am unable to restart it:
when I right-click the icon in the Configuration Manager, all the dropdown
items are greyed out except 'Properties'.
The local database was created under VWD ...
|
SQL Server 2005 -> Security - > Logins (Rename machine)
Wed, 20 Aug 2008 15:21:03 -0700
Dear Sir or Madam,
Sorry about the long description, but it is necessary.
I am using virtual machine.
I have created a Windows Server 2003 virtual machine with SQL Server 2005,
named VM001.
System Preparation Tool (sysprep) was executed on VM001.
The sysprep'ed virtual machine was deployed as anoth ...
|
Cannot remove SQL Server 2008 RC0
Wed, 20 Aug 2008 11:37:57 -0500
Before attempting to install the released version of SQL Server 2008, I
attempted to remove RC0 via Add/Remove Programs. This goes through (and
passes) a list of initial requirements, then fails with the following error:
TITLE: SQL Server Setup failure.
------------------------------
SQL Server Setup ha ...
|
deploy .NET 3.5 UDF to SQL Server 2005
Wed, 20 Aug 2008 06:46:10 -0700 (PDT)
Dear All,
I apologize if this question is trivial but I could not find a
concrete answer. Is it possible to deploy UDF's developed with .NET
3.5 to a microsoft SQL Server 2005?
Any comments would be most appreciated.
Kind regards
Jan ...
|
New install, Small Business Server 2003
Tue, 19 Aug 2008 14:00:50 -0700 (PDT)
Greetings all,
I am attempting to get SQL Server 2005 Express running on a freshly
installed Windows Server 2003 Small Business Server machine.
I wiped this machine and installed 2003 Small Business Server. After
installing the .NET 2.0 Framework I uninstalled most of the 2003 SBS
programs and servers. We r ...
|
|
|
SQL Cluster Node
Tue, 19 Aug 2008 13:21:51 -0500
One of the nodes on our active/passive cluster lost connection to the SAN
due to a faulty port on our fibre switch recently. Now this node shows none
of the resources to be available. The quorum and two other disk partions
show up in disk management as unavailable on this passive node.
Is this normal behavi ...
|
SQL 2005 Install on a WTS Server
Tue, 19 Aug 2008 10:52:03 -0700
We have a department that would like to Install a SQL 2005 Application in a
WTS Server.
My question is, are there any issues that one would run into if you install
SQL 2005 in a WTS (Application Mode) on Windows 2003?
The following article says they are not supported but this article only
deals with clu ...
|
Can SQL 2005 see the memory that OS can't see?
Mon, 18 Aug 2008 23:45:01 -0700
We run Windows 2003 standard SP2 and SQL 2005 standard SP2, the box has 10GB
RAM, of course it's a waste because the OS can only see 4GB of it, my
question is if I enable AWE, can SQL 2005 see the rest of RAM? Or it limit to
what the OS can see?
I've added /3GB in boot.ini, do I need /PAE if I enable AWE ...
|
