Can you send me a link to his blog please?

Sounds to me you are talking about sharding data across multiple databases and multiple server.

I supported a telco billing application that had an account catalog which contained info about in...

If the SQL browser service is running, I believe you do not need the port number.

What is the difference in the output of xp_logininfo for one of the affected logins when you run it on one of the two servers affected versus one of the...

Did you run all the steps outlined in this article?

http://technet.microsoft.com/en-us/library/ms147921(v=sql.105).aspx

What is the Autogrowth increment on the log file?

Have you double checked?

It looks like you have already the logins there, since the failure is "could not open database"

If not, do as Scott suggested.

Assuming the database user names are the same as the login names,

for each login name/database user name in the the attached database, run:

USE <db_name_here>

GO

ALTER USER <login_name> WITH LOGIN = <login_name>

GO

SQLRNNR (8/7/2014)

---

sqldriver (8/7/2014)

---

Eirikur Eiriksson (8/6/2014)

---

Jeff Moden (8/5/2014)

---

rajeshn29.dba (8/5/2014)

---

Hi Friends,

I would like to know SQL DBA high ended question (5+ years’ experience) what kind of questions they will ASK …………………. Just...

Her is a nice background on the issue;

http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/10/09/i-ve-refreshed-a-test-database-from-prod-but-now-the-users-can-t-access-it.aspx

Even if the new server has all the sql logins on it, the SIDs of the users in the database are different, because the logins were created on a different...

Before you rush out and hire a consultant or try to do this yourself, you have to come up with detailed real requirements for what your HA/DR solution is supposed...

If the primary key is easily traversed (identity, datetime, etc.) you can easily loop through ranges of the primary key value, inserting a few thousand records at a time.

You can...

The best way to do this is to script out the users and their permissions while the test databases are in a good state.

Then:

1. restore from PROD

2. drop all prod...

The job activity monitor will show yo the Next scheduled Run.