Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2008]

A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.

SQL Server 2008 is Microsoft's version of SQL Server following SQL Server 2005. A list of the new features can be found here

1806 questions
0
votes
1 answer

Transferring 60GB of data over fiber connection - VPN connection times out

In an attempt to transfer a 60GB file (SQL database file) over the wire via a VPN connection, we're only able to get about 1/8 the file over. How can we get around this timeout issue? Or do we have ways to break apart the file into multiple…
JustBeingHelpful
  • 1,964
  • 7
  • 37
  • 53
0
votes
1 answer

SQL Server 2008 R2 and copy-only default value in SQL Server Management Studio

We are using Tivoli Storage Manager for taking backups of the database but sometimes our consultants need to take separate backup copies of the database using Management Studio. If they forget to mark the "copy-only" flag in Management Studio they…
user102718
  • 1
0
votes
2 answers

Can't connect to SQL server on dev server

I'm using VS2008 on my local machine for writing an ASP.Net app. Our SQL Server 2008 instance is hosted remotely on a dedicated database server. I can connect to the server through my app on both my local machine and production server, but not on…
James Hay
  • 481
  • 1
  • 3
  • 10
0
votes
3 answers

SQL Server Sizing

I need to create a design to meeting the following requirements for a coupon system coupons to be issued every 6 weeks each issuance will give approx 90m coupon instances coupon instance record can be deleted once it's over 6 months old total…
tr0users
  • 413
  • 3
  • 11
  • 16
0
votes
4 answers

Windows Server 2008 R2 secure enough for internet without 3rd party (hardware) firewall

I need to setup a Windows2008 Server R2 incl. SQL Server and IIS. The server is as far as I know directly connected to the internet. My question is, is Windows 2008 R2 Server secure enough for this usage? Are there any known security risks? Will the…
nWorx
  • 113
  • 7
0
votes
2 answers

Sql Server Simple Recovery - Backup selective file groups

I have a large database, ~100 gig or so, and about 5 gigs of it is mission critical data, the rest, I could reload from a web service, so it's not crucial. Backing up that data is expensive, and not worth it, when it could just be reloaded. So, I…
bladefist
  • 355
  • 1
  • 3
  • 13
0
votes
3 answers

How to warehouse data that is not needed from MS SQL server

I have been asked to truncate a large table in MS SQL Server 2008. The data is not needed but might be needed once every two years. It will NEVER have to be changed, only viewed. The question is, since I don't need the data on a day-to-day basis,…
Alex Gordon
  • 455
  • 3
  • 14
  • 31
0
votes
1 answer

How to create non-clustered indexes on a SQL Server 2008 database? Preferably without code?

I would appreciate help on how to create non-clustered indexes on a SQL Server 2008 database without using code--or rather, 'statically' once and for all prior to running any SQL queries (that probably does not make sense, but my point being I don't…
PaulDecember
  • 5
  • 1
  • 1
  • 4
0
votes
1 answer

Remote connect to SQL Server 2008

I have a problem connecting with a remote Microsoft SQL Server 2008 I have tried this: How to enable remote connections for SQL Server 2008? so the remote connection checkbox is checked at the database properties and in the SQL Server Configuration…
JP Hellemons
  • 267
  • 6
  • 16
0
votes
1 answer

Convert MYSQL DATABASE TO MSSQL DATABASE

I would like to ask if there is a software that convert all my database from mysql to mssql 2008
yolem
  • 1
  • 1
0
votes
2 answers

Cannot install Adventure Works DB to Sql Server because Install Instance drop down is blank

I am trying to install the Adventure Works database onto an instance of SQL Server but i cannot get any instance entries listed in the dialog as below: I have enabled FileStream and TextIndexing is installed. This is a 64 bit Sql Server Instance…
rism
  • 301
  • 2
  • 12
0
votes
1 answer

How to execute rskeymgmt utility silently in windows server 2008

When i run reskeymgmt.exe - to create a backup copy of the encryption key, it responses "Are you sure want to extract the key from the Report Server? Yes (y)/ No (n)?" I found this link which helps me to automate the execution of reskeymgmt…
linh dinh
0
votes
2 answers

Restore database to SQL server 2008 from SQL server 2005

I need to restore my database to SQL server 2008. Currently we are having our database in SQL Server 2005 in one server. We need to take the back up of that database and move that database to SQL server 2008 in another server. I can find the steps…
Karthik
  • 1
  • 2
0
votes
2 answers

SQL Server 2008 R2 SQL Server has encountered x occurrence(s) of I/O requests taking longer than 15 seconds to complete on file

When I alter or create a stored procedure directly on production or QA database, after a few seconds I start experience timeouts and application becomes unavailable. Log files shows this error: SQL Server has encountered 3 occurrence(s) of I/O…
Natalia
  • 101
  • 1
0
votes
1 answer

SQL Server "failed to retrieve text" -- how to resolve?

When SQL Server throws permissions errors (or other OS errors), it generally logs something of the form "Cannot open file {blah}. Operating system error 3 (failed to retrieve text for this message)". It's a simple one: what is it that's stopping SQL…
Chris J
  • 1,218
  • 18
  • 32
1 2 3
…
99 100