I did stop and start the...

Hi,

I need to configure the Share Point 2010 databases in SQL Server 2008 R2.

Microsoft recommends the below best practice for creating the database

Use multiple data files for content databases

Follow these...

Thanks for your inputs...

1. Can we rename the Mount Points after installing SQL Server?

2. How to get the Free space, used space for Mount Points?

Can you provide me that link where it says this best practice is applicable...

The default connection settings for Oracle is explicit transactions. Which means you have to specifically issue a commit or rollback.

In SQL Server, the default is implicit transactions - which means...

Thank you.

Windows admin created mount points as below:

D:\Data -> for data files

D:\Logs -> for log files

D:\TempDb -> for tempdb

Now before installing sql server, can we create a folder called INS1...

Wait...just realized you are talking about jobs. What are your settings for the agent history? If this is the default, then you could be running into an issue where another...

Hi,

I do have the same question. Please advice

Thaks

Hi ,

I did find some article at http://www.sqlservercentral.com/articles/Clustering/65968/

"Clustered SQL Server 2005/2008 Installation Using Mount Points "

But looks like It has been removed as per author's request.

If...

I ran the below command and it's ran successfully

DBCC CHECKDB(msdb) WITH no_infomsgs, all_errormsgs;

There is NO maintenance plan to remove history.

Please advice what else I need to check?

SQL is licensed per Physical CPU. How many physical CPU's do you have?

Also, in order to be able to REALLY take advantage of virtualization, you might want to purchase Windows...

Could you explain me the steps to connect sql instance using DAC?

Thanks

I will test it and come back with the results:-)

Thanks

I went through the link http://technet.microsoft.com/en-us/library/bb933993.aspx

which says "A FILESTREAM filegroup is a special filegroup that contains file system directories instead of the files themselves. These file system directories...

Guess it needs the line feed also. This should do it.

select 'USE ['+name +']' + CHAR(13)+CHAR(10)+'GO'+ CHAR(13)+CHAR(10)+

'CREATE USER [abc\scott] FOR LOGIN [abc\scott]'+ CHAR(13)+CHAR(10)+'GO'+ CHAR(13)+CHAR(10)+

'USE ['+name +']' + CHAR(13)+CHAR(10)+'GO'+ CHAR(13)+CHAR(10)+

'EXEC sp_addrolemember...