Nope,...

Grant Fritchey (12/29/2010)

---

If you can get a tail log backup, a backup of the log since the last log backup, yes, you can still do a point in time recovery....

Always the same with those British people 😉

On-topic: such a check normally requires regular expressions, unless your checking for example companies e-mailadresses,...

What is the protection level of your package?

Does the account that SQL Server Agent runs under has the necessary rights to access the folder where your checkpoint file is stored?

Did you set the ResultSet of the Execute SQL Task to XML?

This blog post could be useful:

http://consultingblogs.emc.com/jamiethomson/archive/2006/07/11/SSIS_3A00_-Output-a-file-as-a-csv-or-an-XML-file.aspx

Especially read the comments.

What is your edition of SQL Server and what service packs are installed?

According to official documentation, you need at least SP2 for SQL Server 2005 to create maintenance plans without...

MTY-1082557 (12/29/2010)

---

I do understand it. it sounds good. But that means that I need to re-create the entire shceme structure that I already have. The reason I did a monthly...

OK, I just realized I asked a stupid question 🙂

If you have a full back-up at midnight you obviously can't restore to a point-in-time after midnight without transaction logs.

What I...

Grant Fritchey (12/29/2010)

---

Hi Ankur,

Yes a full backup every night means that you should be able to recover up to the last full backup. And, yes, you're right, without log backups...

Jack Corbett (12/29/2010)

---

Hey, did you know that SSC is now a dating site? Here's a PM I got from lord.god90:

Hello My New Friend.

Good Day and How are you today.

Please...

Roy Ernest (12/29/2010)

---

Today is my last working day for this year. There fore I want to wish everyone a very happy and prosperous new year, 2011.

On another note, I have...

Why two seperate conditional splits when you can use one conditional...

I wouldn't create partitions for every month so far. I would for example do the following (of course it depends on how your users use the data):

partitions for the last...

Nice, easy question. And thanks to Hugo for the extra, thorough explanation.