• 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!

    ITKE357,155 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?...

    ITKE357,155 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:...

    ITKE357,155 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?

    ITKE357,155 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:
  • SQL stored procedure is taking too much time to execute

    One store procedure is working fine at one location. But the same store procedure is taking too much time to execute in different location on same network. What would be reason for this and how to reduce response time?

    mukeshkumar1225 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...

    ITKE357,155 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!

    ITKE357,155 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...

    ITKE357,155 pointsBadges:
  • Users accessing SQL Server 2008 database

    how can i know how many users are accessing database remotely and how much load is on database .how can it be detected in sql server 2008. pls let me know .  

    Tablestructure15 pointsBadges:
  • Tool for migrating DTS to SSIS

    What is the tool for migrating DTS to SSIS. And how effective it works. And I want migrate 500 DTS packages to SSIS. How much time it will take?

    Lingala5 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • Reading a file in Reverse Order in CL Program

    ) In CL program how can we read a data base file in reverse order.

    Chraghuveer25 pointsBadges:
  • SSRS Report Server security not working

    SSRS Report server security group is set up right on folders with all rights. But we are getting an Windows account error that says a specific Windows account lacks rights to create a data source. What could cause this?

    RickNPHX15 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