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

    • I happen to try it today not knowing about the update and was happily surprised; it is great.
    • Hello, Hardware Support Applications are a special kind of Microsoft Store app and have to go through additional checks and certifications because they can communicate directly with their driver, which means that a vulnerability in one of them could allow an attacker access to kernel space memory through the HSA ←→ device driver interface.  In other words, a BYOVD (bring your won vulnerable driver) attack, but with the HSA being used as an extra step. Remember, the Microsoft Store is strategic to Microsoft's long-term goals: they see it as the means to get the same 30% of every application sale that Apple and Google get through their stores, which is why it has been a fixture of Windows since Windows 8 was introduced in 2012 despite a low adoption rate.  Microsoft cannot afford to have anyone get an app through their store which causes a security issue for their end users.  Even if the app was written by and uploaded to the Microsoft Store by a partner, it is Microsoft's name on the store, and they are the ones that will have reputational/brand damage if they allow something malicious into their store. Regards, Aryeh Goretsky  
    • This is more from my childhood, when nickelodeon just launched and had to license shows to have something to air. Left a big an impact, but probably more emotion positive / childhood thing. Europe got the follow up season's decade's latter with the animation studio that did Air Bender but never licenses for the US. I miss the day's of longer intro's. Nier (PS3) Intro is epic, and was very unexpected.  PS1 Xengears was also epic and an amazing game.  
    • Sayan Sen, do you think one day an image of the Windows Vista desktop or the wallpaper could be used in the primary image of an article? (When I think of CDs and DVDs I think of that release of Windows and of earlier releases; it is the one that debuted IMAPI 2.0 and other features.)
    • Big fan of EAC Here's a good non-default naming scheme I found on the web (can't take credit) File Name Scheme - %albumartist%\%year% - %albumtitle%\%tracknr2% %title% Various Artists Naming Scheme - Various Artists\%year% - %albumtitle%\%tracknr2% %title% Also, I need test but there is a new flac.exe binary & dll you can drop in the folder to upgrade flac support. I did this pre EAC 1.8. EAC 1.8 did upgrade it to 1.4.3. Flac 1.5.0 came out this year. https://ftp.osuosl.org/pub/xiph/releases/flac/ I don't know how much of a difference / impact will make.
  • Recent Achievements

    • Week One Done
      Ricky Chan earned a badge
      Week One Done
    • Week One Done
      maimutza earned a badge
      Week One Done
    • 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
  • Popular Contributors

    1. 1
      +primortal
      484
    2. 2
      +FloatingFatMan
      263
    3. 3
      snowy owl
      240
    4. 4
      ATLien_0
      227
    5. 5
      Edouard
      188
  • Tell a friend

    Love Neowin? Tell a friend!