Viewing 15 posts - 43,501 through 43,515 (of 49,571 total)
Leo (10/28/2008)
Thanks. I add another maintenance plan for transaction log only.
You need to have them in different plans because they have to run at different intervals. Remember what the point...
October 28, 2008 at 6:36 am
No. I mean the import/export wizard
From object explorer in management studio, right click a database, select tasks, select Import Data
October 28, 2008 at 4:19 am
You can't backup the log of a database in simple recovery mode. The point of simple is that the log is not retained and backups of it are not required.
October 28, 2008 at 4:18 am
What's your reason for clustering? What are you trying to gain?
October 28, 2008 at 4:16 am
It doesn't make any difference what the server's service accounts are. As long as you're connecting with an account (windows or sql) that has login rights on the other server.
Windows...
October 28, 2008 at 4:12 am
You don't, directly. First open it in a text editor and remove everything but the file names. Once you're got the file cleaned up, you can use the import/export wizard...
October 28, 2008 at 4:07 am
There should be a file called dirinfo.txt in whatever directory you ran that from, not in the snap directory.
October 28, 2008 at 3:50 am
Means that either the server isn't running, you've mistyped the name, or there's a firewall or similar preventing connections.
Can you ping the second server from there?
October 28, 2008 at 3:48 am
marg131 (10/27/2008)
October 28, 2008 at 3:37 am
DIR "E:\Visual Studio Solution\Web Application\Template\Snaps" > dirinfo.txt
October 28, 2008 at 3:36 am
If you're already deleted the encrypted content, then there's no point in getting the keys back.
Last time I had to do that, all of the connection strings were reset....
October 28, 2008 at 3:34 am
Can you maybe give the table structure, a few sample rows and your desired output please?
October 28, 2008 at 3:27 am
When you say registration, what exactly do you mean?
Blank sa password? That's rather dangerous.
October 28, 2008 at 2:39 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic592622-145-1.aspx
October 28, 2008 at 2:37 am
When specifying generic commands, angular brackets are used as placeholders, indicating that something needs to be put in their place, not that they need to be there. See the command...
October 28, 2008 at 2:35 am
Viewing 15 posts - 43,501 through 43,515 (of 49,571 total)