try putting square brackets [] around the database names

If I understand the question correctly my original answer holds true for unpartitioned tables.

You can partition more than one table across the same filegroups.

Unless you specify a filegroup in the create statement all the data would get written to the data file in the primary group.

to get data to write to a different...

From SQL2005 on a number of new databases roles were added to msdb to grant more granular roles to users in SQLAgent.

SQLagentReaderrole should be what you want.

David, I think you were just talking to someone who was a bit full of himself and wanted to plug his company .

People who don't understand what production dbas do...

Its completely dependant on the operating system, so windows standard edition 4GB, windows enterprise 32GB and on up dependant on OS version.

with 32 bit to be able to take advantage...

yep, boot from SAN solves all the issues when SAN replicating with SQL. wish my sysadmins would have allowed us to go that route.

Russell.Morgan-813114 (7/8/2010)

---

Sure, if every thing is the same it should work. The only difference here is the SQL install of the system databases will not be on the SAN on...

the main reason it does not normally work is because the server name is different or the install paths are different.

On the initial installs both servers must be built identically,...

why do you need to log ship and san replicate? I must be misunderstanding something? You might as well use the SAN replication as your only solution to replicate data.

As...

It will do but you will of course have to test it.

Most important is that this 'headware' replication is guaranteed with databases.

If you are renaming the server you will need...

tell them it can't be done, SQL does not work like that.

There are registry updates obviously and various bits of the shared tools plus the log files created during the...

Geoff, are you by any chance on SQL 2000, or maybe not using SSIS? (not to mention SSRS or SSAS)

If on SQL2005 you may be getting away with murder just...

Jeffrey Williams-493691 (7/7/2010)

---

Nope - the only files that are written to sequentially are the log files. If you have multiple files in a single filegroup, they will be written...

Pretty sure these go to the C drive.

It is not possible to prevent some components going to the C drive, some will no matter what you do.