December 13, 2011 at 7:51 am
1. What is the recomendation for analysys server configuration to put temp directory and back up derectory to which drive?
2. Is sa account for this installation needs to be created before you create sql server installation?
3.How to configure filestream?
• Enable FILESTREAM for Transact-SQL access
• Enable FILESTREAM for file I/O streaming access; here you can specify the windows shared folder name
• Allow remote clients to have streaming access to FILESTREAM data
I don't understand which I should use
Thank you
December 13, 2011 at 4:21 pm
1. What is the recomendation for analysys server configuration to put temp directory and back up derectory to which drive? http://technet.microsoft.com/en-us/library/cc281997.aspx
2. Is sa account for this installation needs to be created before you create sql server installation? No
3.How to configure filestream? Check all. How-to-use-filestream
December 14, 2011 at 2:16 pm
1. What is the recomendation for analysys server configuration to put temp directory and back up derectory to which drive?
I don't know the answer to this one because I don't do SSAS, but I would venture a guess that you want the temp directory on a different set of spindles than you SQL Server data, log, and backup files. You backup directory should have it's own spindles if possible. At the least it should be on different spindles than what you are backing up.
2. Is sa account for this installation needs to be created before you create sql server installation?
You can specify the sa account during installation. You do need to have the password decided. If you can you should just use WIndows authentication.
3.How to configure filestream?
• Enable FILESTREAM for Transact-SQL access
• Enable FILESTREAM for file I/O streaming access; here you can specify the windows shared folder name
• Allow remote clients to have streaming access to FILESTREAM data
Check out the BOL section on Filestream, http://msdn.microsoft.com/en-us/library/cc645923.aspx. If you have specific questions after reading that post them here.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply