danchard (2/23/2009)

---

Hi all,

Thanks for your advice so far.

When attempting to shrink the database using dbcc shrinkdatabase should I be using notruncate or truncateonly? I would have thought that truncateonly would...

did you download and install the backward compatibility DTS designer tool?

all you should need to do is possibly amend connection strings if they refer to the old server by name,...

for a standalone install the default instance name is the name of the server, for a cluster the SQL name you actually connect to is the virtual server name. within...

if you are using sp_help_revlogin you won't get any orphaned users. Make sure you use the 2000 to 2005 version of sp_help_revlogin.

http://support.microsoft.com/kb/246133

As for databases or logins first, either will...

post index definitions as well.

I am wondering about row sizes here. not quite sure why copy to a new table compacts it so much though. (but must be a clue...

I think you will need to post your table schema as well. and the showcontig results if you have them.

Whats the fillfactor on the clustered index?

Is the row size around...

Howard is correct the only backout is to uninstall\reinstall. Do yourself a favour, before starting the upgrade, stop the instance and do a file copy of the system databases to...

well server was rebooted at weekend and lo and behold SQL is now happily using 2.5GB memory for the buffer pool, so that solves that one.

cheers for your time everyone.

has the network authority account for the secondary server been granted rights to the share on the primary perhaps?

Lynn Pettis (2/13/2009)

---

george sibbald (2/13/2009)

---

note you don't have to create a database first before doing a restore. Its also a lot easier to understand what's going on if you do...

note you don't have to create a database first before doing a restore. Its also a lot easier to understand what's going on if you do it via scripts rather...

exactly, which is why I want SQL to use the extra memory I made available to it. It looks as if the sysadmins did not reboot...

Charles Kincaid (2/11/2009)

---

Let me see if I can show what is going on here and why. Lets number the lines

(00) PRINT '1' -- /* ;PRINT '2' */ ;PRINT '3'...

personally tested two variants: multiple files on the same drive (array) versus multiple files located on separate drives and the performance gains are significant when using the second...

Gail,

thanks for the feedback. It confirms my thoughts on the subject. One thing I am having quoted at me is that with a lot of databases on SANS nowadays...