I'd be inclined to agree.

Where are your disks presented from for the mounted volumes are they...

yes, it is a change to the registry. The cluster service should replicate the key change to all nodes required

for mounted volumes use the following

wmic volume get name, "Free Space", capacity

Transaction log backups are an important part of log shipping. Digest the info in books online and post back if you're still stuck.

chopperGuy (12/16/2011)

---

We have an environment which has database close to 500 GB. The log backups generate about 80-90 GB worth of logs.

Problem we are facing is that copy process...

I would of thought you would see a message indicating that the master key already exists, firstly check the results of

select * from sys.symmetric_keys

If you have more than 1...

Good call 😉

This is an ideal scenario for creating package configurations. when creating a configuration elect to use SQL Server roles and security. Export your chosen connection string objects and they are...

How much free space did you leave?

The Enterprise eval is for exactly that, not for testing your apps\software releases. I'm sure that's in the EULA somewhere!!

No xp_cmdshell, just execute the vb script from a SQL server agent job step

homebrew01 (12/12/2011)

---

I want to install an instance of 2008 R2 on my development box that already is running 2005. Any suggestions or best practices for locating/naming folders, files, defaults etc.....

Tristan Chiappisi (12/13/2011)

---

Hello,

I'm looking for a solution for moving large files across data centers (in the sense of making it faster). Has anyone had much luck with any programs out...

vkr.karthick (12/13/2011)

---

I need to install Microsoft Sql standard R2 Sp1 64 bit version for my testing can anyone send a link

I tried download from Microsoft site but could do only...

it all depends on which other options you selected in the GUI, for instance did you elect to "reorganise pages before releasing unused space"?

Remember to leave enough free space...