offline,rename,online would have been quicker and the better solution in this case. 😉

yes I saw that but its not an MS supplied script.

contradictory advice. trunc log on chkpoint is SQL 7 version of simple mode.

simple you can...

Mischa E.J. Hoogendoorn (11/8/2010)

---

. Looking on the internet did give me the following query:

DECLARE @srv sysname

SET @srv = CAST(SERVERPROPERTY('ServerName') AS sysname)

UPDATE sysjobs SET originating_server = @srv

That query...

GSquared (11/9/2010)

---

It's possible that your VLFs are blocking the shrink. It's possible (I think) that a sector in use near the end of the file will prevent shrinking and...

sys.master_files is the 2005 and above equivalent of sysaltfiles. Expect sysaltfiles to be deprecated, so I recommend getting in the habit of using sys.master_files.

first off you could have gone straight to service pack 2 and missed out service pack 1 install, they are cumulative.

to fix your problem, log onto server with SSMS, right...

query table msdb..restorehistory.

why are you using the copy database method? Why not backup\restore or detach\attach?

Unless it is changed after creation, the database owner will be the userid who created the database, so check that.

well firstly I never advise on major configuration changes without caveats, after all I won't be the one to suffer any consequences.

The /3GB switch reduces memory available to the OS,...

Your memory is being allocated dynamically, on a server with only 4GB memory this is what you want.

Use task manager to see amount of memory it is using (sqlservr.exe), or...

About 100 instances and a big user of MOM (soon migrating to SCOM). You can add your own scripts to it so we do extra things like look for things...

or right click on the server name in the left hand pane in SSMS

bills in the post 🙂