ALTER DATABASE <database name>

MODIFY FILE (Name = <file name>, OFFLINE);

No, no, no, no, don't do that.

What's the exact state_desc of the file? (sys.database_files)

L' Eomot Inversé (2/7/2014)

---

I don't think that 30 seconds interval changes anything so far as altering data is concerned- nothing can be written to database pages on disc for which...

And if you try to drop the filegroup? An error that it's not empty?

ricardo_chicas (2/7/2014)

---

I would love to drop that filegroup but on the current state everything I have tried returns an errors saying that it is not possible because the filegroup is...

Can you not just drop the filegroup? It should work, though may need a couple other steps first.

What's the corruption-related errors? Might be an option that doesn't involve recreating the...

The Max server memory setting takes...

At least he's not imagining us wandering...

jasona.work (2/7/2014)

---

Is it in any way, shape, or form, possible to have a functional SQL database, with its log file in an offline state. Could you somehow read /...

Koen Verbeeck (2/7/2014)

---

GilaMonster (2/7/2014)

---

Koen Verbeeck (2/7/2014)

---

Ed Wagner (2/7/2014)

---

That's one thing I really enjoy about SSC. The people here aren't paid to answer questions. We do it because we...

Koen Verbeeck (2/7/2014)

---

Ed Wagner (2/7/2014)

---

That's one thing I really enjoy about SSC. The people here aren't paid to answer questions. We do it because we enjoy doing it,...

SQL will use as much memory as it is allowed to. By setting max server memory to 8GB, you've told it that it may use 8GB and hence it will...

Target and total memory are measured in KB. 8GB = 8*1024 MB = 8*1024*1024 KB = 8 388 608KB. So SQL is using exactly the amount of memory you told it that...

sanku.raghuram (2/6/2014)

---

Thanks sharing the details. I have one more question. I see that I have set the restore job to happen 2 min dalay.

so when my job runs first it...

Depends on the execution plan. The rule that functions cannot have side...