Ensure you restore the model and MSDB too.

Do you have any experience of starting\operating SQL Server in single user mode?

slipstream is used at product install not post product install. You will have to apply the service pack as usual.

For future reference see my article at this link[/url] detailing...

daveFromIll (12/21/2011)

---

We have a set up where our backups are backed up to a shared drive on a another server on a nightly basis. This was working fine until...

mahesh.dasoni (12/17/2011)

---

Log are been backed up every 15 mins on primary server & same is copied and restored on DR server every 15 minutes.

But in MSDB database(Primary server)-the table log_shipping_monitor_primary...

To stop services remotely open the services.msc on your machine. In the top left of the services console where you see "Services (local)", right click and select "connect to another...

pallavi.unde (12/16/2011)

---

I run the script below

USE master

GO

IF OBJECT_ID ('sp_hexadecimal') IS NOT NULL

DROP PROCEDURE sp_hexadecimal

GO

CREATE PROCEDURE sp_hexadecimal

@binvalue varbinary(256),

@hexvalue varchar (514) OUTPUT

AS

DECLARE...

Chris Metzger (12/21/2011)

---

Is anyone doing this? I am attempting to restrict access per instance (multiple instances per SQL Server) so that only a specific source IP or hostname can...

okbangas (12/21/2011)

---

A little piece of missing information: You describe some of the differences between MBR and GPT, but in my opinion you lack the most important one: MBR can only...

Care to share the resolution, it may help others in future

once you complete the restore and upgrade from 2000 to 2008 you must run the following against the database

DBCC UPDATEUSAGE

Followed by

DBCC CHECKDB WITH DATA_PURITY

Then go rebuild all your indexes...

as already mentioned, see my article at this link[/url] for more info on setting up and using mount points for SQL Server

Are you taking regular backups of the publication\distribution databases?

Is...

See my link above 😉

check the event log for any messages.

Take the group offline and then bring the resources up 1 at a time in the following sequence

1/ IP address

2/ Network name

3/...

a replicated database cannot really be considered a true 100% copy of your original database, what if a connection needs to use an object you have not replicated to the...