Russell101 (4/8/2013)

---

I have recently taken on responsability for the database part of our Sharepoint solution. From looking at the documentation there are instructions on how to move from the primary...

iamsam.sandeep (4/9/2013)

---

In a active passive node if i start the sql service , and Full text search on a passive node what will happen. Can any one help me on...

is this a workgroup or a domain?

There needs to be a trust relationship between the domains otherwise just use SQL Server authentication

Yes, that's how you remove a file in a sql server database.

dan-572483...

It will be unaffected providing the log doesn't then run out of space afterwards.

i use a combination of the date last updated and the amount of data modified

you will never be able to remove the primary data and log files they must always remain.

To remove an unwanted log file use DBCC LOGINFO against the database in question...

In that case the create file operations on the principal will put the mirror session into suspended mode. Check this link for details of how to fix this scenario.

As a default, only administrators will have ACLs to read and write files to the root of a drive. Create a folder and give the database engine sufficient permission, then...

winmansoft (4/8/2013)

---

I have moved the model database by using following method

1. For each file to be moved, run the following statement.

ALTER DATABASE model

MODIFY FILE ( NAME = modeldev ,...

First question is

Do the database file paths match on both servers?

So, for instance if the database files on the Principal are located in

D:\MSSQL_10.50.Prod\MSSQL\Data

Does this path exist on the mirror or...

muthyala_51 (4/4/2013)

---

Perry,

I was not able to follow this statement, can you please elaborate--

The key to remember here is how the clustered instances will be distributed, just because you install a...

You started the instance in single user minimal config mode?

If all the system database files have been wiped out, you cannot start in single user mode as SQL Server expects at least the master database to be present and...