I have moved a disk array from an old server to a new database server which has sql databases on them. I restored the databases from backup tapes into new databases. I would like to remove the original databases from the array. The new database has not been connected to these original databases. I can see them through Windows Explorer but that is it. Can I just delete these databases via WE or would this create some sort of stranded file issue or other serious issue?
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!
delete an errant database
- Thread starter drallabs
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
If the SQL Server is not talking to the files you can safly delete them.
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
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