• Reducing SQL Server backup and restore time

    Our database is big (about 320 GB) and it takes some time to backup and restore. The client wants us to suggest techniques that would reduce the time. I have tried "piecemeal" restoring, which allows you to backup and restore individual filegroups in the database. It works fine with all the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Database User

    Hello, I have 3 servers running sql server 2005 server1, server2, and server3 with database1 and database2 respectively. I backup database1 on server1 and backup database2 on server2 then I restore database1 and database2 on server3 as read-only on a daily basis. I only want to use one sql...

    Rick Martinez585 pointsBadges:
  • Applying snapshot on Subscriber – SQL SERVER 2005

    hi, i've read on this articlehttp://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1362610_mem1,00.html about applying snaphot on the subscriber by copying the snapshot on the distributor and sending it to the subscriber. i didnt get what/how this part.  When the snapshot is created and the...

    Raptur3d5 pointsBadges:
  • SQL Server Transaction Logs

    If I change the recovery model on the primary database from full to simple and then change the primary database back to full again. Would that break the log chain? It seems the log shipping breaks after we do that.

    Rick Martinez585 pointsBadges:
  • sql server 2000 how can i make backup 4 file only and restore

    how can i make backup 4 file only and restore

    01058478505 pointsBadges:
  • MS SQL SERVER (BKUPEXEC) Services wont start

    Hi ALL, Background: Windows 2003 Server returned the error missing or corrupted file after the server was found OFF due to possible power problems (Server is on a UPS). Ran a CHKDSK on the server and it fixed the missing or corrupted file problem and server now up and running. Is seems that my SQL...

    Ahmyown30 pointsBadges:
  • Backup failing

    Hi Mrdenny, I have as GIG. I have a Database Full Backup Maintenance Plan that fails to execute, and I get the same error as GIG's. I checked my disk and I think there is enough free space available (471GB). What could be causing the full backup to fail? Please help! Thanks in advance.

    Proud2bBrown15 pointsBadges:
  • Database maintenance task (full back up) fails on SQL Server

    Hi My daily maintenance job fails due to the below error from last 20 days regularly Executing the query "BACKUP DATABASE [shipment] TO DISK = N'D:\backup\shipment.bak' WITH NOFORMAT, NOINIT, NAME = N'shipment', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "Write on...

    GIG240 pointsBadges:
  • Mirroring from a production environment to a DR environment

    I have a production environment and a disaster recovery environment and each of them have two SQL 2005 servers in a cluster. We have two LANs -- the first one is our standard/everything LAN and the second is a Service LAN. We are looking to mirror from our production environment to our DR...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error backing up with SAP transaction DB13

    The following error message occurs when I attempt to backup with SAP transaction DB13: ***************************** SQL Job information ****************************** Jobname: SAP CCMS Full DB Backup of master,RPD [20090620094326-6-094326] Type: TSQL DB-Name: RPD For Run: 20090620 09:43:26...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Backing up SQL Server 2008 databases to a tape drive

    I am running Sql Server 2008 and I need to know how to make backups of the database onto a tape drive. How do I do this?

    Phrathepmali30 pointsBadges:
  • SQL Backup File

    I have two computers running sql server, sqlserver01 and sqlserver01. On sqlserver01 I backup the database locally to C:\SQLBackup\backupfile.bak (db size: 150GB) then I copy and paste the *.bak file to sqlserver02 via the network. It finishes copying but when I try to restore it on sqlserver02 it...

    0 pointsBadges:
  • Transaction Log – SQL Server 2005

    How do i find out what transaction log file was last applied to a database?

    0 pointsBadges:
  • SQL Server backup would not terminate

    I tried to stop the backup which was already fired through job schedule,but it did't stop. Then I stop the sql serveragent but it also not abled to stop the backup. The backup size was 100GB. Could you please give me the reason and solution of it.

    Axis5 pointsBadges:
  • Backing up virtual SQL servers

    The following question was recently submitted by a user via e-mail: I’m using ArcServe to back up our virtual machines, and I’m wondering what other tools people are using to back up their virtual SQL servers?

    ITKE346,360 pointsBadges:
  • How to restore SQL Server 2000 backup file

    how to restore sql 2000 backup file

    Nareshaswal5 pointsBadges:
  • Taking a backup of a running site on a SQL Server

    How can you take a backup of a running site on a SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server data purging

    I hv a trans tbl and want to keep the records to be purged on Tape/Media and read the data from there whenever required? I want to know, Is that possible to read data from the tape ? if so, then how to do it, neee help

    Taheer725 pointsBadges:
  • SQL Server 2005 SP2 backup failing

    This is my first post and thanks in advance for any replies. I have a backup that failed midway (about 120G of 230G) into the backup twice in the last 2 weeks. Each time, the first error that gets reported in the Application log has been, "BackupMedium::ReportIoError: write failure on backup device...

    Ajf10 pointsBadges:
  • SQL Server 2008 Export data problem

    Hi I'm trying to get used to sql server 2008 having been forced to upgrade by my isp. I need to back up my key db on a weekly remote schedule, so have been trying to use ssms to export data from my remote db to a local copy. Firstly I created a new empty db on the local machine. Then I scripted the...

    Tsp196520 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following