Questions tagged [sql-server-2008]
SQL Server 2008 (major build version 10.00.xxxx). Please also tag with sql-server.
3,883 questions
1
vote
1
answer
27
views
Question about using trace files with DMA during SQL Server migration assessment
When using Data Migration Assistant (DMA) for a database migration assessment, there’s an option to provide trace files from the source server for further analysis.
I’m wondering — is there a real ...
2
votes
1
answer
90
views
Upgrading SQL Server 2008 SP3 to SQL Server 2022 Best Upgrade Path and Licensing Questions
I have a requirement to upgrade several SQL Server 2008 SP3 databases to a new environment on new servers running SQL Server 2022. As per Microsoft’s documentation, SQL Server 2008 cannot be upgraded ...
5
votes
3
answers
439
views
Problem with differential backups, after a problem with a full backup
I have a database in Microsoft SQL server 2008 R2, in which I have configured the maintenance plan for backups (a full back on Tuesdays, Thursdays and Saturdays at 00, three transactional logs at 4, 5 ...
- 51
-1
votes
1
answer
53
views
Can the NKTg Law analogy help in modeling database performance under variable data loads?
I recently came across the NKTg Law on Varying Inertia in physics, which describes an object’s movement tendency based on its position (x), velocity (v), and mass (m), with m allowed to change over ...
1
vote
0
answers
104
views
Is it possible to make a batch of “Alter procedure” that are stored in a table?
Currently I have hundreds of sp that are in multiple servers, and that coexist with other sp that are in other servers with linked server.
The origin of this is that when I do a restore of databases ...
-2
votes
2
answers
143
views
Backups twice as large from one day to the next
My SQL Server 2008 R2 production database is running on a dedicated Windows server. It has been running for more than 20 years.
In the last period we have suffered some problems such as freezing ...
- 1
2
votes
2
answers
102
views
Export SQL Server Agent Jobs from a drive
I have a bit of a pickle here. Our old server with SQL Server 2008 was malware infected and been shut down. We've restored the databases from backup into a new server. However, Agent Jobs have not ...
- 254
0
votes
1
answer
131
views
What happens if the Subscriber goes down - will the t-logs keep accumulating on the publisher in Transactional Replication?
I am trying to consider all the options before setting up transactional replication on my 2008R2 server to 2012 distribution server to 2012 Subscriber server. All the three servers are on FULL ...
- 37
0
votes
1
answer
134
views
Setting up Transactional Replication - Can i safely remove transactional replication if it is causing issues on my publisher?
Please excuse me if I am not making very much sense here. I am very new to replication and have been researching for quite some time about transactional replication to implement in our scenario..
I am ...
- 37
-2
votes
1
answer
128
views
Is there any way to send SMS without OLE Automation? [closed]
We use OLE Automation methods such as SP_OAmethod, Sp_Oacreate, etc.. to send SMS to users from SQL Server. I wish to stop use OLE Automation. Is there any alternate way to send SMS?
- 1
0
votes
1
answer
1k
views
Communicating from a SQL Server 2022 to a SQL Server 2008 over linked server
I'm doing a proof of concept to assess whether we can upgrade some our servers piecemeal to SQL Server 2022.
Unfortunately we still have a SQL Server 2008 which holds an old version of Microsoft ...
- 101
0
votes
1
answer
306
views
EVENTDATA() function is giving only null values in sql server
I'm trying to capture logins time with a trigger using EVENTDATA() function.
But It's giving Null values only for all types of events. Can anyone please help me on this?
This is my Trigger
CREATE ...
- 1
0
votes
1
answer
83
views
What could create block in that case when 'blocking' procedure/spid not do any select / almost nothing?
I had situation like this today- sorry that this is screenshot but it is easier way to show what i need to understand
As on screen - many processes was blocked by SPID 91
This SPID 91 querry was as ...
- 113
0
votes
1
answer
241
views
Text Search on Multiple Columns without enabling FULL TEXT Search
I have a scenario where we need to enable a multi-keyword search within a text field. This search should involve scanning the keywords across several columns (approximately 4-6) in multiple tables (...
- 4,083
-3
votes
1
answer
63
views
Build logic on Reversal record flag for a particular table
I have Reversal flag (RF) values as ' ' , 'R' , 'D' which make the records distinct. I am selecting many columns from this table as it is a primary table and taking sum of few columns as well. There ...
