I do both, ensure I have a backup and log chain, and do a snapshot, its much quicker to restore from snapshot than backup.

Restoring from snapshot reverts everything you have...

Use an ISO date format and not MDY, or better still, dont use a varchar string to store dates.

declare @table table (count int, eachweek varchar(100))

insert into @table values

(0,'1/1/2013- 1/5/2013'),

(0,'1/13/2013- 1/19/2013'),

(0,'1/20/2013-...

This is how I do it currently, I capture the recovery model in a different proc, but wont be to hard to build it into this

CREATE TABLE [DatabaseFileUsage]

(

[ID] [bigint] IDENTITY(1,1)...

Do you have a custom message broker running?

We get that a lot due to SQL dependencies when our message broker service stops and starts, as it drops and recreates the...

Use the import export data wizard and tell it to ignore truncation errors.

tim.cloud (2/14/2013)

---

Interesting. So, my next question is...do all sessions from other databases need to be disconnected from the version store for versioning to be disabled? If so, this...

Doh. not used cursors in a couple of years, so forgot the syntax.

Please share the steps you did to get it working, in case someone later down the line has the same issue.

Had the same issue in a Dynamics AX setup which needs the snapshot DB level to be on

If we had an issue with the row version store we ran this...

do you have nested triggers config option enabled

whats the output of

select * from sys.configurations where name = 'nested triggers'

But why not just update C and D from within the...

needs to be done in the same session but do

declare @cnt int

select @cnt = count(*) from table

select top 10 *, @cnt from table

So server to server works, but server to workstation doesnt?

Do you have any firewalls controlled by IT which sit between the servers and the workstation VLANs?

balasach82 (2/14/2013)

---

Perry, OPC,

now the db is in one drive. We do have 4 drives. My database is already populate, its 523gb now.

1. Can I create new files in new drive...

You dont have an INIT and FORMAT so it is appending the diff backup to the media set not overwriting it, so it contains all 13 days diff backups.

Highly risky...

The two dont act like a single sign on, but you...