So, when you changed the DB name from "school" to "School_Restored" you also must change the MDF and LDF to "School_Restored.mdf" and "School_Restored.ldf". Usually SQL does that for you...

ramazan_erdem (11/22/2008)

---

is there any program about this problem.but it must be full. or you have a karnel sql database reovery program's crack.

i tried your commands but i could not fixed...

http://msdn.microsoft.com/en-us/library/ms191253(SQL.90).aspx

Call them on the...

Lynn Pettis (11/21/2008)

---

Does this help? Because I have no idea what you are trying to ask with this question:

According to this i restore 1st DIFF #3 then DIFF...

Why do you want to merge them into one file ? Many of us split them into multiple files so that we can improve performance by spreading them over...

Michael Earl (11/21/2008)

---

You are correct in that you lose the benefit if the SAN admin is carving three partitions out of a LUN that is using the same physical drive...

I don't understand the question. Are you asking about restoring all the...

Glen Loupias (11/21/2008)

---

Thanks for the replies. My second strategy is the seperation of index and data in two filegroups.

I've read in several forums and books that there is an I/O...

Just keep 1 day of backups on your server, and write to tape every night, so you will have them all on tape. Can you zip your .bak files ?

That's the kind of information I miss from my AS/400 days

Just creating more files won't help. SQL will only use the new files as they are needed. They need to be spread over more drives to get any benefit.

If you...

Amit Gupta (11/19/2008)

---

i solve this problem, but i am confused that if i have 3 diff backup(3 days file) and restore 3rd day restore 1st then 2nd day, then 1st...

Here's my homemade version:

SELECT sysdb.name, bkup.description, bkup.backup_finish_date,

case

when type='D' then '** FULL **'

when type='I' then 'DIFFERENTIAL'

when type='L' then 'LOG'

end as Backup_Type,

(STR(ABS(DATEDIFF(day, GetDate(),(backup_finish_date))))) as 'Days_Ago',

ceiling(bkup.backup_size /1048576)...

I took a bit of a different approach to examine the SPs. I used your idea of sysdepends by using sp_depends in a loop of all the stored procs to...