1
  • Recovering lost data from SQL Server 2005

    Running SQL Server 2005. I found that I had lost about 2000 records the Assets table and more records in the associated tables Timeassets and AssetBillingrates.  Each of the tables uses an Id field as the Primary Key. I was able to identify the key records that had been lost and tried inserting...

    BClawson10 pointsBadges:
  • Duplicate SQL Server 2005 database

    What is the best way to duplicate a SQL Server 2005 database to another server as a standby machine? Can I do this with another installation and some scripting? I have a separate box with SQL 2005 already installed. Can I backup and restore from one machine to the other using scripts and no human...

    ITKE352,420 pointsBadges:
  • SQL Server 2005 backup

    How to take backup of live site in SQL Server 2005?

    Amin4rmOvexTechnology250 pointsBadges:
  • How to backup a SQL Server database

    Hello, I wonder if you can help. We are just about to start implemetation of SQL 2005 Server. Can anybody, let me know how we go about backing up the database? We have veritas 9.1 but I guess we need to back-up live if possible. What is our best option?

    Garrybreed45 pointsBadges:
  • Incremental backup in SQL server 2005 and SQL Server 2005 express

    Question: a) steps to backup the daily incremental in sql server 2005. b) steps to backup the daily incremental in sql server 2005 express.

    david2009575 pointsBadges:
  • Microsoft Sequel Server 2005 VSS backup

    What's seems to have happened is that the SQLVDI.dll files in the 2 directories: C:\Program Files (x86)\Microsoft SQL Server\80\COM C:\Program Files\Microsoft SQL Server\80\COM are out of sync. This seems to have happened as a result of a service pack for MSSQL which was applied in Dev. The...

    LeonT140 pointsBadges:
  • SQL Server 2005 maintenance plans

    I have several maintenance plans setup in SQL 2005, but if the backup fails I am not alerted in any manner how can I fix this? Will I need to script something or is this a built in feature?

    TeachMeIT975 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:
  • 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:
  • EMC Network Backup Client/Agent backup for SQL 2000/2005 databases on Polyserve Matrix

    Hi, I am new with running SQL 2000/2005 instances on Polyserve Matrix servers. We use EMC Network as a corporate backup strategy. Can someone tell me will there be any problems using this backup tool for SQL instances on the Polyserve Matrix?

    Davidvoo5 pointsBadges:
  • SQL Server database backup (URGENT)

    Hi I have a db backup requirement. As shown in the attached image current system is as follows: There are three source databases such as DB001, DB002 and DB003. Each DB having one table as dbo.EMP and same table schema. Emp table consists of EmpID (PK) and EmpName. One backup database i.e, DBbackup...

    Plugsharma40 pointsBadges:
1

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