0
votes
0answers
37 views

The fulltext catalog upgrade failed because of an inconsistency in metadata between sys.master_files and sys.fulltext_catalogs

I am using sql server 2008 and when trying to restore .bak file I'm getting this error: The fulltext catalog upgrade failed because of an inconsistency in metadata between sys.master_files and ...
0
votes
1answer
72 views

Should I use backup compression for databases where all data is already compressed?

In SQL server with enterprise edition, there are databases with all the tables/indexes compressed. Does it still make sense to do compressed backup?
3
votes
2answers
411 views

checksum(newid()) as primary key - what happens if a collision occurs?

Inspecting a rather critical database that is used by some software on my system, I found that one of the tables had a primary key on the column Id, where Id is calculated using checksum(newid()). ...
0
votes
2answers
440 views

SQL Server account delegation setup

I am try to run bulk insert command on SQL Server 2008 but I am having issues with the security. after researching via internet, the problem has something to do with account delegation and ...
1
vote
1answer
628 views

How to create database, and add user linked to login?

created a login and a user in the master database and linked that user to the login. I created a new database, then went to that database and immediately tried to create a user linked to the same ...
2
votes
2answers
139 views

Upgrade SQL Server 2008 Express to SQL Server Workgroup 2008 Volume License

I'm in need of some help with SQL Server. I’m fairly new to SQL Server so bear with me. My situation: We currently have SQL Server 2008 Express installed and running on Windows Server 2003. We are ...