Forum Replies Created

Viewing 7 posts - 31 through 38 (of 38 total)

  • RE: database backup scheduled task not working

    That gives us what the problem is though. You are using LocalDB and that uses different connection strings. That is what the issue is. You don't use the Localdb#xxxx reference....

  • RE: database backup scheduled task not working

    I'm attaching a screen shot of the results on this query.

    The instance appears to be ACMCAL-LT160\LOCALDB#F1BD7ACE.

    I put that into the backup command like so:

    sqlcmd -S ACMCAL-LT160\LOCALDB#F1BD7ACE -E -Q "EXEC sp_BackupDatabases...

  • RE: database backup scheduled task not working

    EXEC master.dbo.sp_BackupDatabases @backupLocation='C:\SQLBackups\', @databaseName='RiskAliveDev', @backupType='F'

    That works in SQL Server Management Studio (I right click on the database connection containing master.dbo.sp_BackupDatabases and also RiskAliveDev and say 'New Query' and paste that...

  • RE: database backup scheduled task not working

    Unfortunately, that doesn't work either. It still tells me that it can't find the stored procedure.

  • RE: database backup scheduled task not working

    I've attached two screen shots, one showing the services running on my machine (highlighting SQL Server (SQLExpress) and the other showing the version of SQL Server from the About menu...

  • RE: database backup scheduled task not working

    Ok, here's my new string:

    sqlcmd -U [domain]\[username] -P [password] -S (localdb)\ProjectsV12 -Q "EXEC master.dbo.sp_BackupDatabases @backupLocation='C:\SQLBackups\', @databaseName='RiskAliveDev', @backupType='F'"

    A few things that are different:

    * Using my Windows credentials.

    * Connecting to (localdb)\ProjectsV12 instead...

  • RE: database backup scheduled task not working

    I'm using the user I'm logged in as.

    In SQL Server Management Studio, I log in using Windows Authentication and that seems to work to allow me to see the sp_BackupDatabases....

Viewing 7 posts - 31 through 38 (of 38 total)