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.
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?
Unfortunately no, not in SQL Server 2008. According to FILESTREAM Overview - multiple containers can...
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!
Because they're not backwards compatable. You'd see the exact same problems if you tried to open a MS...
Can you please tell me how to export database from sql server 2008 to ms access , only the table structure... not the data
Right click your table name > "Script Table as" > CREATE To > New Query Editor Window...
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
SQL makes no guarantees about the order records are stored in. While an identity column will give you...
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
Right click on the "Databases" folder and select "Add Database..."
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.
There is no easy way to do this that I'm aware of for columns. You can pretty easily determine the tables...
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...
Absolutely. The above statement is correct. Your client application that connects to a given database...
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...
Write mysqladmin in a dos window followed by the database name you want to create C:\>mysqladmin...
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...
Look for "SQL Server Management Studio" - this is what you'd typically use to create databases...
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...
Visual Studio comes with a 'light' version of SQL Server - SQL Server Compact, not the full version...
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