• Upgrade from SQL Server 2005 to 2008

    We're in the process of upgrading our servers from SQL Server 2005 to 2008. It's also running on Windows Server 2003 but we're planning a migration on that too. This will include: Log shipping, packages and reporting server. But here's my question: Should we be worried about the risks of this...

    ITKE380,545 pointsBadges:
  • Can I restore my SQL Server 2012 database backup to SQL Server 2008?

    This probably isn't possible but can I restore my SQL Server 2012 database backup to SQL Server 2008? I'm assuming I can only go forward, not backup.

    ITKE380,545 pointsBadges:
  • What are the best tools for SQL monitoring and SQL diagrams?

    we have SQL 2008, and looking for tools to monitor sql and get sql diagrams. do you know any good tools?

    Persa5 pointsBadges:
  • SQL Server 2008: Write SELECT query to CSV file

    For SQL Server 2008, I'm writing a SELECT query results to a CSV file. Can I do this using T-SQL? And I don't have access to SSIS too (I know you can do it there). Someone told me to use BCP utility - would that work? Thank you in advance.

    ITKE380,545 pointsBadges:
  • SQL Server 2008: Shrink database files

    In SQL Server 2008, is there a way I can shrink my files (log and data) on all of my databases? I've already tried to use SSMS and right click each one but that's way too slow. Is there anything faster?

    ITKE380,545 pointsBadges:
  • SQL Server 2008: Assign Active Directory group security access

    On my domain, I need to have integrated security with my internal app. I've tried several times but it's never really worked out for me. Can I assign an Exchange / Active Directory group a role in SQL Server to have read/write access in specific tables? Just so everyone knows - this is for SQL...

    ITKE380,545 pointsBadges:
  • SQL Server 2008: Counts within a date range

    I need to be able to count an id and the ids duplicates when the createdate is >= 3 months or 90 days (whatever is easier) for the ids createdate. I'm using temp tables and any help would be appreciated as I'm farily new to SQL id CreateDate Counts_id 1 01/01/2015 2 1 04/01/2015 2 2 01/01/2015 1...

    jrming015 pointsBadges:
  • Recover records on SQL Server 2008 table

    In my remote SQL Server 2008 table, I accidentally deleted over a million records. Now, the server won't let me back in and access to the backup files on the server side. How can I get some of these records back?

    ITKE380,545 pointsBadges:
  • SQL Server log file is too big

    We are using SQL Server 2008 with full recovery model, the database size is 10 GB and the log file is 172 GB, we want to clear up the space of the log file internally, we did transaction log file backup it should be clear up , but it still 172 GB. What to do?

    mimiKh5 pointsBadges:
  • How to open SQL Server 2008 after completing installation

    I have installed SQL Server 2008 R2 and how can I start with it after this?

    chinchu5 pointsBadges:
  • Rename SQL Server 2008 instance

    I'm currently using SQL Server 2008 and I need to rename an instance. Is that possible? Thanks!

    ITKE380,545 pointsBadges:
  • Auto calculation of Valuation per unit in SQL Server

    Sir/mam, I have a Table of different product of mutual fund its valuation(nifty level change) is to be calculated. Each product has a different formula which takes input of some variable parameter and some static. How do I calculate row by row formula? (including Average function for eg,...

    ojha1235 pointsBadges:
  • How am I blocking connections to SQL Server 2008?

    This is a fairly specific issue, but I'm at a loss for reasons to what might be happening. We have SQL Server 2008 running on what we'll call ServerA. We can RDP in ServerA, we can ping ServerA. If we RDP into ServerA, we can open up SQL Server Management Studio and connect to all of the database...

    edwinjhoffer3,140 pointsBadges:
  • Problem with SQL Server Database File(.mdf)

    I am using SQL Server 2008 R2 and I want to check my master database file (.mdf) but failed to open it.

    edwinjhoffer3,140 pointsBadges:
  • SQL Server 2008: Job was invoked schedule 188

    After execution, it says job was invoked schedule 188. How can this be solved?

    ike66045 pointsBadges:
  • Encrypt SQL Server 2008 database for PCI compliance

    I'm pretty new to PCI compliance and from what I understand I need to secure a person's credit card info, expiration date and the card holder's name. There's not going to be storage of security codes ever. So in my SQL Server 2008 database, I would need to encrypt these 3 columns? Also, do I need...

    ITKE380,545 pointsBadges:
  • 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,...

    ITKE380,545 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:
  • 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!

    ITKE380,545 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!

    ITKE380,545 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