Viewing 15 posts - 16 through 30 (of 69 total)
Ray Mond (2/28/2011)
When creating a backup from TSQL, and using a rented database on a cloud server, is it possible to specify a local path (local in the sense of...
March 1, 2011 at 12:48 pm
While I'm at it, I have one more quick question.
When creating a backup from TSQL, and using a rented database on a cloud server, is it possible to specify a...
February 28, 2011 at 10:40 pm
Ray Mond (2/28/2011)
And the TSQL syntax is to add REPLACE to the WITH clause of the backup.
REPLACE is for restores. It's INIT or FORMAT for backups, depending on your...
February 28, 2011 at 10:37 pm
Ugh.. I should really search more before I ask this sorta question. Turns out it had something to do with ALTERing the views after they are made and moving around...
February 25, 2011 at 4:58 pm
Great it worked. I'm completely new to database backups and recovery so I will look into whats been said. Thanks for all of the advice.
February 4, 2011 at 2:50 pm
Make absolutely sure you don't need anything in your database before you restore it.
Is this to say that it will just restore the structure of the database? I want to...
February 4, 2011 at 2:33 pm
OK, I think I'm getting this figured out. No I don't care about anything thats been done to the database after the point I want to restore to. This is...
February 4, 2011 at 2:18 pm
GilaMonster (2/4/2011)
If it's acceptable and you don't care, RESTORE DATABASE ... WITH REPLACE
What do you mean by this?
So say I have been backing up the database for the last...
February 4, 2011 at 2:00 pm
Sorry I got confused, the server is Windows 2005 R2 running SQL server 2005 Developer edition. The other is who knows but its 2008 SQL server.
February 2, 2011 at 4:34 pm
Sean Lange (12/22/2010)
You could just add select * from myTable to your open query window. 😉
Thanks, but I was just hoping there was something like MS Access uses, its quite...
December 22, 2010 at 2:24 pm
Ok, ya I'm probably not being too terriblely clear here. I have two tabs open. One is just the standard SQLQuery tab where I am writing my query to modify...
December 22, 2010 at 11:16 am
There is no exclamation mark. This is a view of a table not a query. I know in SQL Management studio 2008 the view into a table is actaully a...
December 22, 2010 at 9:22 am
Just incase anyone else sees this I found a link with an example that seems to describe this pretty well.
TransactionLink <-- Click!
December 21, 2010 at 3:18 pm
WayneS (12/21/2010)
December 21, 2010 at 3:15 pm
Viewing 15 posts - 16 through 30 (of 69 total)