Results 1 to 5 of 5

Thread: I detached a database from SQL Server Object Explorer

  1. Apr 8th, 2024, 01:15 PM #1
    arizona_mike87
    arizona_mike87 is offline

    Thread Starter
    Junior Member
    Join Date
    Dec 2023
    Posts
    31

    I detached a database from SQL Server Object Explorer

    How do I get it back? There's no attach option.
    Reply With Quote Reply With Quote
  2. Apr 8th, 2024, 01:32 PM #2
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: I detached a database from SQL Server Object Explorer

    There should be...
    https://learn.microsoft.com/en-us/sq...h-a-database-1
    In SQL Server Management Studio Object Explorer, connect to an instance of SQL Server Database Engine, and then select to expand that instance view in SSMS.

    Right-click Databases and select Attach.

    In the Attach Databases dialog box, to specify the database to be attached, select Add. In the Locate Database Files dialog box, select the location where the database resides and expand the directory tree to find and select the .mdf file of the database; for example:

    Code:
    C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\AdventureWorks2022_Data.mdf
    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  3. Apr 8th, 2024, 11:51 PM #3
    jmcilhinney
    jmcilhinney is offline
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,100

    Re: I detached a database from SQL Server Object Explorer

    Are you talking about the Object Explorer window in SSMS or the Server Explorer window in VS? I'm assuming the former but, even if it's the latter, this question has nothing to do with VB.NET. Please post in the most appropriate forum for the topic. Thread moved.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL
    Reply With Quote Reply With Quote
  4. Apr 9th, 2024, 04:40 PM #4
    arizona_mike87
    arizona_mike87 is offline

    Thread Starter
    Junior Member
    Join Date
    Dec 2023
    Posts
    31

    Re: I detached a database from SQL Server Object Explorer

    Sorry about poasting on the wrong board guys...

    Ah, so you do it in SSMS... you'd think if there's a 'detach' option in VS they could just add an 'attach' option too... oh well...

    Got it working, thanks. Cute pups!
    Reply With Quote Reply With Quote
  6. Apr 9th, 2024, 09:40 PM #5
    jmcilhinney
    jmcilhinney is offline
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,100

    Re: I detached a database from SQL Server Object Explorer

    I just took a look and realised that your terminology was accurate in the first place - there is a window named SQL Server Object Explorer in VS. Not one I've ever used as I don't think it can do anything that SSMS can't and I always use that.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width