SQL Server 2008 and Backup Exec 2010


Recommended Posts

Ive installed SQL Server 2008 R2 DataCenter Edition and im trying to use the default instance for Backup Exec 2010 by Symantic however when i reach the choose sql server section im told to add logon permission to my-domain.com\Administrator (should have access already).

in SQL Server Management Studio the default login name is the netbios name of the server and attempting to create my-domain.com\Administrator gives Windows NT user or group not found.

Has anyone expierenced the same problem or know a solution ?

Link to comment
https://www.neowin.net/forum/topic/973476-sql-server-2008-and-backup-exec-2010/
Share on other sites

If you could setup with a teamviewer session I could take a look. It sounds like something is not configured properly on the backup server end (proper username and password combo).

Click the join a session link, not the download full. Full install will not work on windows server without licensing.

I use a script:

USE MASTER;

DECLARE @BackupLocation     VARCHAR(max)
DECLARE @BackupFileName     VARCHAR(max)
DECLARE @DatabaseName       VARCHAR(max)
DECLARE @FullBackupLocation VARCHAR(max)
DECLARE @BackupName         VARCHAR(MAX)

DECLARE @DayNumber VARCHAR(max)

SET @DatabaseName = 'DBName'

SET @BackupLocation = 'D:\BackupLocation\'

IF DATEPART(DD, GETDATE()) < 10
	SET @DayNumber = '0' + CAST(DATEPART(DD, GETDATE()) AS VARCHAR)
ELSE
	SET @DayNumber = CAST(DATEPART(DD, GETDATE()) AS VARCHAR)


SET @BackupFileName = @DatabaseName + '_' + 
	CAST(DATEPART(yyyy, GETDATE()) as VARCHAR) + 
	CAST(DATEPART(MM, GETDATE()) AS VARCHAR) +
	@DayNumber
	+ '_' +
	CAST(DATEPART(HH, GETDATE()) AS VARCHAR)
	+
	CAST(DATEPART(MINUTE, GETDATE()) AS VARCHAR)
	+
	CAST(DATEPART(SECOND, GETDATE()) AS VARCHAR)
	+'.BAK'

SET @BackupName = 'Full Backup of ' + @DatabaseName
SET @FullBackupLocation = @BackupLocation + '\\' + @BackupFileName

PRINT 'BackupFileName: ' + @BackupFileName
PRINT 'BackupName: ' + @BackupName
PRINT 'BackupLocation: ' + @BackupLocation
PRINT 'FullBackupLocation: ' + @FullBackupLocation

BACKUP DATABASE [BEDB] TO 
	DISK = @FullBackupLocation
    WITH FORMAT, COMPRESSION, NAME = @BackupName
GO

Change:

SET @DatabaseName = 'DBName'

SET @BackupLocation = 'D:\BackupLocation\'

Use SQL Agent to run the job.

GE

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • At some point, hardware becomes obsolete and we cant blame vendors for dropping support. Much of the models dropped, run Intel hardware which means they can install something else on the device if they truly want to keep using it.
    • Well, that was fun: PS C:\WINDOWS\system32> Install-Script -Name Set-InetpubFolderAcl WARNING: Unable to download from URI 'https://go.microsoft.com/fwlin...627338&clcid=0x409' to ''. WARNING: Unable to download the list of available providers. Check your internet connection. PackageManagement\Install-PackageProvider : No match was found for the specified search criteria for the provider 'NuGet'. The package provider requires 'PackageManagement' and 'Provider' tags. Please check if the specified package has the tags. At C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\1.0.0.1\PSModule.psm1:7468 char:21 + ... $null = PackageManagement\Install-PackageProvider -Name $script:N ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidArgument: (Microsoft.Power...PackageProvider:InstallPackageProvider) [Install-PackageProvider], Exception + FullyQualifiedErrorId : NoMatchFoundForProvider,Microsoft.PowerShell.PackageManagement.Cmdlets.InstallPackageProvider PackageManagement\Import-PackageProvider : No match was found for the specified search criteria and provider name 'NuGet'. Try 'Get-PackageProvider -ListAvailable' to see if the provider exists on the system. At C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\1.0.0.1\PSModule.psm1:7474 char:21 + ... $null = PackageManagement\Import-PackageProvider -Name $script:Nu ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidData: (NuGet:String) [Import-PackageProvider], Exception + FullyQualifiedErrorId : NoMatchFoundForCriteria,Microsoft.PowerShell.PackageManagement.Cmdlets.ImportPackageProvider WARNING: Unable to download from URI 'https://go.microsoft.com/fwlin...627338&clcid=0x409' to ''. WARNING: Unable to download the list of available providers. Check your internet connection. PackageManagement\Get-PackageProvider : Unable to find package provider 'NuGet'. It may not be imported yet. Try 'Get-PackageProvider -ListAvailable'. At C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\1.0.0.1\PSModule.psm1:7478 char:30 + ... tProvider = PackageManagement\Get-PackageProvider -Name $script:NuGet ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Microsoft.Power...PackageProvider:GetPackageProvider) [Get-PackageProvider], Exceptio n + FullyQualifiedErrorId : UnknownProviderFromActivatedList,Microsoft.PowerShell.PackageManagement.Cmdlets.GetPackageProvider Install-Script : NuGet provider is required to interact with NuGet-based repositories. Please ensure that '2.8.5.201' or newer version of NuGet provider is installed. At line:1 char:1 + Install-Script -Name Set-InetpubFolderAcl + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: ( [Install-Script], InvalidOperationException + FullyQualifiedErrorId : CouldNotInstallNuGetProvider,Install-Script
    • Because Apple has never discontinued Mac models before now?
    • I recall reading that they intend to synchronize the version numbers between iOS, tvOS and macOS, so we will also be getting macOS 26 up next.
    • every time.... why can't I install windows 11 on my 8088?
  • Recent Achievements

    • Week One Done
      abortretryfail earned a badge
      Week One Done
    • First Post
      Mr bot earned a badge
      First Post
    • First Post
      Bkl211 earned a badge
      First Post
    • One Year In
      Mido gaber earned a badge
      One Year In
    • One Year In
      Vladimir Migunov earned a badge
      One Year In
  • Popular Contributors

    1. 1
      +primortal
      490
    2. 2
      +FloatingFatMan
      258
    3. 3
      snowy owl
      249
    4. 4
      ATLien_0
      223
    5. 5
      +Edouard
      190
  • Tell a friend

    Love Neowin? Tell a friend!