Forum Replies Created

Viewing 15 posts - 271 through 285 (of 430 total)

  • RE: Database Mirroring vs Log Shipping

    TheSQLGuru (8/3/2011)

    Jonathan Marshall (8/1/2011)

    I'm looking to set up a HA solution between databases that are about 1000 miles apart and also the network is less then reliable. Reading through articles...

    August 3, 2011 at 6:35 am

    #1362981

  • RE: Shrink database while restoring

    Ninja's_RGR'us (8/3/2011)

    chandan_jha18 (8/3/2011)

    sehgalnamit (8/3/2011)

    Can we shrink the database files while restoring from backup?

    First find out why you need to shrink:

    1) If you see that there is a lot of space...

    August 3, 2011 at 6:33 am

    #1362974

  • RE: Sqlserver 2000 DTS designer components are required to edit the dts packages. Install the special web download "SQLSERVER 2000 DTS Designer Components " to use this package

    If the DTS designer components have been installed for the backward compatibility, you need to register some dll files(can't recall which file) and then reboot the server. Try rebooting the...

    August 3, 2011 at 4:42 am

    #1362911

  • RE: Installing SQL server 2008R2

    Sumanta Roy (8/3/2011)

    Hi,

    While running the setup.exe I am getting the error message

    "SQL Server setup media does not support the language of the OS or does not have ENU localized files....

    August 3, 2011 at 4:38 am

    #1362910

  • RE: Shrink database while restoring

    sehgalnamit (8/3/2011)

    Can we shrink the database files while restoring from backup?

    First find out why you need to shrink:

    1) If you see that there is a lot of space left in...

    August 3, 2011 at 4:36 am

    #1362909

  • RE: Upgrade SQL 2008 to SQL 2008 R2

    Mary Truesdell (8/2/2011)

    I can copy and paste the info from the "summary" files in the installation log files. Would that help? Event viewer seemed to only give really vague errors....

    August 2, 2011 at 12:16 pm

    #1362467

  • RE: Upgrade SQL 2008 to SQL 2008 R2

    Mary Truesdell (8/1/2011)

    I am trying to upgrade from SQL 2008 to SQL 2008 R2 and it keeps failing to upgrade the database engine services. Can anyone help me figure out...

    August 2, 2011 at 2:06 am

    #1361979

  • RE: grant users with read access to 20 databases

    sqlfriends (8/1/2011)

    We have about 20 archived database on a server along with other databases.

    We would like to grant about 10 people read access to those 20 archived databases.

    What is the...

    August 2, 2011 at 1:05 am

    #1361963

  • RE: How do I give SQL Server 2008 R2 More Ram?

    Ninja's_RGR'us (8/1/2011)

    markpringle (8/1/2011)

    Thanks SSC-Addicted

    His name is MysteryJimbo. Addicted is based on his # of points on the site.

    😀

    August 2, 2011 at 12:53 am

    #1361962

  • RE: Export Import Wizard

    Brandie Tarvin (8/1/2011)

    chandan_jha18 (8/1/2011)

    Is this the correct way and matches the answers in your mind while you replied here:-)

    Yes. That is the correct way.

    Something to be aware of, though. If...

    August 1, 2011 at 9:12 am

    #1361635

  • RE: Export Import Wizard

    Brandie Tarvin (8/1/2011)

    chandan_jha18 (7/29/2011)

    chandan_jha18 (7/29/2011)

    Brandie Tarvin (7/29/2011)

    The best way to do it is script the tables, indexes, etc. over to your destination server. Then use the Export Import Wizard to...

    August 1, 2011 at 8:40 am

    #1361588

  • RE: Export Import Wizard

    chandan_jha18 (7/29/2011)

    Brandie Tarvin (7/29/2011)

    The best way to do it is script the tables, indexes, etc. over to your destination server. Then use the Export Import Wizard to append the data...

    July 29, 2011 at 12:16 pm

    #1361010

  • RE: Export Import Wizard

    Brandie Tarvin (7/29/2011)

    The best way to do it is script the tables, indexes, etc. over to your destination server. Then use the Export Import Wizard to append the data to...

    July 29, 2011 at 10:59 am

    #1360946

  • RE: Execute Permission Denied on SQL Login

    Brandie Tarvin (7/29/2011)

    chandan_jha18 (7/29/2011)

    Can you please explain what you meant by saying that the website was using a domain account?

    The website that hosts the reports also pulls data from various...

    July 29, 2011 at 6:23 am

    #1360713

  • RE: sql server agent does not show up on sql2008 database

    You need to ask your DBA to provide you SQLagent user and SQLAgentReader role in MSDB database. then you will be able to see the agent in the management studio.

    Chandan

    July 29, 2011 at 5:32 am

    #1360687

Viewing 15 posts - 271 through 285 (of 430 total)