Backups

• Topics

  Started by

  Posts

  Last post

• script to set all user database to simple recovery model

  get me a script to set all user database to simple recovery model i tried the below......... it is …

  ravishankar.yedoti

  13 replies

  6 years, 6 months ago

  By: Jeff Moden

• Problem with Sqlservr.exe -m

  Hi, Windows 2003, Sql Server 2005 (SP2 3042) Was DRP'ing a server over the weekend and was not able…

  Michael Ludlam

  4 replies

  6 years, 8 months ago

  By: Jeff Moden

• Issues while backing up to the network

  I am having some issues dealing with some of the back jobs that run on a SQL Server 2005 machine. W…

  Vinu verma

  7 replies

  6 years, 9 months ago

  By: wilks

• Backup failuer with error 3132.

  has anyone come across this error and any solution : Msg 3132, Level 16, State 1, Line 1 The media …

  shotman

  8 replies

  6 years, 9 months ago

  By: v.hashemzadeh

• Taking backup with option "Disk = nul"

  hi , can anybody tell me what exactly below backup query does ? and where it keep the backup file a…

  Bhuvnesh

  19 replies

  6 years, 9 months ago

  By: Jeff Moden

• Restore with different name on same server

  Hello All... I have a database XYZ (Full Recovery Model,300 users in it size aroung 134800 MB,) on …

  nari.koud

  13 replies

  6 years, 9 months ago

  By: Sue_H

• Howto: Backup from remote server and store file on local drive?

  Hi everyone, I have granted to access and backup database of remote server on local network(LAN). …

  sol.nt

  9 replies

  7 years ago

  By: mail4nck 51599

• restore to multiple datafiles

  Background: SQL 2005, old database has 1 filegroup (Primary) and .mdf and .ldf on same drive. New …

  Grumpy DBA

  4 replies

  7 years, 1 month ago

  By: Gail Shaw

• How to RoboCopy backup files between servers

  Hi, Can anyone explain the process of How to RoboCopy backup files between servers. In my case i wa…

  ALIF-662928

  4 replies

  7 years, 2 months ago

  By: garrybrownn96

• copy only restore...

  Hi i have heard that we cant restore copy only back up.because it does not make change in LSN.but w…

  anshu84onnet

  13 replies

  7 years, 3 months ago

  By: goodmirek

• Problem trying to backup Sharepoint_AdminContent

  I have a backup script to backup all our databases but it is failing on this one: SharePoint_AdminC…

  dso808

  5 replies

  7 years, 3 months ago

  By: varunchopra.apj

• Agent jobs fail on "sa" account

  I have a couple of SQL Server Agent jobs configured to run as "sa"However, they fail with the error…

  hemantkchitale

  1 replies

  7 years, 3 months ago

  By: HappyGeek

• Lost the Backup History after new full backup

  Dear All,I created backup by Maintenance Plan there are1. Full Backup for once a week2. Daily Diffe…

  Keetawat C.

  8 replies

  7 years, 7 months ago

  By: Sue_H

• Naming Backup when saving to Disk with loop

  Dear all expert, kindly please help on this syntax, I tried to make database name at filed descript…

  Deny Christian

  2 replies

  7 years, 10 months ago

  By: x

• backup all databases in SQL 2008

  Hi, Need a script to compress and backup all the databases in sql 2008, except system databases. Pl…

  espanolanthony

  7 replies

  7 years, 10 months ago

  By: mohammed.khallaf