Thanks for that Rob. 🙂

Thanks for your help 🙂

Right, but which is the best way to change the...

Thanks for the links.

However, after having a brief look at them, I wonder if you've (or perhaps me) have not quite grasped my issue.

PowerShell works fine. I have been able...

Thanks for the links.

I read the comments and Microsoft's response and I'd have to say that their stance was pretty weak.

Thanks for the info, but if I may, could I please seek clarification on the following points:

1. I understand that a "Copy-only" backup is independant of other backups - particularly...

Absolutely perfect reply! 🙂

As a novice, I do find a reply like yours most helpful as it boilds down the technically written articles in some of the links provided.

I did...

Thank you.

I will take a look at this although I have heard of snapshot isolation, I do...

Fantastic!!

That's just the sort of thing I was looking for - a query to identify what tables belong to what filegroups! 🙂

This query has allowed me to see that I...

sturner (12/1/2011)

---

If you moved tables from the file group by rebuilding the clustered index to another file group that will not move any non-clustered indexes on the table(s). You'll have...

No, it's not the PRIMARY group.

Well, after looking up the syntax to restore the database with the MOVE option and directing the restore to another drive for both the data and log files the result...

Yes.

The F: drive is where this database also has a partitioned table which is fully accessible. The F:\Data\FSFG1 file/folder was an old filegroup used for evaluating the FILESTREAM functionality in...

Yep, drive F: is alive and kicking and I can see no issues with it.

By the way, everything is running locally. i.e. all drives and my SQL Server/SSMS are all...

GilaMonster (11/14/2011)

---

SELECTCOUNT(Price),

Price

FROMTempSales

GROUP BY Price

ORDER BY Price;

That's a really, really weird query to run. Count the non-null values of price for each unique value or price, then order by the same...