Note you still can't delete the primary file group.

Larry.Thompson 62346 (5/8/2013)

---

From an AI research project in college, I discovered that our distint advantage over machines isn't our ability to be precise, but our inability. Our minds often...

You can query sys.databases to see if the database exists.

If so, then you'd have to query sys.database_files in that database to get the file location. You can do that like...

Lynn is correct, use with Standby.

http://msdn.microsoft.com/en-us/library/ms188223.aspx

The default data path is stored in the registry. Here are some answers, but it's the one that reads the registry that you want

http://stackoverflow.com/questions/1883071/how-do-i-find-the-data-directory-for-a-sql-server-instance

You can't change the primary filegroup AFAIK. You can change the default filegroup. (http://msdn.microsoft.com/en-us/library/aa933074%28v=sql.80%29.aspx)

http://www.mssqltips.com/sqlservertip/2601/using-multiple-filegroups-for-a-database-and-changing-the-default-filegroup/

If you are trying to move to a new disk, detach the database, move the files, attach...

It very much depends on your business, but I can give you a few things I've seen people use.

1. AlwaysOn Availability Groups - Get some HA and offload reporting in...

It's not a simple thing to debug and trace down.

SQL Server can run fine under virtualization, but you have to understand that configuring xx resources for a VM doesn't mean...

Check this: http://msdn.microsoft.com/en-us/library/ms190673%28v=sql.105%29.aspx

I'd also make another backup of the source database, ASAP.

FunkyDexter (5/7/2013)

---

I think it's a "right tool for the right job" scenario. Most of the folks who object to putting data in the cloud are thinking about mission critical...

I'd try to copy this file and restore it on another system. I suspect your file might be corrupt.

The full backup isn't backing up the log, unless the index rebuild is running while the full backup is running. Then it will catch items changed during the data reading...

Some of this is on the list. I've bumped it up a bit.

BOL doc: http://msdn.microsoft.com/en-us/library/ms188365.aspx