Thanks for you reply.

I tried below but it only show sa and he's login but not all logins in SQL Server.

create procedure uspLogins

as

select name

from sys.syslogins

order by name asc

go

any thoughts...

exec(@sql) but getting syntax error

Thanks Alan. Just tried with exec (sql) but it’s giving some syntax error.

Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'TO'.

Msg 156, Level 15, State 1,...

Thanks Alan. Getting lose. When I ran the above script, it displays this TSQL in output but doesn't backup these database.

BACKUP DATABASE Test1

TO DISK = 'C:\temp\20130319_1.bak',

TO DISK =...

Perry,

Currently we don’t have multiple devices or any third party tools to backup the large databases. I read in article if we strip the backup files to multiple .bak files,...

Alan,

Sorry for the late response. I tested the script and it works great. But I want to split the backup files to multiple files if the database size is >...