Moving SQL Server Databases and a few random thoughts on moving to SQL Server 2005

Posted by: Rick Strahls WebLog, on 13 Feb 2006 | View original

Sql Server Backup and Restore operations are a drag. Well sort of. I've been moving over my databases from my old development machine to my new machine and the process is a lot more painful than it should. I can't quite figure out how to easily move files between two machines, but the process I've been using goes something like this:   Do a full backup to file Then restore from the backup a query window like this. First: RESTORE FILELISTONLY FROM DISK = 'c:\sqlbackups\webstore.bak'   to...

Advertisement
The leading UI suite for ASP.NET - Telerik radControls
Outstanding performance. Full ASP.NET AJAX support. Nearly codeless development.

Similar Posts

  • SQL/e - Microsoft to release an Embedded Database version of SQL Server more
  • SQL/e - Microsoft to release an Embedded Database version of SQL Server more
  • SQL Server FAQ : How to join tables from different servers more
  • Getting SQL Server registry settings via SQLCLR table-valued user-defined function... more
  • Bulkload Sample Code more
  • SqlDependency changes for RTM [Sushil Chordia] more
  • SqlDependency changes for RTM [Sushil Chordia] more
  • Getting started with SQL Native Client [Chris Lee] more
  • Getting started with SQL Native Client [Chris Lee] more
  • Getting started with SQL Native Client [Chris Lee] more

News Categories

.NET | ADO.NET | Agile | Ajax | Architecture | ASP.NET | BizTalk | C# | Certification | Community Server | dasBlog | DataGrid | DataSet | Debugger | DotNetNuke | Events | GridView | IIS | Indigo | JavaScript | Mobile | Mono | Patterns and Practices | Performance | Podcast | Refactor | Regex | Security | Sharepoint | Silverlight | Smart Client Applications | Software | SQL | VB.NET | Visual Studio | W3 | WCF | WinFx | WPF | WSE | XAML | XLinq | XML | XSD