Fun. Good reads. I'll try again in a few days. If it still hits my quality
bone I may send a little money their way.
Thanks for sharing.
On Wednesday, October 1, 2014, Cameron Childress wrote:
>
> Thought I'd share this. A few on the list might enjoy reading some of the
> articles. Especially
On Wed, Oct 1, 2014 at 1:13 PM, William Bowen
wrote:
> If the version is the same, then Backup/Restore.
Thanks for the replies!
We're going from 2005 to 2008R2. The reason I was looking at
mirroring/replication was because we have about 2 weeks of uptime on the
new database servers where the
Actually, thinking about this a bit more... It might be even easier to
simply detach the database, copy it over then re-attach on the new server.
It's the same basic process, but you are omitting the back-up which isn't
really necessary if you're able to take the system down during the
t
Definitely agree with Jeff here.
If the version is the same, then Backup/Restore.
If the version is 2005 or 2000, then:
http://msdn.microsoft.com/en-us/library/ms177429(v=sql.105).aspx
Also agree that the 75GB database shouldn't be too much trouble.
On Wed, Oct 1, 2014 at 9:23 AM, Jeff Garza
If the database servers are the same version (or the database your
migrating from is a lower version), I would just do a backup and restore to
the new server. This is by far, the easiest mechanism by which to get all
the data, users, and structure from one server to another.
How much downt
What version are the current DBs?
On Wed, Oct 1, 2014 at 6:58 AM, C. Hatton Humphrey
wrote:
>
> We're rebuilding our network infrastructure and this includes rebuilding
> one web/data and one puer data server from scratch. The apps require MS
> SQL Server up to 2008 so that's what has been ins
We're rebuilding our network infrastructure and this includes rebuilding
one web/data and one puer data server from scratch. The apps require MS
SQL Server up to 2008 so that's what has been installed. The databases on
the pure data server are huge in some cases (75gb).
If you had time (we're 2