• Backup error when restoring SQL Server database

    A few days ago, I backed up my database that I created on another machine (which was running SQL Server 2012 Express) and I need to restore it on my machine. However, I keep getting this error when I'm trying to do it: Backup mediaset is not complete. Files: D:\question.bak. Family count:2. Missing...

    ITKE376,205 pointsBadges:
  • How to take a table-level backup in SQL Server 2008

    Does anyone know how to take a table-level backup in SQL Server 2008? Can we use the backup database command? Thank you!

    ITKE376,205 pointsBadges:
  • Where is the backup for SQL Server database located?

    We've been trying to create a backup for SQL Server database using SQL Server Management Studio 2008. We were able to create the backup but it's being saved at some path that we can't find. We saved it on our hard drive but it's not there! What should we do?

    ITKE376,205 pointsBadges:
  • Backup stored procedures in MySQL

    With MySQL, I've been using mysqldump to back it up daily. But how do I store stored procedures? Is it backed up with everything else?

    ITKE376,205 pointsBadges:
  • Cannot open up backup on SQL Server 2008 database

    We have a query that we're using to backup our database. But when we run it, we get this error message: Msg 3201, Level 16, State 1, Line 1 Cannot open backup device 'C:\Users\Kimpoy\Desktop\Backup\AcinsoftDB.Bak'. Operating system error 5(Access is denied.). Msg 3013, Level 16, State 1, Line 1...

    ITKE376,205 pointsBadges:
  • Restore SQL Server 2005 database backup over network

    I apologize that it's old software but we're using SQL Server 2005. Does anyone know if we can restore a database backup using Server 2005 over our entire network? We would appreciate any help.

    ITKE376,205 pointsBadges:
  • Script out SQL Server backup into a batch file

    Would there be a way to script out SQL Server backup into a batch file? We need to execute it from the command line so this seemed like a logical way to do it. Thanks!

    ITKE376,205 pointsBadges:
  • Finding backup application log is located on SQL Server 2008

    In SQL Server 2008, we're trying to find out why our database backup failed in one of our systems. Here's what the log says: BACKUP failed to complete the command BACKUP LOG XXXXXX. Check the backup application log for detailed messages. Would anyone know where this backup application is located?...

    ITKE376,205 pointsBadges:
  • Error when backing up database on SQL Server 2008

    My friend and I are trying to backup a database that's located on localhost/SQL Express but we keep getting this error: Backup failed for Server 'localhost\SqlExpress'. (Microsoft.SqlServer.SmoExtended) For help, click:...

    ITKE376,205 pointsBadges:
  • How to force backup through on SQL Server

    My SQL Server won't restore my backup because there's active connections. Is there a way to force it through?

    ITKE376,205 pointsBadges:
  • How to code a datetimepicker with the datediff control

    I need to code a button's click even so that it will calculate the number of days between a selected date by the user in the datetimepicker and today. I then need to subtract that number from a number entered by the user in a text box. ' declar the date and time variables Dim d1 As DateTimePicker...

    JohnDoe38865 pointsBadges:
  • Combo Box in Form

    I have a form that has a combo box for town ID, another combo box that has parcel ID. I would like to be able to click on town ID pick the town and have only that towns parcel ID's to be present in the parcel ID combo box. Is this possible?

    brendi52835 pointsBadges:
  • What does the SQL Server (Instance) service do?

    I have a SQL Server (Instance) service that wont run and I was wondering what the purpose of it was.

    Davis10375 pointsBadges:
  • Disk format for SQL Server

    Looks like our SAN consultant did not follow the below guidelines for setting up our EMC SAN for SQL Server 2008 R2. I have a production database that is about 1.4 terabytes. There are 3 file groups. I may have to do this piece meal. I was thinking of each Sunday moving one of the filegroups to a...

    tcroninstl5 pointsBadges:
  • Issues deleting records in SQL database

    I'm having issues deleting records in a SQL database. What should I do?

    rockquery45 pointsBadges:
  • How to Repair WSS_Content Database in SQL Server 2008?

    Hi, We have SharePoint foundation 2010 and we were getting error on backup so we did run DBCC CHECKDB and found some error. Looks like I found 0 allocation errors and 55 consistency errors in database 'WSS_Content'. Now I'm not sure what i need to do to repair. How do I repair? Any drawback? How...

    GregoryGood5 pointsBadges:
  • Performing SQL Join equivalent in MongoDB

    Does anyone know of a way to perform a SQL Join equivalent in MongoDB? This is what I have right now: comments { uid:12345, pid:444, comment="blah" } { uid:12345, pid:888, comment="asdf" } { uid:99999, pid:444, comment="qwer" } users { uid:12345, name:"john" } { uid:99999, name:"mia" } And I'm...

    ITKE376,205 pointsBadges:
  • How to export data from R to SQL Server quickly

    Is there a way I can export data from R to SQL Server quickly? The standard way (SQLSave) is really slow for a large amount of data. This is what I tried so far: toSQL = data.frame(...); sqlSave(channel,toSQL,tablename="Table1",rownames=FALSE,colnames=FALSE,safer=FALSE,fast=TRUE); Thank you!

    ITKE376,205 pointsBadges:
  • Best load testing software for VB 6 and SQL Server 2012

    What's the best load testing software for VB 6 and SQL Server 2012?

    Udayarajan5 pointsBadges:
  • Should I move my SQL database to NoSQL?

    I have a very large table (roughly 100 million rows and 35 columns) and it's currently stored in a SQL database. However, my queries are running very slow at the moment so I'm wondering if I should move to NoSQL. But I have a few questions: Which NoSQL database should I use? Is there a way to move...

    ITKE376,205 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.