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

Can I create a second filestream container on an existing SQL Server 2008 database without going offline?

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...

Read more

erickson miranda at Database Administrators Mark as irrelevant Undo

Other solutions

Why do i can't restore database in sql server 2005 from the database in sql server 2008?

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...

Read more

Ko aj ca at Yahoo! Answers Mark as irrelevant Undo

Export database from SQL server 2008 to MS access?

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...

Read more

NVAQOCYYEBL77Y54BB5IHCHOB4 at Yahoo! Answers Mark as irrelevant Undo

Inserting value in database table in sql server 2008?

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...

Read more

amit at Yahoo! Answers Mark as irrelevant Undo

How do you create a new database in SQL server?

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

Answer:

Right click on the "Databases" folder and select "Add Database..."

Read more

eric s at Yahoo! Answers Mark as irrelevant Undo

Where is a script to list all tables/columns in a SQL Server 2008 R2 database that are not referenced in any stored procedure?

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...

Read more

Grant Fritchey at Quora Mark as irrelevant Undo

Definition of sql server, database engine, dbms and how they all work?

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...

Read more

fashionw... at Yahoo! Answers Mark as irrelevant Undo

How to create a database for program to use in MySQL?

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...

Read more

apple guava at Yahoo! Answers Mark as irrelevant Undo

How do I access microsoft sql server 2005?

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...

Read more

the man at Yahoo! Answers Mark as irrelevant Undo

Questions relating to beginner sql server and database?

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...

Read more

alphagre... at Yahoo! Answers Mark as irrelevant Undo

Related Q & A:

Just Added Q & A:

Find solution

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.