• 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:
  • 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:
  • DB backup onto External Hardrive

    Hi I have connected an external USB hard drive to my SQL server (2000). When i attempt to backup from Enterprise manager (to the harddrive) i cant seem to find the drive in the list. The drive has been made active (active partition) and can be used from windows explorer without any problems. I...

    KH155 pointsBadges:
  • Restore SQL Server after OS loss

    I have all datafiles and backups but no OS services. What steps would I take to restore the database

    Grabber60 pointsBadges:
  • Full and differential backup size same in SQL Server

    Hi, Sub:Full and differential backup size same. I am facing the following problem on production server,I am getting the full backup(600MB) and differential backup size(598MB).On off peak hours I have taken full backup and just after a min I have taken differential backup but the sizes of both...

    Abdulsamad20 pointsBadges:
  • Recovering lost SQL Server 2000 data

    I lost a LDF file for SQL server 2000 -- but I have the MDF. How can I recover my data?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can I take a backup of a SQL Server stored procedure only?

    How can I take a backup of a SQL Server stored procedure only?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Can I restore a SQL 2000 backup to a new SQL Server 2005?

    Can I restore a SQL 2000 backup to my new SQL Server 2005? Will I have to perform any other steps or can I do a simple backup and restore? Windows 2008 Server.

    TeachMeIT975 pointsBadges:
  • Error Message when restoring a SQL server DB in SQL Server Express 2008 R2

    This error received and cannot determine resolution: System.data.Sqlclient.Sqlerror:Create Database or Alter Database failed because the resulting cumulative database size would exceed your licensed limit of 10240MB per database. The DB.bak file is 1.67MB

    Trackster209515 pointsBadges:
  • Recovering data from crashed database

    i   i have a question. my database  is crash .i don't have present backups.but i'm having  last week backups.  and  backup  strategy sunday   10 p.m  full backup everyday  1 p.m    differential backup every one hour transaction log backup  please give me reply as soon as thanks &...

    Venkatdbait35 pointsBadges:
  • Error when trying to restore SQL Server database backup file

    We have a SQL Server database backup file with the extension .bak. In the new server we created a database with the same name. We are trying to restore the database with the backup file, but we’re unable to do that. When we try to add the backup file, SQL Server raises error that we have no...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Mirroring SQL Server 2008 to a disaster recovery machine twice a day

    I want to mirror my SQL Server 2008 to a disaster recovery machine two times a day. Is there any free software to do this on a running SQL Server? If not, are there any cheap alternatives? Can scripts be run to copy the files over while SQL is running? Can I use shadow copy for this?

    ITKE346,200 pointsBadges:
  • sql server 2008 backup and restore

    can u get me the command to recover the database . my backup is in d:nor.bak . as i m running the command   >restore database 'd:nor.bak' it gives me the message as : Incorrect syntax near 'd:nor.bak'. pls let me know how to reatore . Regards, Rino

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • SQL Server Log Shipping 2005 to 2008

    Does anyone know if i can logship from a sql server 2005 to a sql server 2008?

    Rick Martinez585 pointsBadges:
  • BACKUP in SQL SERVER

    Hello Sir, Can u get me the answer  to this question Management wants the backups to be done daily. Transaction log backups must be every afternoon and morning and that you should keep in mind that the content of the log will get larger and larger. You also need to take measure to do the log...

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • Retrieving data tables without backup SQL

    If I truncate a table without the backup of it, how do I retrieve the table data?

    SQL Server Ask the Experts2,585 pointsBadges:
  • DR/HA questions with SQL Server design

    Greetings! I need your advice for two questions. This is related to design. I have a production site. It requires HA. At the same time we have a DR site. The DR site needs to have the same copy of the database for my application to run. Question 1: Is it advisable to have mirroring on the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • FULL BACKUP taken by SQLExecDirect function works, but backup is not taken why?

    I try to backup SQL server database using ODBC native client apis. One weird error occurs. When I run, SQLExecDirect(stmt, "BACKUP DATABASE dbname TO DISK='C:TESTBK.BAK' WITH FORMAT ", sql_nts ) There are no errors during runtime, and message shows backup taken . But it is not seen innthe specified...

    ITKE346,200 pointsBadges:
  • How to export/ import userschema in SQL server 2005?

    To export userschema in oracle, we can use expdp and impdp commands. Do we have any commands to export/ import userschema in SQL server 2005? Also, How to export all the tables to filesystem? Using SQL management server studio there is an option to export 1 table at a time to a file.      

    Saimadhu455 pointsBadges:
  • Techniques for storing SQL Server data online and for backing up the server

    For a banking application, I would like to keep 10 years worth of data using SQL Server. I would like to keep two years online and backup the other eight years. What are some techniques to do this?  

    SQL Server Ask the Experts2,585 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