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
2 answers
How do I backup a sql server 2008 database snapshot?
How do I backup a database snapshot, so I can restore it as another database (on same or different server?)
We do not wish to roll back to the snapshot, as we need both versions of the database active for testing upgrade scripts.
Ian Ringrose
- 870
- 1
- 6
- 12
0
votes
1 answer
SQL connection with mirroring still working after a failover
I have a windows service application that is instaled on two servers, SQL01 and SQL02. On both server there is a SQL server (X1 and X2), which have the same content. A mirroring partnership was set up for one database, called Interface.
Both…
David Brunelle
- 135
- 1
- 7
0
votes
1 answer
move 2008 sql database .mdf and .ldf files to a new folder location
Logical Name
my_Data
my_Log
Path:
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA
FileName:
my.MDF
my_1.LDF
What would be the sql script to move these…
FiveTools
- 197
- 6
0
votes
2 answers
Hardware Calculate for Sql Server 2008
How can i calculate recommended hardware for a sql server ?
How can i implement hardware plan for sql server ?
After Edit:
My Application is Designed By Silverlight.
I 30 table in my database and i store picture or pdf files in some tables.
I have…
Hossein Moradinia
- 207
- 1
- 2
- 8
0
votes
1 answer
installing SQL Server 2008 R2 with advance options
I am trying to install the SQL Server 2008 R2. I have uninstalled the previous versions of SQL Server from my machine and also deleted SQL Server folder from c:\Program Files.I select New installation or ad features to SQL installation, when setup…
DotnetSparrow
0
votes
1 answer
Can SQL 2008/2008 R2 Resource Governor be used to prevent queries from blocking?
I have been researching the Resource Governor in SQL 2008 and SQL 2008 R2. I gather that I can only really use this to limit the CPU and memory used by certain sessions. It seems strange to me, though, because if I use a governed session to create…
rayrayrayraydog
- 145
- 3
- 9
0
votes
1 answer
If i were to develop a software for DBA's to help them in query optimization, what features could i incorporate?
What would be your expectations from such a software. I am planning to show the DBA a list of the top cpu and memory intensive queries along with the query plan, etc. How could i assist the DBA more to help him optimize his queries ? What kind of…
Chani
- 145
- 8
0
votes
1 answer
Store data on File Server or SQL database
We have a solution which includes storage of PDF documents.
Currently we have 50,000 documents that are 0.6 MB each (all documents same size)
We currently store these documents in varbinary(max) fields in SQL Server.
Everything works fine…
Shiraz Bhaiji
- 2,229
- 9
- 34
- 47
0
votes
1 answer
Error while installing sql server 2008 - "the collation was not found"
In the server configuration page of my Microsoft sql server 2008 setup, the database engine field in the collation tab is empty.
I think it should be having "SQL_Latin1_General_CP1_CI_AS" written there but it doesn't. The textbox is disabled so i…
raj vardhan
0
votes
1 answer
Management studio bug
This is on SQL 2008 R2 x64
I have installed management studio on all the computers at work, but for no apparent reason my management studio does not work on one of them. I've uninstalled it and reinstalled it twice now.
Symptoms: Management studio…
Azshlanar
- 49
- 1
- 7
0
votes
1 answer
Using a subscriber database as a backup
I am trying to set up a transactional replication database on two MSSQL 2008 Standard servers. We need to be able to query off of the subscriber database, but we would also like to be able to use the subscriber as a backup if the primary server…
MrZander
- 101
- 1
0
votes
1 answer
Server restarted when I take database backup in SQL Server 2008?
I have 10 databases in my SQL Server 2008.
If I take a database backup, 8 databases are working just fine.
When I take database backup for the remaining two, at 50% of backup of process, the server automatically restarted. So I am not able to…
kanth
0
votes
0 answers
Sql Server 2008 Backup and Restore
I have a Critical Production Database for sql server 2008 which is in Simple Recovery Model Currently. I have to change the Recovery Model back to Full. I have to develop a Strategy to take Full, Differential and Transactional Log Backups. So my…
Faiz
- 1
0
votes
1 answer
Backup and Restore Strategy in sql server 2008
I have a production critical database which is in Simple Recover Model Currently. We take a Full Backup Every night at 2:30AM. Now I have to change the recovery model back to full. I have to design the backup and restore strategy to include the…
faiz
0
votes
3 answers
SQL Server 2008 Login Problem
I'm trying to install yet another forum on my local machine, and while I'm configuring the database connection I got this message
Failed to connect:
Login failed for user 'NT
AUTHORITY\NETWORK SERVICE'.
I have served Google and I found that I…
Amira Elsayed Ismail
- 127
- 3