Runal,

See my post, above sanket's.The document I provided you does say you need to stop the SQL Server service before moving the physical files.

Taking the Database Offline only makes the...

runal_jagtap (11/29/2012)

---

I did, Execute the Alter Datafile query

i got outut - the files are moved . next time when DB starts..

Fine enough..then i took the DB to OFfline state..

Now i...

Perry Whittle (10/12/2012)

---

Paul Clark-418949 (10/12/2012)

---

😛

For most of our VM's it is just 1 aggregate as you are correct NetApp best practice....

But I wanted the separate RAID Groups for the SQL...

Perry Whittle (10/12/2012)

---

Paul Clark-418949 (10/12/2012)

---

Perry Whittle (10/11/2012)

---

Paul Clark-418949 (10/11/2012)

---

C: Drive - Operating System - (Filer01 - Volume 1)

D: Drive - SQL Installation - (Filer02 - Volume 2)

F: Drive - Page...

Perry Whittle (10/11/2012)

---

runal_jagtap (10/11/2012)

---

Hi Paul,

thanks for providing the answer 🙂

Currently we have 5 servers...

For example..

1 server have 20 databases almost 20GB each.. now the tempdb files & user datafiles &...

Perry Whittle (10/11/2012)

---

Paul Clark-418949 (10/11/2012)

---

C: Drive - Operating System - (Filer01 - Volume 1)

D: Drive - SQL Installation - (Filer02 - Volume 2)

F: Drive - Page File - (Filer01 -...

runal_jagtap (10/11/2012)

---

Perry where r u???? 🙁

Say na what will happen if we do implement this???

What is the use of doing this???????

i wanna send email to my seniors so that they...

Hi Chandon,

Thanks for the Feedback.

chandan_jha18 (10/9/2012)

---

I have not gone through the script entirely but the part where you are generating an SQL command and then executing it.

If I were you,...

Fairy Snuff;-)

Hi Perry,

This might save some work:

I have already documented the steps for this in my Blog.

Let Runal know if the below links are OK

Moving TempDB Files - Just look at...

saidapurs (10/4/2012)

---

Hi Raj,

I have a doubt, we commonly using MSDTC in cluster environment and i am configured lot of...

Can't a Detach/Attach also cause orphaned SQL users?

Whereas using the alter table statements then offlining the DB and copying the files to the new location doesn't?

And Wouldn't the Detach/Attach...

As an addition to the above with MSDTC. If you are suing VMWare and deploying virtual machines from a Template, you may also see this error when setting up replication...

PS to the above...

For getting backup sizes:

SELECT [database_name]

,[recovery_model]

,[backup_start_date]

,[backup_finish_date]

,[type]

,[backup_size]

,[compressed_backup_size]

FROM [msdb].[dbo].[backupset]

ORDER BY [database_name], [backup_start_date]

The types codes are as follows:

D = Database

I = Differential database

L = Log

F = File or filegroup

G =Differential...

Hi Abu,

Okay then, the reason I asked the fourth question was to answer your question as to whether a 2 weekly full backup is adequate.

If you have a scenario where...