I always copy the files then remove the originals when the database starts...

Detach removes the database from the system. Offli9ning the database keeps it attached...

saidapurs (9/24/2012)

---

Hi Gail,

I observed the files are not moved particular path, currently Data & log files are in 'C' drive itself.....

When i executed below query get...

Andrew Pruski (9/18/2012)

---

RedGate - SQL DBA Bundle

Quest - LiteSpeed

Idera - SQL Safe Backup v 7.2

If anyone is currently using any of the products, could you let me know what your...

braju (9/21/2012)

---

I have a question on Degree of Parallelism. I basically want to know the best practice or guidelines to set the degree of parallelism. I looked at the...

One further question,

When you set the details on the restore tab did you edit the restore options and enter different paths for the target\secondary data and log files?

Get back to basics, firstly the agent service account on the primary doesn't need any access to the copy location on the secondary server. It doesn't know about it and...

Consult with your vm admin, if memory ballooning becomes a problem you may have to uninstall the balloon driver from the vmware tools but simply having the admin reserve resources...

You'll need to use passthrough authentication. The database engine service account must be able to access the share unchallenged. It's similar to the problems faced in SQL Server log shipping...

you can get a quick and dirty dump using this too

select 'create login ' + QUOTENAME(name) + ' with password = ' +

sys.fn_varbintohexstr(password_hash) + ' hashed, ' +

'sid =...

can you post a screenshot of the point in the wizard where the error appears?

ksr39 (9/21/2012)

---

Hi All,

Thank you for the reply, I have configured the logshipping on this database and from starting the log's are not getting restored to the destination database from the...

siraken (9/20/2012)

---

"The name change cannot be performed because the SID of the new name does not match the old SID of the principal". I tried to install SP2, but still...

thotvedt (9/20/2012)

---

is a domain account with full permissions to the shares in both locations. It completes the initial backup, then goes to the copy and that's where it breaks. ...

Try restarting the mirror endpoint next time instead of the sql server service