This tag is specifially for the R2 version of Microsoft's SQL Server 2008.
3
votes
3answers
2k views
Copy Database option not found in SQL Server Management Studio 2008 R2
I am unable to see the Copy Database option in SQL Server Management Studio 2008 R2.
Can anyone tell me whats going on please?
2
votes
1answer
109 views
Database locked
I canceled a query which took too long time. After that, the SQL-Server database was locked. After I restarted SQL Server, the mode of my database was "in recovery". Now I can't access my database ...
2
votes
2answers
3k views
SQL Server 2008 R2 Management Studio : “Evaluation period has expired”
I've spent several hours trying to fix this issue so far with no success. I had installed SQL Server 2008 Evaluation Edition. Out of fear it might expire & create problems for me I installed SQL ...
2
votes
1answer
224 views
SQL Server : reasons not to use default database settings for ANSI_NULLS?
I've been given a case where a customer is experiencing this error - once in a while:
Msg 8624, Level 16, State 21, Line 1
Internal Query Processor Error:
The query processor could not produce ...
2
votes
1answer
524 views
SQL Server 2005 Tools makes SQL Server 2008 Express install fail
When I tried installing SQL Server 2008 Express, the install failed due to this line. How can I circumvent this, or fix the issue?
2
votes
2answers
156 views
Design best practices for last tracking with indexed view
My tables structure is below :
TbDoc (ID int , ...)
TbDocActions( ID Int, DocID Int, Date DateTime, col1 int, col2 int, ...)
I want to have indexed view to get last TbDocActions columns for ...
1
vote
1answer
307 views
SQL Server 2008 R2 : multiple files and filegroup
I am getting bit confused regarding advantages of multiple files and filegroups in SQL Server
Using SQL Server 2008 R2, I have following filegroups and files configuration
Drive D: Primary Filegroup ...
1
vote
2answers
2k views
Get Job id OR Job name from within executing job
I have a central DB that I write job outcomes on all my servers back to. I pass 3 parameters via powershell in a SQL job back to a sp on the central server that verifies the job should be running at ...
1
vote
4answers
1k views
Attaching database to the SQL server
I have the following error
The database 'Test' cannot be opened because it is version 661. This
server supports versions 655 and earlier. A downgrade path is not
supported.
Usually this kind ...
0
votes
2answers
153 views
Restore the latest backup on the database
We have a stored proc which takes the backup from a database to the specified location. Sometimes the backup process runs more than once. It causes having more than one backup set on the same file ...
0
votes
2answers
617 views
Cannot Attach Database to SQL Server Management Studio 2008 R2
I installed SQL Server 2008 R2 just now and wanted to attach my previous databases. Attaching a Database gives an error.
Attached is the image of the error.
Any Suggestions and help will be ...
