for SQL Server 2005, major build version 9.00.xxxx.
0
votes
1answer
30 views
Merge reports 'You must rerun snapshot because current snapshot files are obsolete', gets caught in Death Loop
We have a very large Merge publication for a data warehouse with some large (.bcp files on the order of 20GB) fact tables that is causing us tremendous trouble.
Specifically, we created a publication ...
4
votes
1answer
28 views
Failover scenario with principal “hard down”
My company has a failover pair of SQL Server 2005 instances, which provide database availability for a UL-licensed alarm/call center, where uptime and availability are critical for life safety.
...
1
vote
1answer
19 views
Mysterious merge replication problems creating a subscription
We have a merge publication which had been mostly working OK for a long time (years). Recently an article was added, we were informed the snapshot was out of date, so we regenerated it. Then we got ...
0
votes
2answers
52 views
how to create backup for update tables structures in existing DB?
I have Sql Server DB, I know I can Create thru "Generate Scripts" backup for SP and Functions then I just replace inside the script the "CREATE" with "ALTER", that will update the target DB with the ...
0
votes
0answers
42 views
Cannot recover the master database. SQL Server is unable to run
Right,
I powered off development server because it was hanged, when restarted directory services database was corrupted, so fixed it, then figured out that IIS Manager's metadata.xml is messed up, so ...
0
votes
0answers
32 views
Restoring Master database SQL Server 2005 [duplicate]
Because of sudden power-cut my server has gone down and the master database was corrupted, so I had an old version of (master.mdf) which I copied and pasted to folder C:\Program Files\Microsoft SQL ...
0
votes
1answer
47 views
Updating a local table with a per-row count(*) which is an aggregate of inner joins on remote server
I have a table of around 350m rows on a linked server in which I added an additional INT column to serve as a count(external_identification) of records as the result of a join on PACKAGE and DOC2. ...
0
votes
3answers
85 views
Restoring .bak file SQL Server 2005 in SQL Server 2008
I don't have enough knowledge in SQL Server back and restore. I just want to know is it possible to restore an SQL Server 2005 .bak file in SQL Server 2008? If yes, how can I do it?
0
votes
0answers
27 views
SQL Server 2005 : Splitting Multiple Date Bands Into Individual Dates
How would I go about splitting multiple date bands into individual dates?
So from something like this:
DateStart
2013-01-01
2013-01-06
DateEnd
2013-01-03
2013-01-08
To something like this...
...
2
votes
1answer
128 views
SQL Server 2005 - Query optimization for fetching large number of rows from table with 750 million rows
Brief on application:
This is audio fingerprinting application, being developed in Java with Microsoft SQL Server 2005 database.
I have one application to create fingerprints of original songs and ...
0
votes
2answers
54 views
Lock Pages in Memory keep SQL database engine stuck at allocating 60MB ram?
I'm using Window Server 2003 Enterprise, Microsoft SQL Server 2005 Standard Edition.
The problem is the SQL Server memory gets stuck at allocating 1.7GB RAM max even though I have 11GB of RAM left.
...
1
vote
1answer
93 views
Retrieving data speed tweaks SQL Server 2005
I have a database in Microsoft SQL Server 2005.
I have table with 3 columns, namely HASHKEY (BIGINT), NOTE_ID (INT) and TIME_OFFSET (INT).
Columns HASHKEY has 19 digit BIGINT values, which can ...
1
vote
1answer
45 views
Getting collation confict in IF statment and need help resolving it please
A SQL script I am writing is generating the error:
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP850_CI_AS" in the equal to operation.
I ...
1
vote
1answer
86 views
No SA password. No SQL Server Management Studio. No OS authentication [duplicate]
I have this problem.
I need to do some administrative tasks on a MS SQL Database using SA account.
OS authentication is not set.
SQL Server Manager Manager Studio is not installed.
I have no other ...
1
vote
1answer
63 views
Cannot shrink transaction log
Bit of a headscratcher here.
I have a db that has less than 1GB of data, but a 40GB log file.
Transaction logs are backed up daily, and there is not a lot of activity on this database; approximately ...
