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
Questions tagged [sql-server-2008]
1806 questions
0
votes
1 answer
SQL Server 2008 R2 Databases "Suspect" after Logs Moved
We have a client using our software with MSSQL and we are trying to solve a problem for them. We work more with MySQL so pardon my ignorance in the ways of MSSQL Server.
They have 3 volumes on that physical server: C:\; D:\; and L:\
The D:\ volume…
Aaron
- 301
- 2
- 12
0
votes
2 answers
Is an ms-sql/excel connection two way?
When I connect to an external data source on my MS-SQL server using Excel, is it solely an import, or can I edit the data residing on the MS-SQL server right from Excel?
I have a user (the DBA, funny enough) that swears up and down that it's doable,…
Justin
- 167
- 1
- 3
- 12
0
votes
1 answer
Migrate existing database to mirrored database on Azure
I have setup 3 Sql VM's on Azure for database mirroring as described in this link with the idea being that we move our current database, which is currently on a single VM outside of Azure. Everything works so far, except now I am stumped at how I…
Peuge
- 113
- 4
0
votes
2 answers
Offline database can't be restored: Exclusive access could not be obtained
I'm practicing a SharePoint 2010 to 2013 migration and having trouble restoring a database. After backing up a database on a SP2010/SQL 2008 server, I'm trying to restore it to a database I've freshly created on my SP2013/SQL 2012 server.
Though the…
tnw
- 213
- 1
- 3
- 9
0
votes
2 answers
SQL server databases are stucked in restoring state
I have a single server in my SharePoint 2010 server farm. Today some of users complained about that some of Infopath forms can not be opened. When I checked the SOL Server Management Studio I saw that some of my databases are in Restoring state as…
Pooya Yazdani
- 277
- 5
- 12
0
votes
1 answer
How can I choose databases once in SQL Server 2005/2008 maintenance plan tasks?
Is there any way to choose the databases I want to operate on once in my maintenance plan without having to choose them for each separate task? I have a setup that precludes me from choosing the "All user databases" option.
GuyBehindtheGuy
- 225
- 6
- 13
0
votes
1 answer
How to create a new sql server instance without installation media
I'm relatively new to SQL Server installations ( however I use extensively the Management Studio), the situation is that I have a server (machine) where the SQL Server has been installed ( not by me or by someone that I can ask ), but there is no…
Javier Mr
- 111
- 1
- 3
0
votes
2 answers
Possible to take a backup of SQL Server 2012 DB and restore on 2008?
I want to take a backup of SQL 2012 and restore on 2008, is that possible ?
I have this options which I can't change on DB. Thank you
RayofCommand
- 1,451
- 8
- 26
- 36
0
votes
0 answers
SQL Server Error - HRESULT E_FAIL has been returned from a call to a COM component
I have a huge 200MB .SQL file. When I try to open this in SQL server management studio 2008, I get the error -Error HRESULT E_FAIL has been returned from a call to a COM component.
What could the reason be and how to fix it ? Is this caused due to…
Steam
- 101
- 4
0
votes
1 answer
Login failed for user 'sa'. ...... [CLIENT: 59.48.47.215]
I have an Amazon EC2 instance and i don't have anything running on it yet but my event log is full of below error
"Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows…
Parham
- 101
0
votes
2 answers
SS2008-Express: Would like to add the database engine to an existing installation
The first time around, I only wanted to upgrade my SQL Server Management Studio from 2005 to 2008. So that's what I did, via the Microsoft Web Platform Installer.
Now however, I'd like to install a SQL Server 2008 Express database engine…
Jim G.
- 338
- 2
- 6
- 15
0
votes
1 answer
The timeout period elapsed prior to obtaining a connection from the pool
I have a WPF application which I want to use on multiple machines.
I can connect to it on the same machine but I can't connect from another machine. I know I have to enaple TCP/IP connection and I have to start server browser, but the error which…
Lóri Nóda
- 115
- 3
0
votes
1 answer
SQL 2008 R2 User Connections and Total Server Memory counters spike at the same time on multiple servers
We use SolarWinds SAM software to monitor servers and applications. We started using it to monitor our SQL servers through the performance counters.
We started getting alerts two to three times daily saying that the "Total Server Memory" and "User…
blizz
- 1,134
- 1
- 26
- 47
0
votes
1 answer
sa account not working anymore on SQLServer2008
I have been running SQLServer 2008 for some years now on my laptop.
At a certain point I cannot login anymore with my sa account (mixed authentication turned on).
I get the error message 233. This happened when I attempted to install a new…
Tom
- 1
0
votes
1 answer
Don't have permission to access SQL Server Express 2008?
Possible Duplicate:
Don’t have permission to access SQL Server Express 2008??
I have a remote PC with SQL Server 2008 setup and allowing remote connections.
I am an Admin user on the PC and have remotely connected to the SQL Server and I am…
Jan Zelezny
- 153
- 1
- 1
- 3