• How to use a SQL Server 2008 database on a NAS

    We've been working on a project using Visual Studio. We need to create a local database file with our project directory so we can check into a SubVersion and have configuration management. But we keep getting an error when trying to create or attach a database on a network share. Just to clarify,...

    ITKE361,720 pointsBadges:
  • Big trouble with importing Excel sheet to SQL Server 2012

    Hi, I have following scenario: Installed SQL Server 2012 on WIN 2012 Server Installed SQL Management Studio Installed Visual Studio 2012 Installed SQL Server Data Tools Installed SQL Server Integration Services Everything is related to Express version. I have a software program running on a SQL...

    dkanthony5 pointsBadges:
  • Count the times that = Smith is present in SSRS

    I want to count how many times a certain word is used is a column on a SSRS report

    Vickis5 pointsBadges:
  • In a single CL Program, can we read a database file more than once?

    In a single CL Program, can we read a database file more than once

    Chraghuveer25 pointsBadges:
  • Is it important to backup the transaction log?

    Over the past few months, we've been putting in a backup solution for a client. Their ERP solution uses SQL Server but ERP was set up by a different company. They have told us multiple times that it's really important to backup everything and truncate the transaction log. Is the log that important?...

    ITKE361,720 pointsBadges:
  • How can I restore a database from .mdf file?

    How can I restore a database from .mdf file? I only have .mdf backup file.

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to restore a SQL Server 2008 database

    Dead database. Looked at backups but the last backup made three weeks ago, then the operation was executed with an error and I didn't notice: - (mdf and ldf aren't copied by the conductor. errors in the file. using Active File Recovery had copied the mdf. then I passed Windows Check Disk. Windows...

    gioacchinolupi15 pointsBadges:
  • Using iSeries as linked server in SQL Server 2012 Express

    I downloaded SQL Server 2012 Express in order to attempt to create a database on a PC which has links to data living on our iSeries. I can't use the OLE DB2 extension from Microsoft since it doesn't work on SQL Server Express. So, I figured out (with Google's help) that I could run this script to...

    Koohiisan5,020 pointsBadges:
  • Should we put local SQL Server files on NAS or SAN?

    We're preparing to install a new server on SQL Server 2008. Here's our question: What would you recommend - one server with RAID 10 or all the files on a NAS? Or should we just use iSCSI? The new server has about 4 GB of RAM and the database file has 2 GB. What's the best option for us?

    ITKE361,720 pointsBadges:
  • Backup and replicate SQL Server database

    We have a SQL Server database that contains our most recent data. We need to replicate the content into several other servers. But for some reason, we can't use the replicate / sync function to sync to other SQL Server instances. What would be the best way to do this? Thank you!

    ITKE361,720 pointsBadges:
  • Best backup option for SQL Server 2008 Express

    What would be the best backup option for us in SQL Server 2008 Express? Our first thought was to do a replication on another computer / take Xcopy backups of the server but it's not available in Express. There can be no downtime either. What should we do?

    ITKE361,720 pointsBadges:
  • 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!

    ITKE361,720 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.

    ITKE361,720 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...

    ITKE361,720 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!

    ITKE361,720 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?

    ITKE361,720 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!

    ITKE361,720 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?

    ITKE361,720 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