Post reply

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

  • April 11, 2013 at 10:23 am

    #270958

    HI All,

    Please provide me a script which takes a back up of all user databases in sql 2008 except for few that the db name end with SPoint. Can you please help me out?

  • April 11, 2013 at 10:34 am

    #1605689

    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';

  • April 11, 2013 at 8:13 pm

    #1605821

    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.

    http://ola.hallengren.com/sql-server-backup.html

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

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