Viewing 7 posts - 31 through 38 (of 38 total)
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....
September 13, 2016 at 3:13 pm
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...
September 13, 2016 at 12:46 pm
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...
September 13, 2016 at 8:55 am
Unfortunately, that doesn't work either. It still tells me that it can't find the stored procedure.
September 12, 2016 at 8:22 am
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...
September 9, 2016 at 11:55 am
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...
September 9, 2016 at 9:48 am
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....
September 8, 2016 at 10:29 am
Viewing 7 posts - 31 through 38 (of 38 total)