exactly how many disks do you have available?

what version\edition of windows do you plan to use?

also dont forget to back up the database after the index rebuild as this could fill up the log file depending on database size and no of indexes

what is the result of the following query

select * from sys.backup_devices

exclude the scanner from scanning sql data and program files

you could use VBS something along the lines of

strComputer = "."

Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2")

Set colItems = objWMIService.ExecQuery( _

"SELECT * FROM...

Ellis (3/3/2009)

---

Hi All,

I'm really sorry for the vagueness of this question, I need to expand my knowledge on running SQL Server in a virtual environment, for example using...

have you mapped...

oohhh, this is pork chop territory. Me gonna duck and keep my faceguard on ROTFL

hey Jeff fancy seeing you in this thread 😉 LOL

you probably don't want to be\shouldn't nedd to be doing this daily

or just use the stored procedure

sp_chane_users_login

to resync the server login and database user

i assume you mean what are the ideal sizes for the log files?

the answer is how much activity is created against the database?

start off with 10% of database filesize...

check BOL for full info on how to set this up

muthuuu (2/24/2009)

---

I got following message in sql-error log

Configuration option 'max server memory (MB)' changed from 2147483647 to 8192.

Run the RECONFIGURE statement to install.

SQL Server has encountered 1 occurrence(s) of...

i would say if you dont have access to it there is possibly a very good reason

do you need to restore the db over the original or restore as another name?