BOL is a good start

as a side make sure you change the account details via SQL configuration manager 😎

the datareader role should grant select to all tables

you should be able to patch both instances at once, did you select both detected instances?

Have you checked the patch log file to find out why it failed?

wow as little as that. 20GB will just about home the OS,...

stick it on the moon then its got all the space it needs.

dakshinamurthy (9/26/2008)

---

Hi,

I would like to start and store the sql profiler trace in a location, but it should be automated, i mean to say instead of...

onlo (7/2/2008)

---

There were no difference between "Total Server Memory" & "Target Server Memory"

However, I found both of its "Total Server Memory" & "Target Server Memory" are far below the physical...

you can use 1 maint plan if you like, launch the wizard and it asks "schedule for each...

Ray Herring (9/23/2008)

---

The two obvious options Detach/Attach and Backup/Restore are not attractive in the case of a new server because of the time required just to copy the files between...

yes VS 2005 Ent was what i used for local VM's. As i said i wouldnt attempt to run a SQL VM in anger on these platforms due to the...

bkDBA (9/23/2008)

---

Perry Whittle (9/23/2008)

---

are you using the Windows 2008 hyper V or Virtual 2005 Enterprise?

I had a 2 node SQL cluster running on my machine sometime ago...

what virtualisation platform...

Use something along the following lines

RESTORE DATABASE MYNEWDBNAME FROM DISK = 'D:\PATHTOFILE\BACKUPFILE.BAK'

WITH MOVE 'MDF LOGICAL FILENAME' TO 'F:\NEWPATH\NEWFILENAME.MDF',

MOVE 'LDF LOGICAL FILENAME' TO 'E:\NEWPATH\NEWFILENAME.LDF',

RECOVERY

Replace shouldnt be needed as the new physical...

when setting up log shipping it can have 1 of 2 states, WITH STANDBY or WITH NO_RECOVERY

STANDBY is the first. The database is in a read only state and clients...