Hi community. Please help.
Looking to restore SQL Server 2005 databases between DELL PowerEdge 1850 servers.
Hardware and SQL 2005 systems are all same build and release, service packs.
However, there are quite a few databases: see below
1 4 SystemDatabases (Master, model, msdb, tempdb)
5 Database Snapshots
I am just slightly confused here. Although all databases are being backed up to:
F:\SQL_Backups\<Server Name>\<DB Name Folder>...these files are present inside each folder and several of them.
Transaction log files maybe.
But think I also need the .mdf Files?
All database files have .mdf and .ldf files @ location: "F:\Microsoft SQL Server\MSSQL.1\MSSQL\Data"
Can anybody recommend reading, how to screenshots or tips, comments on SQL Server 2005 restores?
The application to restore here is Team Foundation Server, but if necessary, I will raise another question on that one. The article found here: http://msdn2.microsoft.com/en-us/library/ms404869(VS.80).aspx
states how to restore, but not how to backup.
I've got server database here, just need to backup and restore in SQL Server 2005.