Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Maintance plan -- full backup error Expand / Collapse
Author
Message
Posted Wednesday, December 25, 2013 2:48 AM This worked for the OP Answer marked as solution
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 3:54 AM
Points: 17, Visits: 58
Yes I have done that.
Post #1525876
Posted Wednesday, December 25, 2013 2:52 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 3:54 AM
Points: 17, Visits: 58
Declare @path Varchar(200)

set @path='xxxx'+ CONVERT(VARCHAR(10),GETDATE(),110)+'.bak'
BACKUP DATABASE [xxxx]
TO DISK = @path
Post #1525877
Posted Wednesday, December 25, 2013 5:21 AM This worked for the OP Answer marked as solution


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, December 23, 2014 6:08 AM
Points: 2,482, Visits: 3,028
sita.yeleswarapu (12/25/2013)
Declare @path Varchar(200)

set @path='xxxx'+ CONVERT(VARCHAR(10),GETDATE(),110)+'.bak'
BACKUP DATABASE [xxxx]
TO DISK = @path


So, what is your question or problem?
The code above does work well even with a space in the path. The only thing to keep in mind is to add a backslash at the end of the path. Because you entered a dummy value in your post I'm not sure you have done that.


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1525883
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse