• Link two stored procedures in one Crystal Report

    Hi, In a report called ICD_PrivateHospital, I have designed to show output to two table from two store procedures. 1st store proc: usp_RPT_Private and 2nd store proc: usp_RPT_Private2.I have created both the store procs and it is executing successfully. I also have designed the Crystal Report in...

    durganippy2610 pointsBadges:
  • Daily backup on SQL Server Express

    We're currently running a web application through SQL Server Express as a back end. We're able to create a backup through a script but we need to schedule it on a daily basis. Any way to do this?

    ITKE372,225 pointsBadges:
  • Error when restoring a backup to a local database server

    We've been trying to restore a backup, from a .bak file to a local database server but we keep running into the same error message every single time. Here's what we're getting: An exception occurred while executing a Transact-SQL statement or batch.(Microsoft.SqlServer.ConnectionInfo) Cannot open...

    ITKE372,225 pointsBadges:
  • Statement fails when backing up SQL Server to UNC

    My team is creating a maintenance plan for our SQL Server 2005. Our backup needs to be written to another server so we're using a UNC path. One member of the team (who's running the SQL Agent jobs) has full access to the other server. But we've run into a problem: The statement keeps failing....

    ITKE372,225 pointsBadges:
  • Is there a command line program to backup databases in SQL Server?

    We've been so busy with other projects that we've been putting off backing up our database on our internal servers. Does anyone know if there's a way (or a simple command line program) that we can use to backup certain databases in SQL Server? Maybe a VBScript? Thank you.

    ITKE372,225 pointsBadges:
  • Backup SQL Server database to a local server

    I'm trying to copy a database from our remote server to another server. We tried using SQL Server Management Studio but it keeps backing up to a drive on the remote server. Should we use a third party tool? Or is there another way to copy this database over?

    ITKE372,225 pointsBadges:
  • Deleted the SQL Server 2005 Database

    Hello! Please tell me is it possible to restore the database if someone accidentally deleted it? I have an old backup but I want a new database to reanimate. Really the database completely is removed from a disk?

    Britton5 pointsBadges:
  • Restore single table from SQL Server 2005

    For our SQL Server 2005, I had a backup made for the entire database. But does anyone know of a way to restore just one single table, no the whole thing?

    ITKE372,225 pointsBadges:
  • 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...

    ITKE372,225 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!

    ITKE372,225 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?

    ITKE372,225 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?

    ITKE372,225 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...

    ITKE372,225 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.

    ITKE372,225 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!

    ITKE372,225 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?...

    ITKE372,225 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:...

    ITKE372,225 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?

    ITKE372,225 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:

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.