Question about Microsoft SQL Server Standard Edition for PC

1 Answer

Need solution............. how to automate the backup of a sql server2005?i need clear solution immediately pls.......

Posted by on

  • thaenu Oct 17, 2007

    what compiler required,did yo explain in detail?

×

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Compiler require

Posted on Oct 17, 2007

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

How to convert SQl server 2005 to SQL server 2008


upgrade it or
take backup of your database
install sql server 2008
Restore backup in sql server 2008

Feb 05, 2011 | Office Equipment & Supplies

5 Answers

Need Help to backup SQL database in safe mode


kindly choose the option safe mode with networking and then try.

Sep 10, 2009 | Microsoft Computers & Internet

4 Answers

How get sql data backup


there is facility in enterprise manager to take back of database!

Feb 04, 2009 | Keystone Active Server Pages (ASP)/Visual...

4 Answers

Restoring files from the database


I suggest you use the Enterprise manager (gui tool to manage SQL).
Restoring a single table is not an option.
You can however restore a file or filegroup.
Make sure to backup before you start and NOT to restore database to its original name or original file location, to avoid acidents.
Normally you will have databases with only 2 files: the data at its Primary file group, and log file.
You may wish to create a new file group and move tables to the new group by recreating them there and exporting data from old table to new table. Then recreate indexes. This may prove to be complex as all tables and indexes have unique names and can't coexist with exact duplicate of them.

oh yea..... did I say backup?
well just in case backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup
but dont overwrite that backup

Feb 11, 2008 | Microsoft SQL Server 2000 Standard Edition...

1 Answer

Sql script


Hi,

The best way to accomplish your task is to Start SQL Management Studio. Go to Management, there you will see Maintanence Plans. When you create a new maintanence plan there is a wizard that will walk you through eveything. (What, where and when to backup). Maintanence plans can also do much more like DBCC (consistancy checks) log truncation and more.

If you're backing up to a folder on another server, just make sure the folder is shared.

Hope that helps.

Dan

Nov 21, 2007 | Microsoft SQL Server Standard Edition for...

1 Answer

Scripts


open sql server management studio and go to Management -->Maintenance Plans and create a maintanance plan for this.

Oct 17, 2007 | Microsoft SQL Server Standard Edition for...

3 Answers

Hi...........


Well there is more than one or two answers 4 that.
you should first check if you are at simple recovery mode. If not (now this will sound strange) right click the database, click tasks/backup and make a LOG backup.
Now right click databases and click Restore Database.
You should choose a new database name (for restore practice) .
You will probably have your last backups at the bottom of the screen...if not click add and choose you latest data backup.
click the log backup and the data backup should be checked , too. on options tab make sure the database is left ready to use.

Oct 16, 2007 | Microsoft SQL Server Standard Edition for...

Not finding what you are looking for?
Microsoft SQL Server Standard Edition for PC Logo

Related Topics:

39 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

3015 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...