[Release] database for last DNC Alpha sources

[magamio]

I have Windows 7 and have problem with SQL Server 2008 *.bak files

Have error like:

That why me make this release

How to see what is your version:
Use this Sql query:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') 

after that you can see:
_______________________________



_______________________________
Here you can download files for SQL Server 2008 - 10.00.4000

*.BAK :

breezenet.bak (1.6 MB)
https://mega.co.nz/#!Yd92DQYY!GZM1Tm...UdXXtQeOpNkvBY

warz.bak (2.3 MB) - (updated link)
https://mega.co.nz/#!5RkjCKiY!AO0ZCy...FZVCtOQ2-0fP1w

*.SQL:

breezenet.sql (49 KB)
https://mega.co.nz/#!xdVwkQZK!Hidnc2...yp_erFsmnWTuyg

warZ.sql (996 KB)
https://mega.co.nz/#!9YNWnY7Y!fvVY-A...v9ZvGgZcWJ8eTU

Files from this sources:
http://forum.ragezone.com/f790/relea...4-26-a-927225/

Give thx for DNC and Team Members: finito GigaToni Crum

[MentaL]

[DNC]

I exported from the Enterprise Edition
Do the .sql files themselves work alright for you now?

Putting a link at the bottom of my latest post in the other thread. Sorry for the inconvenience.

[LayZ Gamer]

May I ask why you say both were created with version .4000 when the warz.bak was made with .1600 so it still does not work. Only the breezenet.bak was .4000

[magamio]

May I ask why you say both were created with version .4000 when the warz.bak was made with .1600 so it still does not work. Only the breezenet.bak was .4000

try now
warz.bak (2.3 MB)
https://mega.co.nz/#!5RkjCKiY!AO0ZCy...FZVCtOQ2-0fP1w

[LayZ Gamer]

try now
warz.bak (2.3 MB)
https://mega.co.nz/#!5RkjCKiY!AO0ZCy...FZVCtOQ2-0fP1w

This one works like a charm, thanks bud!

I have one question. When I add the 4 users to the database, I specify that they are sysadmin and that works excellent. However when I go into User mapping add dbo schema and check off WarZ and breezenet. It gives an error failed to create user. It makes zero sense as I am not creating one simply editing the existing details.

Do you know how to fix this?

TITLE: Microsoft SQL Server Management Studio
------------------------------

Create failed for User 'bn_api_user'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

User, group, or role 'bn_api_user' already exists in the current database. (Microsoft SQL Server, Error: 15023)

For help, click: http://go.microsoft.com/fwlink?ProdN...3&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Lol does it think I am adding the same user again? I am simply editing the properties of the existing user.

Googled the issue, it is because the uploader had the 4 accounts added before creating backup. Thus causing an id mismatch with the 4 accounts i add. Backups needed to be created without adding the 4 users.