jorge.torralba (3/17/2010)

---

Wasn't an app. It was a developer dba running a script that dropped the tables. Thought I could go back in time to a point without having tio restore...

Glad we could help.

Please answer the other questions so we know what you've checked and what you haven't checked. Otherwise, we can't help you further.

Your post is a little hard to read, so forgive me if I don't quite understand the problem.

Is it just Maint. Plans that are taking forever or is it all...

parthi-1705 (3/17/2010)

---

I am having a 30 million records i need to delete 25 million old records with minimum log how it can be done there will be continues users accessing...

That's actually a pretty good idea. The only thing to keep in mind, though, is that it will potentially stripe the data across the files or shove them all in...

You do realize you can get better performance out of your DB if these LUNS really are separate drives (physically speaking) and you apportion out your tables properly, right? This...

Check Books Online for the system tables. In the Index, type in "sys" (without the quotes) and it will take you right to them. BOL gives you the table names,...

Also, if the folder destination does not exist, xp_cmdshell will NOT create it as part of the copy, unlike several other windows programs which will.

Usually when I get this error, another backup is actually running at the time. But it's only happened to me maybe two times, so "usually" might not mean anything.

You can definitely add more files to the Primary Filegroup without a problem. The issue is moving the data from the existing file to the new file.

The best way to...

starterm (3/17/2010)

---

I have backup of the database but it was taken before 3 months. Now if restore the file from backup to make it online, the updated values in the...

suresh.maddali (11/12/2009)

---

Hi All,

I have .mdf, .log files all those files are online, I conform with the following querry

select fg.name as FilegroupName, fg.type_desc as FileGroupType, df.name as...

I should add that the use of Partial Backups or File / Filegroup Backups (if you do use them) can be used to restore your tables if you happen to...

Point in Time restores (which is what you're referring to) cannot be done without starting from the last FULL backup. You can't re-apply Transaction Logs (or roll them back) to...