Backups

• Topics

  Started by

  Posts

  Last post

• Backup Log cannot be performed because there is no current database backup

  I have a job that runs every two hours starting at 7 AM and ending at 5 to back up my transaction l…

  mqbk

  23 replies

  8 years, 7 months ago

  By: opeagboola

• Restore wait for ASYNC_IO_COMPLETE unending

  I'm trying to restore a 66 Gb database from a single backup file.  The restore is lasting over…

  Paul Fredricks

  10 replies

  8 years, 8 months ago

  By: Jeff Moden

• Backups and memory question

  All, We are running SQL Server 2000 Enterprise on a Server 2003 32 bit VM. Our backups are done thr…

  as_1234

  2 replies

  8 years, 8 months ago

  By: as_1234

• Determine Physical Device Name for a backupset.

  I am running the folowing query: SELECT TOP 1 M.physical_device_name FROM msdb..backupset S JOIN ms…

  Jamie Johnson-406551

  8 replies

  8 years, 9 months ago

  By: sakhamie 11960

• SQL backup best practices

  For taking db/tran log backups which one to be used as a best practice: 1. Using database maintenan…

  Mh-397891

  21 replies

  9 years ago

  By: Wayne West

• Multiple ndf file back up solution please

  Good morning I have a databases at 1.15TB but the Log file is 184GB. So i need space for 966GB 1MDF…

  seanthomas2010

  4 replies

  9 years ago

  By: seanthomas2010

• REFRESH PRODUCTION DB to DEVELOPMESQNT

  HI Friends; I have a database in production which needs to be backedup and restored on Development …

  goofy2sql

  4 replies

  9 years ago

  By: Steve Jones - SSC Editor

• Error msg: Could not continue scan with NOLOCK due to data movement.

  Hi, i keep getting the error msg; msg 601:Could not continue scan with NOLOCK due to data movement …

  christy.umoren

  9 replies

  9 years, 1 month ago

  By: the_SQL

• Can't access data from database restored from backup if not sysadmin

  Hi everybody! I need some help please: - I'm creating a .bak file from a remote sql server 2005 exp…

  dambuster

  7 replies

  9 years, 3 months ago

  By: czurawski

• pb backap

  i have this pb when i tray to do a backup for may database Échec de Sauvegarde pour Serveur « SER…

  h_mouzali

  2 replies

  9 years, 7 months ago

  By: h_mouzali

• Mask the data during restore

  How can we mask the sensitive data when I am restoring the production backup to DEV database for ex…

  nuth

  3 replies

  9 years, 9 months ago

  By: tswiat

• [SQLSTATE 42000](Error 3013)

  I need some help here. I have backups that run each night to tape. The last 2 nights the jobs have …

  tygun

  3 replies

  9 years, 11 months ago

  By: SQL_Hunt

• Unable To See (Select) Days Option In Setting Up Maintenance Plan

  I'm working on a SQL 2000 system (8.00.2056 with SP4 / Desktop Engine) and trying to set up a maint…

  Roger Abram

  4 replies

  9 years, 11 months ago

  By: Errol

• DPM vs SSMS maintenance plans

  We are in the process of completely moving our SQL Server 2008 R2 active/active cluster (6 instance…

  rummings

  1 replies

  10 years, 1 month ago

  By: AlexSQLForums

• NetBackup vs sql backups

  I know no one answered my last post yet, but I have another question...What are the pros and cons o…

  sindhigrl

  15 replies

  10 years, 1 month ago

  By: Wayne West