Can someone tell me if the copy database wizard works with MS SQL 2005? I have a fairly large database of about 40gb that I am trying to copy to another server instance on the same piece of hardware. The job does start and appears to 'get into' the process but aborts with the attached log file.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MS SQL 2005 copy database wizard problems.
- Thread starter Peager
- Start date
- Thread starter
- #2
mrdenny
Programmer
- May 27, 2002
- 11,595
Yes the log needs to be on a web server on the net.
The copy database wizzard sucks. Backup the database and restore it.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
My Blog
The copy database wizzard sucks. Backup the database and restore it.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
My Blog
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question