Browse Blog Posts by Tags

All Tags » move (RSS)

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications How to move SQL Server databases to a new...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Oct 5 2007
Filed under: Filed under: sql server, database, kba, disaster recovery, move, detach, attach
How to resolve permission issues when you move a database between servers that are running SQL Server

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications How to resolve permission issues when you move a database between servers that are...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Sep 5 2007
Filed under: Filed under: sql server, database, kba, permission, move, servers
Move tempdb and don't want to use Detach method!

A new Developer within our testing environment asked me this question to see whether they can use DETACH/ATTACH method than using ALTER database method. For the user databases it is available such method of DETACH/ATTACH method when moving the databases...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Aug 27 2007
Filed under: Filed under: sql server, database, move, tempdb, detach, attach
Is it possible to restore all databases from Enterprise Edition to Standard Edition in SQL Server?

Question> Is it possible to restore all the databses from Enterrise Edition to Standard Edition in SQL Server? Answer> Yes and No! Yes is you can restore user databases ( only ) from Standard Edition to Enterprise Edition and vice-versa for further...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jul 2 2007
Filed under: Filed under: sql server, databases, move, system, password
Move SQL Server 2005 error log from its default location

You might get this doubt "How do I move the default log files placed in: C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG to a different location?" This may not be required all the times but say on the partition where these log files...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sun, Jun 17 2007
Filed under: Filed under: sql server, sql express, error log, move, directory

Page 1 of 1 (5 items)

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.

MVP WordPress Blogs

Tags

Browse Blog Posts by Tags

How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server

How to resolve permission issues when you move a database between servers that are running SQL Server

Move tempdb and don't want to use Detach method!

Is it possible to restore all databases from Enterprise Edition to Standard Edition in SQL Server?

Move SQL Server 2005 error log from its default location