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

    • Microsoft PC Manager 3.17.4.0 (Offline Installer) by Razvan Serea With Microsoft PC Manager, users can easily perform basic computer maintenance and enhance the speed of their devices with just one click. This app offers a range of features, including disk cleanup, startup app management, virus scanning, Windows Update checks, process monitoring, and storage management. Microsoft PC Manager key features: Storage Manager- easily uninstall infrequently used apps, manage large files, perform a cleanup, and set up Storage Sense to automatically clear temporary files. Health Checkup feature -scans for potential problems, viruses, and startup programs to turn off. It helps you identify unnecessary items to remove, optimizing your system's performance. Pop-up Management - block pop-up windows from appearing in apps. Windows Update - scans your system for any pending updates. Startup Apps - enable or disable startup apps on your PC, allowing you to optimize your system's startup performance. Browser Protection - rest assured that harmful programs cannot alter your default browser. Also enables you to change your default browser. Process Management - allows you to conveniently terminate any active process, ensuring optimal system performance and resource utilization. Anti-virus protection - Fully integrated with Windows Security. Safeguard your PC anytime. Quick Steps: Download Microsoft PC Manager Offline Installer (APPX/MSIX) with Adguard Adguard serves as a third-party online service, offering a user-friendly method for directly downloading appx, appxbundle, and msixbundle files from the Microsoft Store. Official download links will be generated for both the app's various versions and its dependency packages. How to download Microsoft PC Manager Offline Installer (APPX/MSIX) 1. Initially, you must find the app URL within the Microsoft Store. Access the Microsoft Store via your browser and search for "Microsoft PC Manager". Once located, copy the app URL, which includes the product ID, either from the address bar or from the provided link below. https://apps.microsoft.com/detail/9PM860492SZD 2. Now paste the app URL into the designated area, then click the check mark button to produce a direct download link. 3. To download, right-click the relevant link and select “Save link as…” from your browser's menu. Occasionally, Microsoft Edge may flag the download as insecure. In such cases, consider utilizing alternative browsers such as Google Chrome or Firefox to successfully complete the download. Microsoft PC Manager is a completely free tool optimized exclusively for use on Windows 10 (version 1809 or newer) and Windows 11. Download: Microsoft PC Manager 3.17.4.0 | from Microsoft Store View: Microsoft PC Manager Home Page Get alerted to all of our Software updates on Twitter at @NeowinSoftware
    • You might want to update to 1TB drive.  They are not very expensive these days, there are plenty of options - simple look I would think you could find a 1TB ssd or even nvme somewhere between 50 and 100 bucks. when I have moved to larger ssds in laptop in the past, you can just connect the drive via usb - image.  Then take the old drive out, put in the new drive and there you go..  If your concerned about how much space you have left this prob your best bet..   
    • I see! Wasn’t aware of that. Even though they started off with desktop app for Mac before Windows. Should be on it’s way soon! 🤞
    • support.microsoft.com/en-us/topic/microsoft-defender-update-for-windows-operating-system-installation-images-1c89630b-61ff-00a1-04e2-2d1f3865450d
    • It's a Developer Beta 1 not even a Public or User Beta, I doubt any of the design is 100% finalized yet.
  • Recent Achievements

    • First Post
      Johnny Mrkvička earned a badge
      First Post
    • Week One Done
      viraltui earned a badge
      Week One Done
    • One Month Later
      serfegyed earned a badge
      One Month Later
    • Dedicated
      firey earned a badge
      Dedicated
    • Dedicated
      fettermanj earned a badge
      Dedicated
  • Popular Contributors

    1. 1
      +primortal
      627
    2. 2
      ATLien_0
      224
    3. 3
      Michael Scrip
      217
    4. 4
      Xenon
      149
    5. 5
      Steven P.
      139
  • Tell a friend

    Love Neowin? Tell a friend!