Moving Database Files

Backing Up and Restoring a SQL Server 2008 Full-Text Catalog

Considerations for Backing Up and Restoring System Databases

Considerations for Backing Up the master Database

Considerations for Backing Up the model and msdb Databases

Once a dirty page has been written to disk it is either kept in the buffer pool for further access or it is returned to the free buffer list for...

Is the SQL Browser service running locally? Also, what happens if you manually type in the instance names and try to connect?

It also depends on other factors as well, such as:

SP version and service pack level

what databases

SharePoint included a procedure called defragmentIndices after SharePoint 2007 SP2.

Not an expert on SSIS, but from BOL:

RESOURCE SEMAPHORE

"Occurs when a query memory request cannot be granted immediately due to other concurrent queries. High waits and wait times may indicate...

I would avoid xp_fixeddrives. It does not recognize mount points. You will get much better information querying the win32_Volume WMI class. You can do it easy if you are using...

This is a SQL Server 2000 forum that is buried at the bottom of the forums page. You may want to post your question to the SQL Server 2012 forum:

SQL...

Actually if they are not saved I find that SSMS does tend to prompt you if you want to open previously opened Query Editor windows. You get a window with...

Can you post a screen shot of the GUI so we can verify what options you should be selecting? Otherwise like Anthony stated T-SQL is the way to go. It...

I second this. We need more info. Does the SQL group have an associated user in the database that you are trying to access?

You are going to need to ensure that you know what ports SQL is listening on and ensure that the firewalls of your end pc, DSL/cable router and any ISPs...

Yes, SQL Server 2012 supports DB mirroring as well as a new feature called AlwaysOn, which is like advanced DB mirroring that can mirror groups of databases to multiple secondaries.

Here is something close to what I use to get version information. not sure what you would have to do in order to get the ports SQL is listening on....

What are you trying to accomplish?

A SQL alias is used for a client to connect to a server instance using a different instance name than what the server is configured...