First, when you ask for help, please provide the DDL (CREATE TABLE statement) for the table(s) involved, sample data (INSERT INTO statements) for the table(s) involved, the exact expected results...

shivang.rdesai (5/3/2016)

---

SELECT Product Class, sum([Nett])

FROM (([FactSales]

inner join [Date]

on [FactSales].DateKey = [Date].DateKey)

inner join [Product] on [Sales].ProductKey = [Product].ProductKey

inner join [ProductCategory] on [Product].ProductCategoryKey = [ProductCategory].ProductCategoryKey)

inner join [Store] on [Sales].StoreKey = [Store].StoreKey)

where FullDate...

Post...

Not enough information to help or validate, sorry.

jasona.work (5/3/2016)

---

Lynn Pettis (5/3/2016)

---

jasona.work (5/3/2016)

---

So, if the server is in a locked room, that I don't have...

jasona.work (5/3/2016)

---

So, if the server is in a locked room, that I don't have access to, on...

ScottPletcher (5/3/2016)

---

I coded the backups to go to c:, which is local drive for that node...

Luis Cazares (5/3/2016)

---

Is this...

cookiemonstagt (5/3/2016)

---

Lynn Pettis (5/3/2016)

---

They are system databases required by SQL Server to run correctly. Without them...

+1000

They are system databases required by SQL Server to run correctly. Without them you have no...

Some people should not be allowed any where near a database server.

cookiemonstagt (5/3/2016)

---

Oh my

.. thanks and one last question if the db is shared each node has these 3 files to be able only to run the...

ScottPletcher (5/3/2016)

---

You can backup the dbs using the commands below from within SSMS or other appropriate SQL utility. Since someone has gone to the trouble to cluster the SQL...

cookiemonstagt (5/3/2016)

---

Hello SQL community, I need some help with the following task that I have, as I'm not into SQL and I will really thank you for helping me,...