How to create a file system directory in a SQL Server 2005 call/query

Question

I need to create a directory for sql server backups. I have to dynamically place the backup file in different folders on many different sql server installs. The backup fails if the directory doesn't exist. So if I can create the directory in a stored procedure or some other call before I call the backup command that would be helpful. Any ideas?

Thanks

Tetraneutron · Accepted Answer · 2009-06-11 00:37:10Z

27

Try

declare @Path varchar(100)
set @Path = 'c:\CreatedFromSQL'
EXEC master.dbo.xp_create_subdir @Path

Sourced from http://www.mssqltips.com/tip.asp?tip=1460

answered Jun 11, 2009 at 0:37

Tetraneutron

34k4 gold badges27 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tetraneutron Over a year ago

You mark it as the selected answer by clicking the "Tick" below the Vote counter in my answer.

soulblazer Over a year ago

I tried this very same code, and can't find a "CreatedFromSql" folder anywhere in C:\. What should I do?

Collectives™ on Stack Overflow

How to create a file system directory in a SQL Server 2005 call/query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related