Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Hyderabad, A.P., India
    Posts
    29

    Unanswered: Urgent: How to know the sql server's database size

    Hi,

    Can anybody suggest any stored procedure name or C# code to find the Sql database size (database size as well as transaction log)? I want to migrate some data from my local database to the web server. Before migration, i want to know the database size on the web.

    Thanks and regards,
    mrc
    Thanks and regards
    mrc

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    Quote Originally Posted by mrameshchandra
    Hi,

    Can anybody suggest any stored procedure name or C# code to find the Sql database size (database size as well as transaction log)? I want to migrate some data from my local database to the web server. Before migration, i want to know the database size on the web.

    Thanks and regards,
    mrc

    sp_helpdb 'dbNAME'

  3. #3
    Join Date
    Oct 2003
    Location
    Hyderabad, A.P., India
    Posts
    29

    Sql server database size

    That was perfect. Thanks!!

    regards,
    mrc

Posting Permissions

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