What are the challenges you face when working across database platforms? Take the survey
Options

SQL Backup Extended Stored Proc Is Truncating database name

ryanchazryanchaz Posts: 5
edited January 29, 2011 6:11PM in SQL Backup Previous Versions
Trying to backup one of our Sharepoint TLOGS, and it's a goofy system-generated name, which can't be changed. When I call the sqlbackup xp with this set of parameters, it returns the following results, clearly showing that it doesn't know how to deal with this name:

Parameters:
-SQL "BACKUP LOG SharePoint_AdminContent_ee6e586c-90de-45f0-9e3d-20bf30104edf TO DISK = 'D:\MSSQL.1\MSSQL\Backup\<AUTO>.sqb' WITH COMPRESSION = 3, ERASEFILES = 4, VERIFY"

Result:
Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'SharePoint_AdminContent_ee6e586c'. No entry found with that name. Make sure that the name is entered correctly.

The database DOES exist in the sysdatabases, but under the full database name.

Is there a way to deal with this, or a workaround?

Many thanks in advance for any input.

Chuck

Comments

Sign In or Register to comment.