create index and alter index rebuild are both minimally logged.

What is it leads you to believe they're not?

hi

can you post a screenshot of the server logins from management studio

in my opinion only when using a windows workgroup

local accounts work even on a domain, but you have to replicate them from machine to machine using the same username and password, much the same as you do in...

either perform a

RESTORE FILELISTONLY FROM DISK = 'diskpath\filename.bak'

or use the following against the original database

Use yourdb

exec sys.sp_spaceused

this will give you an idea of the space used\required

If you're using VMWare ESX\VI then VMWare don't recommend 4 vCPU's. In extreme cases it can cause the host CPU to max out. All VM's are generally created with 1...

Grant Fritchey (4/19/2010)

---

I agree with almost all of the advice here with one exception... DTA is a pile.

For anything beyond the simplest mom&pop sized database, it's recommendations are so...

You only need to licence the physical CPU sockets or in the case of a VM the virtual CPU's.

If you license the VM host machine at SQL Server Enterprise edition...

i could be wrong but i believe that should be COPY_ONLY, this stops the backup interferring with the usual backup regime currently in force on the source server

Jeffrey Williams-493691 (4/17/2010)

---

Really? I was not aware that a login has a database. Once the login has been created on the destination system with the correct SID, the...

ahh that old chestnut. Procedural vs set based 😀

Hi

i'm assuming you want to transfer your Access database to a SQL Server database. If so, try the "Upsizing Wizard" in MS Access 2003

firstly using the SA account to provision access to a sql server database is a really bad idea.

If you restore a database to a different server without exporting the server...

Steve has the correct solution here!

ha...