Please help=SQL 2008 backup script on all the user databases excluding the databases end with SPoint

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Start with this and show us what you would do:

select name as DatabaseName from sys.databases where database_id > 4 and name not like '%SPoint';

matak SSCrazy Points: 2674 More actions · Answer 2

Instead of creating it yourself why dont you use one of the many that are currently out there ?

I use the scripts from Ola and they work brilliantly for me.