FreeHansje (7/22/2008)

---

Tnx Cath,

Did not link the Client Config Tool with this problem as a solution.

Now to find how to restore my Admin privilege on my pc, which also seems to...

are the file paths exactly the same on the new server?

what steps did you take to move the databases and what commands did you use?

what errors are you getting?

datareader only applies to user tables so should be safe

as wildcat mentioned above, to move a table create a clustered index on that table into the new filegroup with drop existing on the tablename. Logically when you create the...

the datareader role should grant select on tables.

of course you could modify the public role but i wouldnt recommend that

depending on your disk subsystem set up really, extra filegroups are only worth it if they will be placed on separate disks\arrays.

you create the filegroup using the alter database. Add...

dynamic disks are designed to support...

set the database offline and move the disk file(s) to the new location(s) then run

alter database dbname modify file

(name = logical filename,

filename = driveletter\path\filename.extension)

for each file you move.

Bring the...

you cant just copy master and msdb, what if the collations are different between servers?

do you have any SSIS packages?

do you have any custom jobs running against the db?

are you...

this should do it

if not exists (select name from sys.configurations where name = 'xp_cmdshell' and value_in_use = 1)

begin

EXEC sp_configure 'show...

follow these steps

move the MASTER DB first. Stop the sql instance and agent and copy the database files

(master, model, tempdb, msdb, mssqlsystemresource and dist DB files) to their new...

check the NTFS file permissions on the data files

as above

Michelle Potts (7/21/2008)

---

Thank you everyone for your suggestions. I am typing up a plan that I will post when complete. However, I have another question...

The new server will...