rishgup (3/24/2009)

---

I checked at Support.microsoft.com

here is the link http://support.microsoft.com/kb/918992

in the remarks it said

"If server A and server B are in different domains, you have to modify the output script....

mine would also work in both 2000 and 2005 if you replaced the master.sys.sysdatabases with master..sysdatabases

its the reference to the sys schema and the column recovery_model_desc that are 2005 specific

Cobra,

what do you mean by this?

deleting data in the database itself wont wrap round the log file,...

it would be possible once the mirror database had been bought online.

which SP?

To avoid having to use sp_change_users_login transfer the logins to server 'S' using MS supplied proc sp_help_revlogin. google that you will find it easy or go straight to technet.

or

select name, DatabasePropertyEx(name,'Recovery') as model

from master.sys.sysdatabases

where dbid > 4

order by 2

this is fun. Next.

I cannot remember if there was an option to shrink files via EM in SQL 7 as I always did it via QA. If there is is I would think...

Mohit, you might have your terminology non-standard. see http://msdn.microsoft.com/en-us/library/ms191456.aspx

Mohit (3/22/2009)

---

The other thing you should note is since your secondary server will be at a distance from your main data-center if...

tracey - previous post edited (SQLCMD)

TRACEY (3/21/2009)

---

Interesting thing here, as I had neglected to move the resource database files out of the way, the reinstall did NOT overwrite the existing resource database, so having done...

yep, its the replacement for rebuildm.exe in SQL2000.

I prefer not to be totally reliant on either of them!

look up running setup from the command line in BOL, but basically you are telling the setup program you want to replace the system database files (In the case of...

mirroring is at the database level so yes an instance can be principal for some databases and mirror for others. I do a simialar thing but with log shipping.

seems to...

BlackHawk (3/20/2009)

---

Hey all,

I've been reading BOL and sites on the web but have yet to find answers that make me feel 100% sure that I understand whether or not you...