Gedas (10/8/2010)

---

You can kill rollback only by doing that but you must have latest backup:

1. stop SQL engine

2. delete db and tlog files

3. start SQL engine

4. delete db

5. restore...

Looks to me it has what you need (But I've been wrong before :-P)

frequency is: freq_subday_interval, int

"Number of freq_subday_type periods to occur between each execution of the...

msdb..sysschedules ?

Maybe I missed it, but why haven't you put t-log backups in place as suggested ? If it's a production database, I don't think that pushing for simple recovery...

Coming soon, another thread about restoring a database without a backup.

That's what I was thinking. You can run this script to identify your biggest databases....

We had performance issues after upgrading to 2005. Some of them were resolved after closely looking at the joins and finding we needed to modify or add the CONVERT functions...

There's also a free add-in to SQL2005 sp2 called SQL Performance Dashboard. I just downloaded it the other day onto a test server. I have not really looked at it...

Clkgtrs1 (10/1/2010)

---

Hey Thank you for the help but when I right click the database I don't have the option to import data into my database. I'm running SQL Server Management...

Is there a good reason you are still on SP1 ? It may not apply here, but keeping current on service packs can help avoid problems.

Just a note that xp_sendmail will get dropped at some point, so you could modify the code to use the current mail method of sp_send_dbmail .

Right click your database -> Tasks -> Import Data -> Source: MS Excel -> File Path -> Destination

That gets you to the general area. Then you have a variety...

Is logging enabled in the Maint Plan. If so, what's in the .txt file after it runs ?

Edit: The .txt should list the steps it actually performed.

Robert Hankin (9/27/2010)

---

2005 will give me one big benefit of being able to use mirroring and snapshots to fully offload reporting without an overhead of SQL 2000 DTS packages having...

So maybe it does work ? ... just can't verify it with sp_helprotect ?

Is there a way to see after the fact what was done ?

I'll have to test the...