lcibert (5/12/2010)

---

Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) = 2005 SP1 RTM

And I cannot upgrade it because it's not supported by the application vendor for what I'm...

Icibert

what version and SP of SQL Server 2005 are you using? (e.g. 9.00.1399, etc)

Hi

For SQL Server 2005 move the master first using the following

Edit the SQL server service and change the paths for the MASTER data and log files to the new location....

sqlquery-101401 (5/12/2010)

---

thanks , actually i need some concrete link to prove H/W raid performance advantage over S/W but did not find much on internet that really stop to opt my...

your welcome

have you rebooted after installing the hotfix?

if your looking for performance then simple DON'T use an Access front end!!

Whilst Access will process as much of the query as possible on SQL Server most times the data...

doesnt matter if you are logged onto the machine via the virtual name. You need to tell SAC manager by clicking the 'change computer' option and specifying the virtual server...

ah that explains things. There are a few issues with STSADM not the least the restriction on the site size. If the site is larger than 10-15 GB you may...

in my experience people always elevate privileges in a vain attempt to make things work, rather than sit down and work out what is required!!

ensure the IP address you specify for the SQL Cluster instance is unique. You will need to provide more details of the settings you are specifying during install. Have you...

what makes you think that??

if they are importing data and the database objects already exist...

they should already be set for you but there is no harm in checking them

K. Brian Kelley (5/3/2010)

---

Are you using a Symantec/Veritas product to backup the server? If so, it likely recognizes that there is a SQL Server on the system and is using...

specifically, ensure you run DBCC UPDATEUSAGE against the database.