ALTER DATABASE foo SET READ_ONLY

GO

Then, put a custom step in your maintenance plan so reindexing, etc doesn't fail (or exclude it from that part):

ALTER DATABASE foo SET RESTRICTED_USER

GO

ALTER DATABASE foo...

Scozzard (10/1/2009)

---

@philcart Writing scripts would definitely be a good idea, if it becomes any more complex or any more issues come up I will probably go down that road.

GilaMonster (10/1/2009)

---

Trying to restore atop a DB restored with recovery gives the error message (at least in SQL 2008)

Msg 3117, Level 16, State 1, Line 1

The log or differential backup...

The column you're requesting in the SELECT statement (SNP_SectionLearner.SectionID) does not exist.

Although the SNP_SectionLearner table is in your inline query, the inline query does not return that column in table...

william.crawley (10/1/2009)

The error message we receive is:

This differential backup cannot be restored because the database has not been restored to the correct earlier state.

Msg 3013, Level 16, State 1,...

Yes I did - thanks for catching that.

MJM

1. I always start with a Profiler trace to see if I can see any pain points. Normally I just select the Default Trace Profile and add dbid...

This is what I have used (SQL 90+):

EXEC sp_MSForEachDB 'SELECT ''?'' AS [Database Name], su1.name AS [Database User Name], su2.name AS [Database Role]

FROM [?].sys.database_role_members r

INNER JOIN [?]..sysusers su1 ON su1.[uid]...

For me personally, the...

We run *almost* everything off of an Enterprise SAN, and we still do SQL backups.

Since this is an ASP/hosted deal I would make SURE that if you can't get SQL...

BACKUP LOG MyBrain WITH TRUNCATE_ONLY;

UPDATE dbo.Self SET Status = 'BACK_AT_WORK' WHERE Status = 'ON_HOLIDAY'

GO

Should get ya fixed right up 😛

Been there, done that, have the t-shirt 😎

Our upgrades done in the fashion you describe were all very successful. Make sure to run the upgrade wizard and resolve any...

There may be a more elegant way of doing this, but you could create a temporary staging table and do the following:

SET NOCOUNT OFF

INSERT mydb.dbo.foo

FROM 'C:\foo.txt'

WITH (

FIELDTERMINATOR = '|'

...

Got it - thanks to PESO whose post I found out elsewhere on the Interwebs. It's number of seconds since UNIX epoch, just in ten millionths of a...

In each of the 2005 --> 2008 migrations I have done, they involve BACKUP/OFFLINE/RESTORE methodology. However, you indicated you're doing bulk load.

I personally don't have experience in SSIS with...