if you plan on using perfom there are a set of key counters to look at, what do you plan to use?

assuming you have the arrays available 😀

humbleDBA (6/18/2008)

---

Colin,

I don't wholy disagree with you on the 64-bit vs 32-bit. In fact in most cases, and for DB servers that have large DBs and require performance then 64-bit...

just for reference and to help others with similar problems what was it you did? 😉

what monitoring tool(s) are you using?

our databases all get set to SA ownership and SA has a secure password.

done this already, use xp_regread to read the values from the registry and output

depending what you are auditing, there would be more options of tracing but you need advanced auditing enabled

the IP address of the machine would also be recorded with the SQL login, depends what you are auditing

detach and re attach, also dont forget to script off your logins and take those across too

ok what logical drives does windows have available on your laptop?

(i.e. do you have a drive E on the laptop?)

How are you attaching the database via SSMS gui or T-SQL...

nagnrik (6/10/2008)

---

TITLE: Microsoft SQL Server Management Studio Express

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

Attach database failed for Server 'Nagraj-PC\SQL2005'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

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

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch....

i figure the restore should be complete at that point though. When creating the job i had the plan backup and restore the target db to the secondary server and...