Can I create a second filestream container on an existing SQL Server 2008 database without going offline?
Let’s find an answer to "Can I create a second filestream container on an existing SQL Server 2008 database without going offline?". The most accurate or helpful solution is served by Database Administrators.
There are ten answers to this question.
Best solution
Our production DB is using the FILESTREAM option for our sharepoint environment. The volume where the files are residing is getting full and I am planning to add another volume to ease space issues. Is the solution as simple as creating another filestream container and adding this container on the existing filestream filegroup? Would SQLServer take care of balancing among the two volumes?
Answer:
Unfortunately no, not in SQL Server 2008. According to FILESTREAM Overview - multiple containers can...
erickson miranda at Database Administrators Mark as irrelevant Undo
Other solutions
I back up the database in sql server 2008 to the file has extension ".bak". After i send it for my friends in group. He said "i can't restore the file to database in sql server 2005"? Can you help me? Thanks!
Answer:
Because they're not backwards compatable. You'd see the exact same problems if you tried to open a MS...
Ko aj ca at Yahoo! Answers Mark as irrelevant Undo
Can you please tell me how to export database from sql server 2008 to ms access , only the table structure... not the data
Answer:
Right click your table name > "Script Table as" > CREATE To > New Query Editor Window...
NVAQOCYYEBL77Y54BB5IHCHOB4 at Yahoo! Answers Mark as irrelevant Undo
i am trying to insert values in a table in sql server 2008 the value inserts successfully but the problem is that, the values stores in random order. not in the order in which i inserted value in table
Answer:
SQL makes no guarantees about the order records are stored in. While an identity column will give you...
amit at Yahoo! Answers Mark as irrelevant Undo
i am trying to populate my tables for a project in school at home and sql server will not allow me to work on them. any help would be great. thanks
eric s at Yahoo! Answers Mark as irrelevant Undo
We have hundreds of report stored procedures that we are wanting to create a reporting only database and drop all columns that are not used by any of the stored procedures.
Answer:
There is no easy way to do this that I'm aware of for columns. You can pretty easily determine the tables...
Grant Fritchey at Quora Mark as irrelevant Undo
At work(I'm new) I have to use sql server 2008 R2 and from there connect to a server. Databases can be seen once opened. I use a client program(company program)which asks you to enter a database and a sql server name and am a bit puzzled.I assume databases...
Answer:
Absolutely. The above statement is correct. Your client application that connects to a given database...
fashionw... at Yahoo! Answers Mark as irrelevant Undo
Hi I'm trying to run a PHP chat bot called Program E. The installation instructions asks me to "Create a database for the program to use in MySQL". I have PHP5, MySQL, Apache2 on Ubuntu 8.10. My question is, how do I actually create a database...
Answer:
Write mysqladmin in a dos window followed by the database name you want to create C:\>mysqladmin...
apple guava at Yahoo! Answers Mark as irrelevant Undo
I am starting some tutorials on microsoft sql server 2005 since it came installed on my computer. The question is when I go to all programs : microsoft sql server 2005 I do not see were I can launch it. When I go under microsoft sql server 2005: under...
Answer:
Look for "SQL Server Management Studio" - this is what you'd typically use to create databases...
the man at Yahoo! Answers Mark as irrelevant Undo
I am currently enrolled in a college sql class and have a lot of questions that the teacher can not answer immediatly due to it being an online class. here are some of the questions I have 1. It seems that sql server 2008 comes within the visual studio...
Answer:
Visual Studio comes with a 'light' version of SQL Server - SQL Server Compact, not the full version...
alphagre... at Yahoo! Answers Mark as irrelevant Undo
Related Q & A:
- How can i create a mobile application server?Best solution by Stack Overflow
- Can I have a second bachelor's degree in the USA?Best solution by sasundergrad.rutgers.edu
- Can I add a second Yahoo ID for myself?Best solution by Yahoo! Answers
- How can I make a second email address on yahoo.com?Best solution by Yahoo! Answers
- How can I make a second Yahoo e-mail address?Best solution by techwalla.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.