• Database backup truncate transaction log in SQL Server

    Quick for all you experts out there: Would a full database backup truncate the transaction log (using full recovery mode) in SQL Server 2008? Thanks so much!

    ITKE357,245 pointsBadges:
  • What is the Best SQL RAID configuration and setup?

    We have a new HP Server, ML350 Gen 9, Intel Xeon 6C-E5 2620 v2, 32GB DDR3, 4TB (4x900GB 10k SAS, 1x300GB 10k SAS) OS is windows server 2012 64bit and MS-SQL 2014 Standard Edition. This will be used for our Hospital Information System, our users is around 40 and the daily transaction is from medium...

    arnelmangampo5 pointsBadges:
  • Restore data to different database in SQL Server

    Last week, we did a backup of our SQL Server database. This backup is usually done weekly in our scheduler and we always get a .bak file. But we need to make some changes to the data so I need to restore it to another database. Is there a way to restore to the second database? Thank you.

    ITKE357,245 pointsBadges:
  • SQL Server database is stuck in restoring state

    We have just backed up our database (see below). BACKUP DATABASE MyDatabase TO DISK = 'MyDatabase.bak' WITH INIT --overwrite existing And then we tried to restore it. RESTORE DATABASE MyDatabase FROM DISK = 'MyDatabase.bak' WITH REPLACE --force restore over specified database But it keeps getting...

    ITKE357,245 pointsBadges:
  • Storing the encryption/decryption key for SQL Server in a safe location

    I've got a DB in which i need to store the encrypted values for a column. I use the SQL Server encryption format for encryption. The format is as follows: CREATE MASTER KEY ENCRYPTION BY PASSWORD 'dsagfdsagv418515adsf' CREATE CERTIFICATE 'CERTIFICATE_NAME' CREATE SYMMETRIC KEY 'KEY_NAME' WITH...

    conqueredplanet5 pointsBadges:
  • Exclude indexes from backups in SQL Server 2008

    Over the past few weeks, our night backups are becoming quite large because of the # of indexes in them. We've been using a simple recovery model for the backups. Would there be a way to exclude the indexes from the backups? Thanks so much!

    ITKE357,245 pointsBadges:
  • SQL Script for monitoring backup progress of database

    I noticed that whenever I do a backup of a database using SQL Server Management Studio, I usually get this image of how the process is going / how much longer it will take. But if I do the backup with a script, is there some way I can monitor the whole process?

    ITKE357,245 pointsBadges:
  • Backup schema in SQL Server 2005

    Would there be a way to backup just the schema in a SQL Server 2005 database? I don't need records, just the structure. Thank you!

    ITKE357,245 pointsBadges:
  • Create .SQL file for SQL Server backup

    In my SQL Server, I keep getting a .bak file when I'm backing it up. Is there a way to create it as a .SQL file?

    ITKE357,245 pointsBadges:
  • How to automate SQL Server database backup

    I've been generating SQL Scripts on a daily basis so we can have a backup our SQL Azure database. But we're working to do this on an automated level. Is there a way to do this?

    ITKE357,245 pointsBadges:
  • Query when last transaction log backup happened in SQL Server 2008

    I'm trying to query when the last transaction log backup happened in SQL Server 2008. Does anyone know how to do that? Thanks!

    ITKE357,245 pointsBadges:
  • 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...

    durganippy265 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?

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

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

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

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

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

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

    ITKE357,245 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