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 can't open after installing windows update
I have recently installed windows update on my windows server 2003 machine. After updates when i open sql server 2008, i'm getting a wired error: 'Failed to open connection dialog - object reference not set to an instance of object…
Deepak
- 11
- 1
- 4
0
votes
1 answer
Delete TFS Collection after failure
I created a new TFS Collection and it failed at the end or something didn't go right. I have a new database representing the collection, but when I try to attach it or even list it, TFS can't find the collection.
Is this a bug? Did TFS try and make…
firebellys
- 101
- 2
0
votes
2 answers
Synch SQL 2008 with failover server?
Currently they have a single SQL 2000 Std install on a server that needs to be retired.
They run an app in terminal services to manipulate the data.
So I'm looking at two new servers with SQL 2008 (Workgroup I hope..) one on site, one off connecting…
Kenny M.
- 1
0
votes
4 answers
High Performance Server - what should I Use?
I have a large game engine which serves mobile phone clients and a web site. The DB is MSSQL2008 and the engine is written using C#.
The web site is built with ASP.NET MVC and the web service for the mobile phones is also built on ASP.NET MVC…
Bob
- 3
- 1
0
votes
1 answer
SQL Server instance seems hung, restarting state shows 'change pending...'
I am having trouble with my SQL Server 2008 R2 instance.
First, one of my databases on this instance seems to have crashed. When I try to drop it, I am getting the error message below.
Msg 3702, Level 16, State 3, Line 2
Cannot drop database…
Julius A
- 215
- 3
- 12
0
votes
2 answers
how to Automate the SQL Server 2008 Database and OLAP backup?
I have SQL Server 2008 Enterprise SP2 x64 database in my Windows Server 2008 Enterprise, my question is how to perform automated backup for both database content ? eg. the MDF and the LDF as well as the OLAP database ?
Thanks.
Senior Systems Engineer
- 1,275
- 2
- 33
- 62
0
votes
2 answers
what type of replication transaction should I use?
I can't understand the difference between transactional replication and merge replication. This is my scenario: In an organization I have a SQL server which need to collect information from different sql servers which are located in different parts…
0
votes
1 answer
How to config a Linked server?
How do I config my linked server to connect to the other database with following properties:
ServerName:saleh
user:sa
password:....
Computer IP address:192.168.100.146
Raymond Morphy
- 121
- 2
0
votes
0 answers
Can't start SQL Server 2008 - weird path in the log
I know there are thousands of questions about staring SQL Server, but I can't find the solution to my problem.
I can't start it and the log file reads: CREATE FILE encountered operating system error 21(failed to retrieve text for this error. Reason:…
Burjua
- 111
- 1
0
votes
1 answer
SQL log file growing rapidly
I encountered SQL Database log file growing rapidly and filled up the Hard Disk space, the growth was approximately 190MB per day.
there is Sharepoint running in the server, how can I check what causes the log files size increase? could it because…
sams5817
- 167
- 6
0
votes
1 answer
Restrict Users to View Reports in SSRS 2008
I would like to restrict the users to view reports in SSRS 2008.i.e; I want the user to view only 2 reports out of 20.I tried creating a new user with appropriate role and gave the user only the permission to view the two reports. But I couldn’t…
user18576
- 169
- 3
- 8
0
votes
2 answers
Enabling AWE Memory for SQL Server 2008 on Windows 2008 R2
Would you suggest using AWE Memory on Windows 2008 R2 for MS SQL 2008?
What are the benefits of using it or not using it.
Thanks
RPS
- 3
- 3
0
votes
1 answer
Restoring SQL Server 2008 R2
I am running SQL Server 2008 R2 Standard Edition on a Windows Server 2008 R2 Enterprise. I'm using the standard backup and restore for the server portion and the native SQL Backups for the databases.
I want to exempt the Transaction Log and Data…
DavidStein
- 153
- 1
- 5
0
votes
2 answers
SQL 2008. Help to pick right replication model
The database is end of day data storage with some reporting.
We fill db with data for a particulate date every day.
Time to time users' reports block import processes (run from C# apps and then with sprocs processing data on the SQL side).
So my…
Boppity Bop
- 752
- 3
- 11
- 34
0
votes
3 answers
About is downgraded or replacing SQL Server 2008
SQLServer2008 is on a PC. When we upgraded to SQLServer2008, an ODBC error started to appear:
State: 37000,Native: 155,Origin: [Microsoft][Sql Natize Client][SQL Server]
'TRUNCATE_ONLY' is not recognized as a BACKUP option.
Now this is error…
freddiefujiwra
- 1,667
- 5
- 25
- 34