Claudia

What is a .dbf file?  Is this in Access, or SQL Server?  If it's SQL Server, are all the files in the same filegroup, or is each one in its...

Michelle

If the login name is just Admin and not DomainName\Admin then that suggests it's a SQL login, so I'd say it won't be anything to do with BUILTIN\Administrators, which is...

Yes, just back up the database and restore it on the subscriber.  Then, when you create the subscription using sp_addsubscription, use the @sync_type = 'none' parameter to tell SQL Server...

You can get an estimate of I/O and CPU cost, but in order to translate that into an execution time, the query optimiser would have to guess what hardware you...

Dinakar

The way I understood it, Gavin already has a publication set up and wishes to add another article by restoring the database.  Therefore, I think the safest way is to...

Andrew

You're not going to like this, but I'm afraid it looks like your only choice is to hack your stored procedure and remove the identity column from it.  This seems...

Andrew

1.  There's an option in the properties of the Snapshot Agent to run a script before and/or after the snapshot is run.  I think the only way to do what...

Andrew

1. The terms "primary key" and "index" are not synonymous.  A primary key is a constraint on a column or group of columns such that the value(s) in the column(s)...

You can select getdate() at the beginning and end of the query, but bear in mind this will only be accurate to 3ms.  You can also run Profiler and look...

Gavin

Yes, there is.  Script out the articles you have already created, drop the subscription, restore a backup of the publication database to the subscriber, recreate the subscription using sp_addsubscription with...

No, that's not right.  All NOINIT does is tells SQL Server whether to overwrite what's already in the backup file.  So if you'd backed up with INIT, then Tuesday's differential...

The differential backup records all changes to the database since the last full backup.  So if you wanted to restore on Friday, you'd need Sunday's full backup and Friday's differential...

I notice you're appending your backup to the backup device (WITH NOINIT).  Have you checked that the 9.5GB doesn't consist of more than one backup?

John

Paul

That all depends on what the full names look like.  Are there any double-barrelled surnames or first names that consist of two separate words?  If so, do they have a...

Chris

You could shrink your database, back it up, and then expand it back to 160GB again.  I don't recommend that, though, because it may cause fragmentation on your disk.

Probably best...