I suggest you go through these 2...

how is the call center setup? Do they work from one location (and copy databases to different locations) OR do they work from each location where database gets copied?

I once faced similar issue and found that one of the applications was continously trying to connect to db. As soon as i restarted server, that app would connect to...

d.m.amine (4/12/2010)

---

hello everyone:

I have a problem at a requet

I want it displayed the same brand product

for example

given DB is like this:

product_id | brand

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

P1 | 300

P2 | 300

P3 | 300

P4 |...

If a table is having clustered index, the non-clustered keys point to the...

You will lose data from the corrupted pages. If you're okay with data loss you can...

bryan van ritter (4/7/2010)

---

Hi pradeep,

another question. is there a way to suggest a user has db-owner rights, to make a trigger which prevents the user from doing a backup/restore or...

I guess no. db owner will have sufficient rights to perform backup restores.

Instead, find out what all privilages that particular user requires, give him those specific rights and remove...

some of the pages of ur databases are corrupt. Do you have a clean backup from where u can restore the database?

AFAIK, resource database is a read only database containing system objects that cannot be attached and used as a user database. Never tried attaching it though..

Paul White NZ (4/7/2010)

---

I should have :w00t:

From technet: http://technet.microsoft.com/en-us/library/cc966495.aspx

Any logon that requires permissions to perform backup or restore operations should be provided membership in the following SQL Server roles:

Server Role : sysadmin

DB role : db_backupoperator, dbo_owner

Permissions...

I've faced this issue in the past. For me, manually registering the SPN resolved the issue.

Here is the syntax for the same.. This has to be run by a domain...

If these are production servers, then strict no-no to do any kind of testing on them or else if something goes wrong u'll find urself nowhere.

then setup clustering between the two servers. Once it is successfully done, start with sql setup. Follow the link i gave earlier.